Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | null |
|
|
service user’s action plan unique identifier |
||||
| referral_id | uuid | 2147483647 | null |
|
|
service user’s action plan referral unique identifier |
||||
| number_of_sessions | int4 | 10 | √ | null |
|
|
number of sessions the service user will have |
|||
| created_by_id | text | 2147483647 | null |
|
|
who the service user’s action plan was created by |
||||
| created_at | timestamptz | 35,6 | null |
|
|
when the service user’s action plan was created |
||||
| submitted_by_id | text | 2147483647 | √ | null |
|
|
who submitted the service user’s action plan |
|||
| submitted_at | timestamptz | 35,6 | √ | null |
|
|
when the service user’s action plan was submitted for approval |
|||
| approved_at | timestamptz | 35,6 | √ | null |
|
|
when the service user’s action plan was approved |
|||
| approved_by_id | text | 2147483647 | √ | null |
|
|
who approved the service user’s action plan |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| action_plan_pkey | Primary key | Asc | id |
| idx_action_plan_referral_id | Performance | Asc | referral_id |
Relationships
Close relationships within degrees of separation
