delivery_session

0 rows


Description

session details for a referral

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
delivery_session_appointment.delivery_session_id fk_delivery_session_appointment_delivery_sessionR
referral_id uuid 2147483647 √ null
referral.id fk_delivery_session_referralR
session_number int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_delivery_session Primary key Asc id
bk_delivery_session Must be unique Asc/Asc referral_id + session_number
idx_delivery_session_referral__id Performance Asc referral_id

Relationships

Close relationships within degrees of separation