Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('notice_id_seq'::regclass) |
|
|
||||||
| uuid | uuid | 2147483647 | null |
|
|
|||||||
| created_at | timestamptz | 35,6 | √ | CURRENT_TIMESTAMP |
|
|
||||||
| updated_at | timestamptz | 35,6 | √ | CURRENT_TIMESTAMP |
|
|
||||||
| unread | bool | 1 | √ | true |
|
|
||||||
| deleted | bool | 1 | √ | false |
|
|
||||||
| notice_detail_id | int8 | 19 | null |
|
|
|||||||
| recipient_id | int8 | 19 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| notice_pkey | Primary key | Asc | id |
| notice_deleted_index | Performance | Asc | deleted |
| notice_notice_detail_id_index | Performance | Asc | notice_detail_id |
| notice_recipient_id_deleted_unread_index | Performance | Asc/Asc/Asc | recipient_id + deleted + unread |
| notice_recipient_id_unread_index | Performance | Asc/Asc | recipient_id + unread |
| notice_unread_index | Performance | Asc | unread |
| notice_updated_at_index | Performance | Asc | updated_at |
| notice_uuid_unique | Must be unique | Asc | uuid |