SchemaSpy Analysis of eicu.eicu_crd - Constraints Generated by
SchemaSpy
29 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
admissiondrug_fk_ptunit_id admissiondrug.patientunitstayid patient.patientunitstayid Restrict delete 
admissiondx_fk_ptunit_id admissiondx.patientunitstayid patient.patientunitstayid Restrict delete 
allergy_fk_ptunit_id allergy.patientunitstayid patient.patientunitstayid Restrict delete 
apacheapsvar_fk_ptunit_id apacheapsvar.patientunitstayid patient.patientunitstayid Restrict delete 
apachepatientresult_fk_ptunit_id apachepatientresult.patientunitstayid patient.patientunitstayid Restrict delete 
apachepredvar_fk_ptunit_id apachepredvar.patientunitstayid patient.patientunitstayid Restrict delete 
careplancareprovider_fk_ptunit_id careplancareprovider.patientunitstayid patient.patientunitstayid Restrict delete 
careplaneol_fk_ptunit_id careplaneol.patientunitstayid patient.patientunitstayid Restrict delete 
careplangeneral_fk_ptunit_id careplangeneral.patientunitstayid patient.patientunitstayid Restrict delete 
careplangoal_fk_ptunit_id careplangoal.patientunitstayid patient.patientunitstayid Restrict delete 
careplaninfectiousdisease_fk_ptunit_id careplaninfectiousdisease.patientunitstayid patient.patientunitstayid Restrict delete 
customlab_fk_ptunit_id customlab.patientunitstayid patient.patientunitstayid Restrict delete 
diagnosis_fk_ptunit_id diagnosis.patientunitstayid patient.patientunitstayid Restrict delete 
infusiondrug_fk_ptunit_id infusiondrug.patientunitstayid patient.patientunitstayid Restrict delete 
intakeoutput_fk_ptunit_id intakeoutput.patientunitstayid patient.patientunitstayid Restrict delete 
lab_fk_ptunit_id lab.patientunitstayid patient.patientunitstayid Restrict delete 
medication_fk_ptunit_id medication.patientunitstayid patient.patientunitstayid Restrict delete 
microlab_fk_ptunit_id microlab.patientunitstayid patient.patientunitstayid Restrict delete 
note_fk_ptunit_id note.patientunitstayid patient.patientunitstayid Restrict delete 
nurseassessment_fk_ptunit_id nurseassessment.patientunitstayid patient.patientunitstayid Restrict delete 
nursecare_fk_ptunit_id nursecare.patientunitstayid patient.patientunitstayid Restrict delete 
nursecharting_fk_ptunit_id nursecharting.patientunitstayid patient.patientunitstayid Restrict delete 
pasthistory_fk_ptunit_id pasthistory.patientunitstayid patient.patientunitstayid Restrict delete 
physicalexam_fk_ptunit_id physicalexam.patientunitstayid patient.patientunitstayid Restrict delete 
respiratorycare_fk_ptunit_id respiratorycare.patientunitstayid patient.patientunitstayid Restrict delete 
respiratorycharting_fk_ptunit_id respiratorycharting.patientunitstayid patient.patientunitstayid Restrict delete 
treatment_fk_ptunit_id treatment.patientunitstayid patient.patientunitstayid Restrict delete 
vitalaperiodic_fk_ptunit_id vitalaperiodic.patientunitstayid patient.patientunitstayid Restrict delete 
vitalperiodic_fk_ptunit_id vitalperiodic.patientunitstayid patient.patientunitstayid Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected