Constraints

7 Foreign Key Constraints

Constraint Name	Child Column	Parent Column	Delete Rule
FK_task_ehi_export_document_id

| ehi_export_job_tasks.export_document_id |

|

| documents.id |

| Restrict delete | | FK_task_ehi_export_job_id |

| ehi_export_job_tasks.ehi_export_job_id |

|

| ehi_export_job.ehi_export_job_id |

| Restrict delete | | FK_ehi_export_job_task_patients_job_id |

| ehi_export_job_task_patients.ehi_task_id |

|

| ehi_export_job_tasks.ehi_task_id |

| Cascade on delete | | FK_ehi_export_job_task_patients_patient_id |

| ehi_export_job_task_patients.pid |

|

| patient_data.pid |

| Cascade on delete | | FK_ehi_export_job_patients_patient_id |

| ehi_export_job_patients.pid |

|

| patient_data.pid |

| Cascade on delete | | FK_ehi_export_job_patients_job_id |

| ehi_export_job_patients.ehi_export_job_id |

|

| ehi_export_job.ehi_export_job_id |

| Cascade on delete | | FK_ehi_export_job_users |

| ehi_export_job.user_id |

|

| users.id |

| Restrict delete |

Check Constraints

Table	Constraint Name	Constraint