referral_desired_outcome

0 rows


Description

desired outcome details

Columns

Column Type Size Nulls Auto Default Children Parents Comments
referral_id uuid 2147483647 null
referral_selected_service_category.referral_id fk_referral_desired_outcome_service_category_idR
draft_referral.id fk__referral_desired_outcome__referralR

referral unique identifier
desired_outcome_id uuid 2147483647 null
desired_outcome.id fk__referral_desired_outcome__desired_outcomeR

desired outcome unique identifier
service_category_id uuid 2147483647 null
referral_selected_service_category.service_category_id fk_referral_desired_outcome_service_category_idR

Indexes

Constraint Name Type Sort Column(s)
ix_referral_desired_outcome__referral_id Performance Asc referral_id
referral_desired_outcome_referral_id_service_category_id_de_key Must be unique Asc/Asc/Asc referral_id + service_category_id + desired_outcome_id

Relationships

Close relationships within degrees of separation