Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| alert_code_id | bigserial | 19 | √ | nextval('alert_code_privileged_user_alert_code_id_seq'::regclass) |
|
|
Foreign key to alert code |
||||
| username | varchar | 64 | null |
|
|
The username of the person who can administer the alert |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| alert_code_privileged_user_pkey | Primary key | Asc/Asc | alert_code_id + username |
| idx_alert_code_privileged_user_alert_code_id | Performance | Asc | alert_code_id |
| idx_alert_code_privileged_user_username | Performance | Asc | username |