SchemaSpy Analysis of pacsdb.public - Constraints Generated by
SchemaSpy
51 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
fk_105wt9hglqsmtnoxgma9x18vj verify_observer.observer_name_fk person_name.pk Restrict delete 
fk_1fuh251le2hid2byw90hd1mly ian_task.mpps_fk mpps.pk Restrict delete 
fk_1og1krtgxfh207rtqjg0r7pbd series.study_fk study.pk Restrict delete 
fk_1sbjtesix8hkq310i84lfg0xi diff_task_attrs.diff_task_fk diff_task.pk Restrict delete 
fk_39gahcxyursxfxe2ucextr65s patient.patient_id_fk patient_id.pk Restrict delete 
fk_44qwwvs50lgpog2cqmicxgt1f mwl_item.perf_phys_name_fk person_name.pk Restrict delete 
fk_49eet5qgcsb32ktsqrf1mj3x2 study.ref_phys_name_fk person_name.pk Restrict delete 
fk_56r2g5ggptqgcvb3hl11adke2 patient.resp_person_fk person_name.pk Restrict delete 
fk_5lgndn3gn7iug3kuewiy9q124 patient.dicomattrs_fk dicomattrs.pk Restrict delete 
fk_5n4bxxb2xa7bvvq26ao7wihky series.perf_phys_name_fk person_name.pk Restrict delete 
fk_5w0oynbw061mwu1rr9mrb6kj4 study.dicomattrs_fk dicomattrs.pk Restrict delete 
fk_6pnwsvi69g5ypye6gjo26vn7e instance.reject_code_fk code.pk Restrict delete 
fk_6qj8tkh6ib9w2pjqwvqe23ko mwl_item.dicomattrs_fk dicomattrs.pk Restrict delete 
fk_72rsx022j2wu9noi6jldvq95r diff_task_attrs.dicomattrs_fk dicomattrs.pk Restrict delete 
fk_7w6f9bi2w91qr2abl6ddxnrwq instance.srcode_fk code.pk Restrict delete 
fk_9kpe6whsov3ur9rph4ih2vi5a content_item.instance_fk instance.pk Restrict delete 
fk_bcn0jtvurqutw865pwp34pejb series_req.req_phys_name_fk person_name.pk Restrict delete 
fk_bdj2kuutidekc2en6dckev7l6 series.dicomattrs_fk dicomattrs.pk Restrict delete 
fk_bdkjk6ww0ulrb0nhf41c7liwt series_req.series_fk series.pk Restrict delete 
fk_bfk5vl6eoxaf0hhwiu3rbgmkn location.uidmap_fk uidmap.pk Restrict delete 
fk_dh7lahwi99hk6bttrk75x4ckc soundex_code.person_name_fk person_name.pk Restrict delete 
fk_dlrthwe594xvfeta3kyuih3ip diff_task.queue_msg_fk queue_msg.pk Restrict delete 
fk_e3fdaqhw7u60trs5aspf4sna9 study.patient_fk patient.pk Restrict delete 
fk_eiwosf6pcc97n6y282cv1n54k series_query_attrs.series_fk series.pk Restrict delete 
fk_fryhnb2ppb6fcop3jrrfwvnfy rel_study_pcode.pcode_fk code.pk Restrict delete 
fk_g6atpiywpo2100kn6ovix7uet export_task.queue_msg_fk queue_msg.pk Restrict delete 
fk_grl2idmms10qq4lhmh909jxtj mpps.accno_issuer_fk issuer.pk Restrict delete 
fk_gudw6viy7lrf5t5hetw7mbgh5 content_item.code_fk code.pk Restrict delete 
fk_hch5fanx7ejwew2ag2ividq9r stgver_task.queue_msg_fk queue_msg.pk Restrict delete 
fk_hjtlcwsvwihs4khh961d423e7 location.instance_fk instance.pk Restrict delete 
fk_js5xqyw5qa9rpttwmck14duow sps_station_aet.mwl_item_fk mwl_item.pk Restrict delete 
fk_jxfu47kwjk3kkkyrwewjw8a4n instance.dicomattrs_fk dicomattrs.pk Restrict delete 
fk_lp0rdx659kewq8qrqg702yfyv study.accno_issuer_fk issuer.pk Restrict delete 
fk_mnahh8fh77d365m6w2x4x3f4q rel_study_pcode.study_fk study.pk Restrict delete 
fk_mxokt1gw5g1e7rc3ssotvuqix retrieve_task.queue_msg_fk queue_msg.pk Restrict delete 
fk_nrigpgue611m33rao03nnfe5l mpps.discreason_code_fk code.pk Restrict delete 
fk_o49fec996jvdo31o7ysmsn9s2 mpps.dicomattrs_fk dicomattrs.pk Restrict delete 
fk_ofg0lvfxad6r5oigw3y6da27u mpps.patient_fk patient.pk Restrict delete 
fk_oiq81nulcmtg6p85iu31igtf5 series.inst_code_fk code.pk Restrict delete 
fk_oo232lt89k1b5h8mberi9v152 patient_id.issuer_fk issuer.pk Restrict delete 
fk_ot32lpvialton54xqh636c4it mwl_item.accno_issuer_fk issuer.pk Restrict delete 
fk_pev4urgkk7id2h1ijhv8domjx hl7psu_task.mpps_fk mpps.pk Restrict delete 
fk_pu4p7k1o9hleuk9rmxvw2ybj6 series.metadata_fk metadata.pk Restrict delete 
fk_pyrd1nhijag5ct0ee9xqq4h78 content_item.name_fk code.pk Restrict delete 
fk_qjgrn9rfyyt6sv14utk9ijcfq verify_observer.instance_fk instance.pk Restrict delete 
fk_rj42ffdtimnrcwmqqlvj24gi2 patient.pat_name_fk person_name.pk Restrict delete 
fk_s4tgrew4sh4qxoupmk3gihtrk instance.series_fk series.pk Restrict delete 
fk_se4n39as61wwf92ggbfc9yglo series_req.accno_issuer_fk issuer.pk Restrict delete 
fk_sk77bwjgaoetvy1pbcgqf08g patient.merge_fk patient.pk Restrict delete 
fk_sxccj81423w8o6w2tsb7nshy9 study_query_attrs.study_fk study.pk Restrict delete 
fk_vkxtls2wr17wgxnxj7b2fe32 mwl_item.patient_fk patient.pk Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected