supplier_assessment_appointment

0 rows


Description

links between supplier assessments and their appointments for a referral

Columns

Column Type Size Nulls Auto Default Children Parents Comments
supplier_assessment_id uuid 2147483647 null
supplier_assessment.id fk_supplier_assessment_supplier_assessmentR
appointment_id uuid 2147483647 null
appointment.id fk_supplier_assessment_appointments_appointment_idR

Indexes

Constraint Name Type Sort Column(s)
supplier_assessment_appointment_pkey Primary key Asc/Asc supplier_assessment_id + appointment_id
uk_supplier_assessment_appointments_appointments_id Must be unique Asc appointment_id

Relationships

Close relationships within degrees of separation