Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| appointment_id | uuid | 2147483647 | null |
|
|
appointment’s unique identifier |
||||||
| appointment_delivery_type | appointment_delivery_type | 2147483647 | null |
|
|
type to denote how the appointment is delivered |
||||||
| nps_office_code | varchar | 7 | √ | null |
|
|
National Probation Service office code if the appointment delivery type is ‘IN_PERSON_MEETING_PROBATION_OFFICE’ |
|||||
| appointment_session_type | appointment_session_type | 2147483647 | √ | 'ONE_TO_ONE'::appointment_session_type |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pk_appointment_delivery_appointment_id | Primary key | Asc | appointment_id |
Relationships
Close relationships within degrees of separation
