Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | null |
|
|
|||||
| referral_id | uuid | 2147483647 | null |
|
|
referral connected to this case note |
||||
| subject | text | 2147483647 | null |
|
|
subject of the case note |
||||
| body | text | 2147483647 | null |
|
|
main body text of the case note |
||||
| sent_at | timestamptz | 35,6 | null |
|
|
date time for when the case note was created |
||||
| sent_by_id | text | 2147483647 | null |
|
|
the officer who created the case note |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| case_note_pkey | Primary key | Asc | id |
| ix_case_note_referral | Performance | Asc | referral_id |
Relationships
Close relationships within degrees of separation
