Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('notice_entity_id_seq'::regclass) |
|
|
||||
| type | varchar | 255 | null |
|
|
|||||
| entity_type_id | int8 | 19 | null |
|
|
|||||
| entity_id | int8 | 19 | null |
|
|
|||||
| notice_id | int8 | 19 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| notice_entity_pkey | Primary key | Asc | id |
| notice_entity_entity_type_id_index | Performance | Asc | entity_type_id |
| notice_entity_notice_id_index | Performance | Asc | notice_id |
| notice_entity_type_entity_type_id_entity_id_notice_id_unique | Must be unique | Asc/Asc/Asc/Asc | type + entity_type_id + entity_id + notice_id |