Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| referral_id | uuid | 2147483647 | null |
|
|
the id of the draft referral connected to risk information |
||||
| updated_at | timestamptz | 35,6 | null |
|
|
when the draft oasys risk information was last updated |
||||
| updated_by_id | text | 2147483647 | null |
|
|
who updated the draft oasys risk information |
||||
| risk_summary_who_is_at_risk | text | 2147483647 | √ | null |
|
|
OASYS Risk Summary - who is at risk? |
|||
| risk_summary_nature_of_risk | text | 2147483647 | √ | null |
|
|
OASYS Risk Summary - nature of risk |
|||
| risk_summary_risk_imminence | text | 2147483647 | √ | null |
|
|
OASYS Risk Summary - risk imminence |
|||
| risk_to_self_suicide | text | 2147483647 | √ | null |
|
|
OASYS Risk to Self - suicide |
|||
| risk_to_self_self_harm | text | 2147483647 | √ | null |
|
|
OASYS Risk to Self - self harm |
|||
| risk_to_self_hostel_setting | text | 2147483647 | √ | null |
|
|
OASYS Risk to Self - hostel setting |
|||
| risk_to_self_vulnerability | text | 2147483647 | √ | null |
|
|
OASYS Risk to Self - vulnerability |
|||
| additional_information | text | 2147483647 | √ | null |
|
|
OASYS Additional risk information |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| draft_oasys_risk_information_pkey | Primary key | Asc | referral_id |
Relationships
Close relationships within degrees of separation
