interventions_ci
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
supplier_assessment_appointment
0
rows
Description
links between supplier assessments and their appointments for a referral
Columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
supplier_assessment_id
uuid
2147483647
null
supplier_assessment
.id
fk_supplier_assessment_supplier_assessment
R
appointment_id
uuid
2147483647
null
appointment
.id
fk_supplier_assessment_appointments_appointment_id
R
Showing 1 to 2 of 2 entries
Indexes
Search:
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
Showing 1 to 2 of 2 entries
Relationships
Close relationships within degrees of separation
One
Two degrees
