delivery_session_appointment

0 rows


Description

links between sessions and appointments for a referral

Columns

Column Type Size Nulls Auto Default Children Parents Comments
delivery_session_id uuid 2147483647 null
delivery_session.id fk_delivery_session_appointment_delivery_sessionR
appointment_id uuid 2147483647 null
appointment.id fk_delivery_session_appointment_appointmentR

Indexes

Constraint Name Type Sort Column(s)
pk_delivery_session_appointment Primary key Asc/Asc delivery_session_id + appointment_id
idx_delivery_session_appointment_appointment__id Performance Asc appointment_id
idx_delivery_session_appointment_delivery_session__id Performance Asc delivery_session_id
uk_delivery_session_appointments_appointment_id Must be unique Asc appointment_id

Relationships