SchemaSpy Analysis of pacsdb.public - Constraints Generated by
SchemaSpy
65 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_1retecpk22a2tysmi5o6xcpbh ups.ups_code_fk code.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_3frtpy5cstsoxk5jxw9cutr33 ups.dicomattrs_fk dicomattrs.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_61tpdp9aoy98jwiif5wq82ia3 ups.admission_issuer_fk issuer.pk Restrict delete 
fk_6asj28yy5se9mp443b6ryefd2 rel_ups_perf_code.perf_code_fk code.pk Restrict delete 
fk_6m06tt8ku376qxkro94xpteus rel_ups_perf_code.ups_fk ups.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_7vt6m05r0hertks2fcngd5wn1 ups_req.ups_fk ups.pk Restrict delete 
fk_7w6f9bi2w91qr2abl6ddxnrwq instance.srcode_fk code.pk Restrict delete 
fk_8xiqdli1p8cyw1y4hwyqhimcx ups.patient_fk patient.pk Restrict delete 
fk_9kpe6whsov3ur9rph4ih2vi5a content_item.instance_fk instance.pk Restrict delete 
fk_ak183xmw0sai4jg9lib6m14o2 ups.station_class_fk code.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_f1l196ykcnh7s2pwo6qnmltw7 global_subscription.matchkeys_fk dicomattrs.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_gd2hu9idxg6rd71g1i8r8wyjr ups.station_name_fk code.pk Restrict delete 
fk_gegm1c1ymem7tj2wcm0o7e0pu ups_req.accno_issuer_fk issuer.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_iafiq2ugv5rd6fonwd0vd7xdx rejected_instance.reject_code_fk code.pk Restrict delete 
fk_jadcs2aho4ijh639r67qgk0g0 subscription.ups_fk ups.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_kocdb2pxx2fymu1modhneb4xm ups_req.req_phys_name_fk person_name.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_ox3hpmd042ywnww3yh33crcoj ups.station_location_fk code.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