# DocIssueReport

**Kind:** Database Model

**Source:** [`atloria-monorepo/libs/database/prisma/schema.prisma`](https://github.com/sherkety/atloria/blob/main/atloria-monorepo/libs/database/prisma/schema.prisma#L2772)

## Fields

| Field | Type | Required | Key |
|---|---|---|---|
| `id` | `String` | ✓ | PK |
| `ticketNumber` | `Int` | ✓ |  |
| `projectId` | `String` | ✓ |  |
| `documentId` | `String` | - |  |
| `pageUrl` | `String` | ✓ |  |
| `pageTitle` | `String` | - |  |
| `sectionHeading` | `String` | - |  |
| `category` | `IssueCategory` | ✓ |  |
| `description` | `String` | ✓ |  |
| `reporterEmail` | `String` | - |  |
| `reporterSessionId` | `String` | ✓ |  |
| `scrollPosition` | `Float` | - |  |
| `userAgent` | `String` | - |  |
| `browserInfo` | `String` | - |  |
| `ticketType` | `TicketType` | ✓ |  |
| `chatSessionId` | `String` | - |  |
| `status` | `IssueStatus` | ✓ |  |
| `priority` | `IssuePriority` | ✓ |  |
| `closedReason` | `IssueCloseReason` | - |  |
| `assigneeId` | `String` | - |  |
| `resolvedAt` | `DateTime` | - |  |
| `closedAt` | `DateTime` | - |  |
| `snoozedUntil` | `DateTime` | - |  |
| `firstAgentReplyAt` | `DateTime` | - |  |
| `createdAt` | `DateTime` | ✓ |  |
| `updatedAt` | `DateTime` | ✓ |  |
| `comments` | `DocIssueComment[]` | ✓ |  |
| `activities` | `DocIssueActivity[]` | ✓ |  |
| `boardCards` | `BoardCard[]` | ✓ |  |

## Diagram

```mermaid
erDiagram
    DocIssueReport {
        id String [PK]
        ticketNumber Int [AUTO]
        projectId String
        documentId String?
        pageUrl String
        pageTitle String?
        sectionHeading String?
        category IssueCategory
        description String
        reporterEmail String?
        reporterSessionId String
        scrollPosition Float?
        userAgent String?
        browserInfo String?
        ticketType TicketType
        chatSessionId String?
        status IssueStatus
        priority IssuePriority
        closedReason IssueCloseReason?
        assigneeId String?
        resolvedAt DateTime?
        closedAt DateTime?
        snoozedUntil DateTime?
        firstAgentReplyAt DateTime?
        createdAt DateTime
        updatedAt DateTime
        comments DocIssueComment[]
        activities DocIssueActivity[]
        boardCards BoardCard[]
    }
    DocIssueReport ||--|| Project : ""
    DocIssueReport ||--|| User : ""
```

## Relationships

- HAS_ONE → `Project`
- HAS_ONE → `User`

## Referenced By

- `User` (HAS_ONE)
- `DocIssueComment` (HAS_ONE)
- `DocIssueActivity` (HAS_ONE)
- `BoardCard` (HAS_ONE)