Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| referral_id | uuid | 2147483647 | null |
|
|
referral unique identifier |
||||
| disabilities | _text | 2147483647 | √ | null |
|
|
information about disabilities |
|||
| dob | date | 13 | √ | null |
|
|
date of birth |
|||
| ethnicity | text | 2147483647 | √ | null |
|
|
ethnicity |
|||
| first_name | text | 2147483647 | √ | null |
|
|
service user’s first name |
|||
| last_name | text | 2147483647 | √ | null |
|
|
service user’s last name |
|||
| preferred_language | text | 2147483647 | √ | null |
|
|
the preferred language of the service user |
|||
| religion_or_belief | text | 2147483647 | √ | null |
|
|
the religion or belief system of the service user |
|||
| gender | text | 2147483647 | √ | null |
|
|
the service user’s gender |
|||
| title | text | 2147483647 | √ | null |
|
|
the service user’s title |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| referral_service_user_data_pkey | Primary key | Asc | referral_id |
Relationships
Close relationships within degrees of separation
