# Suggestion

**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#L604)

## Fields

| Field | Type | Required | Key |
|---|---|---|---|
| `id` | `String` | ✓ | PK |
| `documentId` | `String` | ✓ |  |
| `originalText` | `String` | ✓ |  |
| `suggestedText` | `String` | ✓ |  |
| `positionStart` | `Int` | ✓ |  |
| `positionEnd` | `Int` | ✓ |  |
| `status` | `SuggestionStatus` | ✓ |  |
| `reviewComment` | `String` | - |  |
| `suggestedById` | `String` | ✓ |  |
| `createdAt` | `DateTime` | ✓ |  |
| `updatedAt` | `DateTime` | ✓ |  |

## Diagram

```mermaid
erDiagram
    Suggestion {
        id String [PK]
        documentId String
        originalText String
        suggestedText String
        positionStart Int
        positionEnd Int
        status SuggestionStatus
        reviewComment String?
        suggestedById String
        createdAt DateTime
        updatedAt DateTime
    }
    Suggestion ||--|| User : ""
    Suggestion ||--|| Document : ""
```

## Relationships

- HAS_ONE → `User`
- HAS_ONE → `Document`