SchemaSpy Analysis of transmart.i2b2demodata - Constraints Generated by
SchemaSpy
19 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
encounter_mapping_encounter_num_fk encounter_mapping.encounter_num visit_dimension.encounter_num Restrict delete 
fk_up_set_type_id set_upload_status.set_type_id set_type.id Restrict delete 
left_subject_id_fk relation.left_subject_id patient_dimension.patient_num Restrict delete 
observation_fact_trial_visit_fk observation_fact.trial_visit_num trial_visit_dimension.trial_visit_num Restrict delete 
qt_fk_pec_ri qt_patient_enc_collection.result_instance_id qt_query_result_instance.result_instance_id Restrict delete 
qt_fk_psc_ri qt_patient_set_collection.result_instance_id qt_query_result_instance.result_instance_id Restrict delete 
qt_fk_qi_mid qt_query_instance.query_master_id qt_query_master.query_master_id Restrict delete 
qt_fk_qi_stid qt_query_instance.status_type_id qt_query_status_type.status_type_id Restrict delete 
qt_fk_qri_rid qt_query_result_instance.query_instance_id qt_query_instance.query_instance_id Restrict delete 
qt_fk_qri_rtid qt_query_result_instance.result_type_id qt_query_result_type.result_type_id Restrict delete 
qt_fk_qri_stid qt_query_result_instance.status_type_id qt_query_status_type.status_type_id Restrict delete 
qt_fk_xmlr_riid qt_xml_result.result_instance_id qt_query_result_instance.result_instance_id Restrict delete 
relation_type_id_fk relation.relation_type_id relation_type.id Restrict delete 
right_subject_id_fk relation.right_subject_id patient_dimension.patient_num Restrict delete 
SOURCE_SYSTEM_ID_ID_FK linked_file_collection.source_system_id storage_system.id Restrict delete 
study_bio_experiment_id_fk study.bio_experiment_id bio_experiment.bio_experiment_id Restrict delete 
STUDY_ID_FK linked_file_collection.study_id study.study_num Restrict delete 
trial_visit_dimension_study_fk trial_visit_dimension.study_num study.study_num Restrict delete 
visit_dimension_patient_num_fk visit_dimension.patient_num patient_dimension.patient_num Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected