desired_outcome

146 rows


Description

reference data desired outcomes available for each intervention service category

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
end_of_service_report_outcome.desired_outcome_id fk_desired_outcome_idR
referral_desired_outcome.desired_outcome_id fk__referral_desired_outcome__desired_outcomeR

service-owned unique identifier
description text 2147483647 null

describes what the outcome should be for the service user
service_category_id uuid 2147483647 null
service_category.id fk__desired_outcome__service_categoryR

the ID of the intervention service category it belongs to

Indexes

Constraint Name Type Sort Column(s)
desired_outcome_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation