Constraints

66 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
fk_bfk5vl6eoxaf0hhwiu3rbgmkn
location.uidmap_fk
uidmap.pk
Restrict delete
fk_hjtlcwsvwihs4khh961d423e7
location.instance_fk
instance.pk
Restrict delete
fk_f1l196ykcnh7s2pwo6qnmltw7
global_subscription.matchkeys_fk
dicomattrs.pk
Restrict delete
fk_o49fec996jvdo31o7ysmsn9s2
mpps.dicomattrs_fk
dicomattrs.pk
Restrict delete
fk_ofg0lvfxad6r5oigw3y6da27u
mpps.patient_fk
patient.pk
Restrict delete
fk_nrigpgue611m33rao03nnfe5l
mpps.discreason_code_fk
code.pk
Restrict delete
fk_grl2idmms10qq4lhmh909jxtj
mpps.accno_issuer_fk
issuer.pk
Restrict delete
fk_pyrd1nhijag5ct0ee9xqq4h78
content_item.name_fk
code.pk
Restrict delete
fk_gudw6viy7lrf5t5hetw7mbgh5
content_item.code_fk
code.pk
Restrict delete
fk_9kpe6whsov3ur9rph4ih2vi5a
content_item.instance_fk
instance.pk
Restrict delete
fk_1fuh251le2hid2byw90hd1mly
ian_task.mpps_fk
mpps.pk
Restrict delete
fk_5w0oynbw061mwu1rr9mrb6kj4
study.dicomattrs_fk
dicomattrs.pk
Restrict delete
fk_49eet5qgcsb32ktsqrf1mj3x2
study.ref_phys_name_fk
person_name.pk
Restrict delete
fk_9fqno60wc3gr4376ov1xlfme4
study.admid_issuer_fk
issuer.pk
Restrict delete
fk_lp0rdx659kewq8qrqg702yfyv
study.accno_issuer_fk
issuer.pk
Restrict delete
fk_e3fdaqhw7u60trs5aspf4sna9
study.patient_fk
patient.pk
Restrict delete
fk_js5xqyw5qa9rpttwmck14duow
sps_station_aet.mwl_item_fk
mwl_item.pk
Restrict delete
fk_ot32lpvialton54xqh636c4it
mwl_item.accno_issuer_fk
issuer.pk
Restrict delete
fk_vkxtls2wr17wgxnxj7b2fe32
mwl_item.patient_fk
patient.pk
Restrict delete
fk_44qwwvs50lgpog2cqmicxgt1f
mwl_item.perf_phys_name_fk
person_name.pk
Restrict delete
fk_hqecoo67sflk190dxyc0hnf0c
mwl_item.dept_code_fk
code.pk
Restrict delete
fk_6qj8tkh6ib9w2pjqwvqe23ko
mwl_item.dicomattrs_fk
dicomattrs.pk
Restrict delete
fk_9k8x73a91nd9q7ux7h5itkyh5
mwl_item.admid_issuer_fk
issuer.pk
Restrict delete
fk_t4vpsywvy0axeutmdgc0ye3nk
mwl_item.inst_code_fk
code.pk
Restrict delete
fk_gd2hu9idxg6rd71g1i8r8wyjr
ups.station_name_fk
code.pk
Restrict delete
fk_8xiqdli1p8cyw1y4hwyqhimcx
ups.patient_fk
patient.pk
Restrict delete
fk_ak183xmw0sai4jg9lib6m14o2
ups.station_class_fk
code.pk
Restrict delete
fk_61tpdp9aoy98jwiif5wq82ia3
ups.admission_issuer_fk
issuer.pk
Restrict delete
fk_3frtpy5cstsoxk5jxw9cutr33
ups.dicomattrs_fk
dicomattrs.pk
Restrict delete
fk_ox3hpmd042ywnww3yh33crcoj
ups.station_location_fk
code.pk
Restrict delete
fk_1retecpk22a2tysmi5o6xcpbh
ups.ups_code_fk
code.pk
Restrict delete
fk_qjgrn9rfyyt6sv14utk9ijcfq
verify_observer.instance_fk
instance.pk
Restrict delete
fk_105wt9hglqsmtnoxgma9x18vj
verify_observer.observer_name_fk
person_name.pk
Restrict delete
fk_dh7lahwi99hk6bttrk75x4ckc
soundex_code.person_name_fk
person_name.pk
Restrict delete
fk_pev4urgkk7id2h1ijhv8domjx
hl7psu_task.mpps_fk
mpps.pk
Restrict delete
fk_eiwosf6pcc97n6y282cv1n54k
series_query_attrs.series_fk
series.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_pu4p7k1o9hleuk9rmxvw2ybj6
series.metadata_fk
metadata.pk
Restrict delete
fk_5n4bxxb2xa7bvvq26ao7wihky
series.perf_phys_name_fk
person_name.pk
Restrict delete
fk_1og1krtgxfh207rtqjg0r7pbd
series.study_fk
study.pk
Restrict delete
fk_bdj2kuutidekc2en6dckev7l6
series.dicomattrs_fk
dicomattrs.pk
Restrict delete
fk_oiq81nulcmtg6p85iu31igtf5
series.inst_code_fk
code.pk
Restrict delete
fk_avp2oeuufo8axv5j184cchrop
series.dept_code_fk
code.pk
Restrict delete
fk_gegm1c1ymem7tj2wcm0o7e0pu
ups_req.accno_issuer_fk
issuer.pk
Restrict delete
fk_7vt6m05r0hertks2fcngd5wn1
ups_req.ups_fk
ups.pk
Restrict delete
fk_kocdb2pxx2fymu1modhneb4xm
ups_req.req_phys_name_fk
person_name.pk
Restrict delete
fk_jadcs2aho4ijh639r67qgk0g0
subscription.ups_fk
ups.pk
Restrict delete
fk_jxfu47kwjk3kkkyrwewjw8a4n
instance.dicomattrs_fk
dicomattrs.pk
Restrict delete
fk_s4tgrew4sh4qxoupmk3gihtrk
instance.series_fk
series.pk
Restrict delete
fk_7w6f9bi2w91qr2abl6ddxnrwq
instance.srcode_fk
code.pk
Restrict delete
fk_bcn0jtvurqutw865pwp34pejb
series_req.req_phys_name_fk
person_name.pk
Restrict delete
fk_bdkjk6ww0ulrb0nhf41c7liwt
series_req.series_fk
series.pk
Restrict delete
fk_se4n39as61wwf92ggbfc9yglo
series_req.accno_issuer_fk
issuer.pk
Restrict delete
fk_pwaoih2f4ay4c00avvt79de7h
rel_task_dicomattrs.task_fk
task.pk
Restrict delete
fk_e0gtunmen48q8imxggunt7gt7
rel_task_dicomattrs.dicomattrs_fk
dicomattrs.pk
Restrict delete
fk_sxccj81423w8o6w2tsb7nshy9
study_query_attrs.study_fk
study.pk
Restrict delete
fk_fryhnb2ppb6fcop3jrrfwvnfy
rel_study_pcode.pcode_fk
code.pk
Restrict delete
fk_mnahh8fh77d365m6w2x4x3f4q
rel_study_pcode.study_fk
study.pk
Restrict delete
fk_39gahcxyursxfxe2ucextr65s
patient.patient_id_fk
patient_id.pk
Restrict delete
fk_rj42ffdtimnrcwmqqlvj24gi2
patient.pat_name_fk
person_name.pk
Restrict delete
fk_5lgndn3gn7iug3kuewiy9q124
patient.dicomattrs_fk
dicomattrs.pk
Restrict delete
fk_sk77bwjgaoetvy1pbcgqf08g
patient.merge_fk
patient.pk
Restrict delete
fk_56r2g5ggptqgcvb3hl11adke2
patient.resp_person_fk
person_name.pk
Restrict delete
fk_oo232lt89k1b5h8mberi9v152
patient_id.issuer_fk
issuer.pk
Restrict delete
fk_iafiq2ugv5rd6fonwd0vd7xdx
rejected_instance.reject_code_fk
code.pk
Restrict delete

Check Constraints

Table Constraint Name Constraint