Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
The unique care plan risk ID. @example 123 |
| company_id | int8 |
|
|
The company this care plan risk belongs to. @example 1 |
| help_plan_id | int8 |
|
|
The care plan associated with this risk. @example 1 |
| risk_category_id | int8 |
|
|
The risk category associated with this care plan risk. @example 1 |
| level | varchar |
|
|
The level of risk for this care plan risk, one of “low”, “moderate”, “high”, “very_high”. @example “high” |
| created_at | timestamp |
|
|
The time that the care plan risk was created (in UTC). @example ‘2026-01-01T00:00:00’ |
| updated_at | timestamp |
|
|
The time that the care plan risk was last updated (in UTC). @example ‘2026-01-01T00:00:00’ |
| archived_at | timestamp |
|
|
The time the care plan risk was archived. @example ‘2026-01-01T00:00:00’ |
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| archived_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_care_plan_risks_pkey | Primary key | Asc | id |
| idx_edge_care_plan_risks_company_id | Performance | Asc | company_id |
| idx_edge_care_plan_risks_help_plan_id | Performance | Asc | help_plan_id |
| idx_edge_care_plan_risks_risk_category_id | Performance | Asc | risk_category_id |