Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| alert_type_id | bigserial | 19 | √ | nextval('alert_type_alert_type_id_seq'::regclass) |
|
|
Internal primary key. Not returned by API |
||||
| code | varchar | 12 | null |
|
|
The short code for the alert type |
|||||
| description | varchar | 40 | null |
|
|
The description of the alert type |
|||||
| list_sequence | int4 | 10 | √ | null |
|
|
Migrated list sequence from NOMIS. Not used |
||||
| created_at | timestamp | 29,6 | null |
|
|
The date and time the alert type was created |
|||||
| created_by | varchar | 64 | null |
|
|
The username of the user who created the alert type |
|||||
| modified_at | timestamp | 29,6 | √ | null |
|
|
The date and time the alert type was last modified |
||||
| modified_by | varchar | 64 | √ | null |
|
|
The username of the user who last modified the alert type |
||||
| deactivated_at | timestamp | 29,6 | √ | null |
|
|
The date and time the alert type was deactivated |
||||
| deactivated_by | varchar | 64 | √ | null |
|
|
The username of the user who deactivated the alert type |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| alert_type_pk | Primary key | Asc | alert_type_id |
| idx_alert_type_code | Must be unique | Asc | code |
| idx_alert_type_created_at | Performance | Asc | created_at |
| idx_alert_type_deactivated_at | Performance | Asc | deactivated_at |
| idx_alert_type_list_sequence | Performance | Asc | list_sequence |