Constraints

41 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
fk_rails_81e897bb97
appointments.facility_id
facilities.id
Restrict delete
fk_rails_0145dd0b05
patient_phone_numbers.patient_id
patients.id
Restrict delete
fk_rails_1c30d535fa
treatment_groups.experiment_id
experiments.id
Restrict delete
fk_rails_ba05256ae6
treatment_group_memberships.patient_id
patients.id
Restrict delete
fk_rails_b892696282
treatment_group_memberships.experiment_id
experiments.id
Restrict delete
fk_rails_14fd76db1b
treatment_group_memberships.treatment_group_id
treatment_groups.id
Restrict delete
fk_rails_4b8f85a6e7
treatment_group_memberships.appointment_id
appointments.id
Restrict delete
fk_rails_e47574ce84
accesses.user_id
users.id
Restrict delete
fk_rails_58af12b1a9
estimated_populations.region_id
regions.id
Restrict delete
fk_rails_8e56e1055e
blood_sugars.facility_id
facilities.id
Restrict delete
fk_rails_7c63b0ef2d
blood_sugars.user_id
users.id
Restrict delete
fk_rails_90e3653e9a
cvd_risks.patient_id
patients.id
Restrict delete
fk_rails_cd769e0a12
questionnaire_responses.questionnaire_id
questionnaires.id
Restrict delete
fk_rails_8df9902cc7
encounters.facility_id
facilities.id
Restrict delete
fk_rails_256d8f15cb
patients.registration_facility_id
facilities.id
Restrict delete
fk_rails_39783febcc
patients.address_id
addresses.id
Restrict delete
fk_rails_66733b5dc0
patients.assigned_facility_id
facilities.id
Restrict delete
fk_rails_dbcef01693
protocol_drugs.protocol_id
protocols.id
Restrict delete
fk_rails_17477eedd4
communications.notification_id
notifications.id
Restrict delete
fk_rails_b7da75c721
exotel_phone_number_details.patient_phone_number_id
patient_phone_numbers.id
Restrict delete
fk_rails_732cb83ab7
oauth_access_tokens.application_id
oauth_applications.id
Restrict delete
fk_rails_ee63f25419
oauth_access_tokens.resource_owner_id
machine_users.id
Restrict delete
fk_rails_8eb7cdedd2
drug_stocks.user_id
users.id
Restrict delete
fk_rails_5230adeadd
drug_stocks.protocol_drug_id
protocol_drugs.id
Restrict delete
fk_rails_aa9c165c6f
notifications.reminder_template_id
reminder_templates.id
Restrict delete
fk_rails_a0b99d451b
notifications.experiment_id
experiments.id
Restrict delete
fk_rails_e966d86b08
notifications.patient_id
patients.id
Restrict delete
fk_rails_4aa89bd48e
teleconsultations.requested_medical_officer_id
users.id
Restrict delete
fk_rails_3e1ccaa4cb
teleconsultations.medical_officer_id
users.id
Restrict delete
fk_rails_811d7873b8
teleconsultations.facility_id
facilities.id
Restrict delete
fk_rails_c436ea0008
teleconsultations.requester_id
users.id
Restrict delete
fk_rails_96b1526de4
clean_medicine_to_dosages.medicine
medicine_purposes.name
Restrict delete
fk_rails_0ba9e6af98
facility_groups.organization_id
organizations.id
Restrict delete
fk_rails_c44117c78f
facilities.facility_group_id
facility_groups.id
Restrict delete
fk_rails_fc46ae3757
patient_attributes.patient_id
patients.id
Restrict delete
fk_rails_565c8c1260
patient_attributes.user_id
users.id
Restrict delete
fk_rails_60d667a791
observations.user_id
users.id
Restrict delete
fk_rails_47dc1837b8
observations.encounter_id
encounters.id
Restrict delete
fk_rails_b4b53e07b8
oauth_access_grants.application_id
oauth_applications.id
Restrict delete
fk_rails_330c32d8d9
oauth_access_grants.resource_owner_id
machine_users.id
Restrict delete
fk_rails_7d64d6b790
reminder_templates.treatment_group_id
treatment_groups.id
Restrict delete

Check Constraints

Table Constraint Name Constraint