Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('case_note_sub_type_id_seq'::regclass) |
|
|
Internal primary key. Not returned by API |
||||
| type_code | varchar | 12 | null |
|
|
Foreign key to case note type |
|||||
| code | varchar | 12 | null |
|
|
Public unique identifier and the short code for the case note sub-type |
|||||
| description | varchar | 80 | null |
|
|
The description of the case note sub-type |
|||||
| active | bool | 1 | true |
|
|
Active status of the case note sub-type |
|||||
| created_at | timestamp | 29,6 | null |
|
|
The date and time the case note sub-type was created |
|||||
| created_by | varchar | 64 | null |
|
|
The username of the user who created the case note sub-type |
|||||
| last_modified_at | timestamp | 29,6 | √ | null |
|
|
The date and time the case note sub-type was last modified |
||||
| last_modified_by | varchar | 64 | √ | null |
|
|
The username of the user who last modified the case note sub-type |
||||
| sensitive | bool | 1 | true |
|
|
Case notes categorised by a sensitive sub-type may contain sensitive information and should only be displayed to POMs |
|||||
| restricted_use | bool | 1 | true |
|
|
Only POMs can add case notes categorised with a restricted use sub-type |
|||||
| sync_to_nomis | bool | 1 | false |
|
|
Whether the case notes associated with a sub-type are included in the two-way sync with NOMIS or exist only in the DPS database |
|||||
| dps_user_selectable | bool | 1 | true |
|
|
Whether the sub-type can be selected by a user or case notes categorised by the sub-type are system generated |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| case_note_sub_type_pkey | Primary key | Asc | id |
| idx_case_note_sub_type_sync_to_nomis | Performance | Asc | sync_to_nomis |
| unq_case_note_type_code_and_code | Must be unique | Asc/Asc | type_code + code |