referral_selected_service_category

0 rows


Description

selected service categories for each referral

Columns

Column Type Size Nulls Auto Default Children Parents Comments
referral_id uuid 2147483647 null
referral_complexity_level_ids.referral_id fk_referral_complexity_level_ids_complexity_level_ids_keyR
referral_desired_outcome.referral_id fk_referral_desired_outcome_service_category_idR
draft_referral.id fk_referral_idR
service_category_id uuid 2147483647 null
referral_complexity_level_ids.complexity_level_ids_key fk_referral_complexity_level_ids_complexity_level_ids_keyR
referral_desired_outcome.service_category_id fk_referral_desired_outcome_service_category_idR
service_category.id fk_service_category_idR

Indexes

Constraint Name Type Sort Column(s)
pk_referral_selected_service_category Primary key Asc/Asc referral_id + service_category_id

Relationships

Close relationships within degrees of separation