Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| code | varchar | 12 | null |
|
|
Public primary key and the short code for the case note type |
||||||||
| description | varchar | 80 | null |
|
|
The description of the case note type |
||||||||
| created_at | timestamp | 29,6 | null |
|
|
The date and time the case note type was created |
||||||||
| created_by | varchar | 64 | null |
|
|
The username of the user who created the case note type |
||||||||
| last_modified_at | timestamp | 29,6 | √ | null |
|
|
The date and time the case note type was last modified |
|||||||
| last_modified_by | varchar | 64 | √ | null |
|
|
The username of the user who last modified the case note type |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| case_note_type_pkey | Primary key | Asc | code |