Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| case_note_id | uuid | 2147483647 | null |
|
|
Foreign key to case note |
|||||
| varchar | 64 | null |
|
|
The username of the user who authored (created) the amendment |
||||||
| varchar | 80 | null |
|
|
The first and last name of the user at the time the amendment was created. Does not update if their name changes |
||||||
| note_text | text | 2147483647 | null |
|
|
The text of the amendment |
|||||
| created_at | timestamp | 29,6 | null |
|
|
The date and time the amendment was created |
|||||
| created_by | varchar | 64 | null |
|
|
The username of the user who created the amendment |
|||||
| varchar | 64 | null |
|
|
The NOMIS staff id of the user who created the amendment. This is a NOMIS internal primary key used to support consuming services reliant on it |
||||||
| id | uuid | 2147483647 | gen_random_uuid() |
|
|
Public primary key |
|||||
| system | varchar | 6 | 'DPS'::character varying |
|
|
The system used to create the amendment. Either DPS or NOMIS |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| case_note_amendment_pkey | Primary key | Asc | id |
| case_note_amendment_case_note_id | Performance | Asc | case_note_id |
| idx_case_note_amendment_created_at | Performance | Asc | created_at |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| check_system | (((system)::text = ANY ((ARRAY['DPS'::character varying, 'NOMIS'::character varying])::text[]))) |