Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| notification_id | uuid | 2147483647 | null |
|
|
||||||
| company_id | uuid | 2147483647 | null |
|
|
||||||
| user_id | uuid | 2147483647 | null |
|
|
||||||
| target_type | varchar | 30 | null |
|
|
||||||
| target_id | uuid | 2147483647 | null |
|
|
||||||
| route | varchar | 255 | null |
|
|
||||||
| title | varchar | 255 | null |
|
|
||||||
| is_read | bool | 1 | false |
|
|
||||||
| occurred_at | timestamptz | 35,6 | null |
|
|
||||||
| created_at | timestamptz | 35,6 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| notification_pkey | Primary key | Asc | notification_id |
| idx_notification_company_user_read_occurred | Performance | Asc/Asc/Asc/Desc | company_id + user_id + is_read + occurred_at |
Relationships
Close relationships within degrees of separation
