Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| alert_code_id | bigserial | 19 | √ | nextval('alert_code_alert_code_id_seq'::regclass) |
|
|
Internal primary key. Not returned by API |
|||||||
| alert_type_id | int8 | 19 | null |
|
|
Foreign key to alert type |
||||||||
| code | varchar | 12 | null |
|
|
The short code for the alert code |
||||||||
| description | varchar | 40 | null |
|
|
The description of the alert code |
||||||||
| list_sequence | int4 | 10 | √ | null |
|
|
Migrated list sequence from NOMIS. Not used |
|||||||
| created_at | timestamp | 29,6 | null |
|
|
The date and time the alert code was created |
||||||||
| created_by | varchar | 64 | null |
|
|
The username of the user who created the alert code |
||||||||
| modified_at | timestamp | 29,6 | √ | null |
|
|
The date and time the alert code was last modified |
|||||||
| modified_by | varchar | 64 | √ | null |
|
|
The username of the user who last modified the alert code |
|||||||
| deactivated_at | timestamp | 29,6 | √ | null |
|
|
The date and time the alert code was deactivated |
|||||||
| deactivated_by | varchar | 64 | √ | null |
|
|
The username of the user who deactivated the alert code |
|||||||
| restricted | bool | 1 | false |
|
|
Can the alert code be administered by all users (false) or named users only (true)? |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| alert_code_pk | Primary key | Asc | alert_code_id |
| idx_alert_code_alert_type_id | Performance | Asc | alert_type_id |
| idx_alert_code_code | Must be unique | Asc | code |
| idx_alert_code_created_at | Performance | Asc | created_at |
| idx_alert_code_deactivated_at | Performance | Asc | deactivated_at |
| idx_alert_code_list_sequence | Performance | Asc | list_sequence |