Constraints

62 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

fkpp9xjy946uspo3piayc6ofels

location.instance_fk

Restrict delete

fkendncyyv928u41dfo1x09s644

location.uidmap_fk

Restrict delete

fkqkchf2ue2j1p3fv2o94rhacvi

global_subscription.matchkeys_fk

Restrict delete

fknhstgtx2w1xd61u4iqbn731pu

mpps.dicomattrs_fk

Restrict delete

fk2m3l9bh173bmq88ukf81yd9ow

mpps.discreason_code_fk

Restrict delete

fks7mb8qsr1mjijnw9bvx0dhqab

mpps.patient_fk

Restrict delete

fkfra6ee5jtybfp94ldpvva623o

content_item.code_fk

Restrict delete

fk7rpy6unnb5b18b8ieuqr9w9i9

content_item.name_fk

Restrict delete

fkei15n1lk1h1e8f89e9ubalm7q

content_item.instance_fk

Restrict delete

fks3re94tlv0dbd5go33mwdk6dr

ian_task.mpps_fk

Restrict delete

fk2ktu3hbxxalrngfhyp4j6pf70

study.dicomattrs_fk

Restrict delete

fkndwmntu3lsjd78erctnbposyr

study.ref_phys_name_fk

Restrict delete

fkocnq3so9ej7h0mnd6a6arjf6c

study.patient_fk

Restrict delete

fkmeklscb7t55i8mb2d4cjucywd

sps_station_aet.mwl_item_fk

Restrict delete

fk9vjk41q61e9x9n4qfve6jud8s

mwl_item.dicomattrs_fk

Restrict delete

fkqui6rvqyg1qfujae4mw3o0nbm

mwl_item.inst_code_fk

Restrict delete

fkeursgxiy2u6ws39cgn1b25e6k

mwl_item.patient_fk

Restrict delete

fkf5l3x4bfqn3jv8mhj617kidx7

mwl_item.perf_phys_name_fk

Restrict delete

fkpl6u7oyyp6o3ca8r9jbxv5oge

mwl_item.dept_code_fk

Restrict delete

fkaddby69vtwxpssgaa12ct6pn3

ups.dicomattrs_fk

Restrict delete

fkjcmu4x6x02r0tc1d28xb3nf17

ups.patient_fk

Restrict delete

fkr3t1gbo2e42oleaqeastvv5ej

ups.ups_code_fk

Restrict delete

fkkpcwkrsipamdg81mao7nkmdc2

verify_observer.instance_fk

Restrict delete

fk8vo3f94xgum0qajsjqnlnqjo4

verify_observer.observer_name_fk

Restrict delete

fkctukwjaer0axw2jwv3bfj67r2

soundex_code.person_name_fk

Restrict delete

fklvjl0o0sdhht440wccag722e4

hl7psu_task.mpps_fk

Restrict delete

fksk791fnscydy7whj3lvrp3j1a

series_query_attrs.series_fk

Restrict delete

fk6om2durembdfk2rmd29dlcm2t

rel_ups_perf_code.perf_code_fk

Restrict delete

fk31cp9ux8xb2dcu0nv84tgd8um

rel_ups_perf_code.ups_fk

ups.pk

Restrict delete

fknpdeeclrflvuxajeqjmk6utf

series.dept_code_fk

Restrict delete

fktih7mdqwcklym58jd9wn3itjq

series.dicomattrs_fk

Restrict delete

fk3196nws7ngapmsmtoafb4e88j

series.study_fk

Restrict delete

fk6nn55bx7pqlmimgfnhfpjra94

series.inst_code_fk

Restrict delete

fk84fpblugeadm5u6dw1idi80a0

series.metadata_fk

Restrict delete

fk5p2gub2u40fyh2ch6bp6nan4l

series.perf_phys_name_fk

Restrict delete

fkh1sjrdq663dnk8j7hsthun4ie

ups_req.ups_fk

ups.pk

Restrict delete

fk1b5veu90oftv8o95nxx2xndpb

ups_req.req_phys_name_fk

Restrict delete

fkh9mdhriyx32gr91pfdgnl48f0

subscription.ups_fk

ups.pk

Restrict delete

fkokrgkyvch35m6iwr309mawsna

instance.dicomattrs_fk

Restrict delete

fke92yganh695k2y4hxfqxtesg1

instance.series_fk

Restrict delete

fkqmk050ojwer9ujsbl74d4kf6e

instance.srcode_fk

Restrict delete

fkd4gjwmhmlphp865fxiqjypwo2

rel_ups_station_name_code.ups_fk

ups.pk

Restrict delete

fk308ga4grefjjwmrwtsirjmbhh

rel_ups_station_name_code.station_name_code_fk

Restrict delete

fklxb9i1b48mfxo0y72fpeoxl48

rel_ups_station_location_code.ups_fk

ups.pk

Restrict delete

fkp5d05caciw2cqik5uqt7r8w6p

rel_ups_station_location_code.station_location_code_fk

Restrict delete

fkmbg8j00cvubj76doba8funq8j

instance_req.instance_fk

Restrict delete

fk8leut3c0gfxcg6y3lbjlpt2bt

instance_req.req_phys_name_fk

Restrict delete

fk53sqs6uiua7ff45u94lrv50t7

rel_task_dicomattrs.dicomattrs_fk

Restrict delete

fkhd3dj3u43xxgdxn7w5imp5ank

rel_task_dicomattrs.task_fk

Restrict delete

fk15lid2bqbrsmjatxiq0vug4wq

series_req.req_phys_name_fk

Restrict delete

fk1gs2u7w7uefvi7dcjg9vlp23x

series_req.series_fk

Restrict delete

fkmu32jq25y6qkimi7hn7d4s2hp

study_query_attrs.study_fk

Restrict delete

fklia0q74j0xhj2u0avy1wbbx7q

rel_study_pcode.pcode_fk

Restrict delete

fkta5515ogakmavm1swi6tw1n2n

rel_study_pcode.study_fk

Restrict delete

fk62f8dua3p8bxv3vilctc7pd42

rel_ups_station_class_code.station_class_code_fk

Restrict delete

fkf0y92ufejerf9dwv8sl6kdkae

rel_ups_station_class_code.ups_fk

ups.pk

Restrict delete

fke8j5c2rhq67rt3opqfggoplt2

patient.dicomattrs_fk

Restrict delete

fkjh4miooi709vj5l6xi8h95f3e

patient.resp_person_fk

Restrict delete

fkc66cfkdwiu7eq65kgmxilrocw

patient.merge_fk

Restrict delete

fkig1mwm5jpkyq6733t0hrf56g

patient.pat_name_fk

Restrict delete

fkih8d22x50j7orytfmigrnssea

patient_id.patient_fk

Restrict delete

fk27xpx6okj63sunyo76tf0s913

rejected_instance.reject_code_fk

Restrict delete

Check Constraints

Table	Constraint Name	Constraint
location	location_object_type_check	(((object_type >= 0) AND (object_type <= 1)))
location	location_status_check	(((status >= 0) AND (status <= 17)))
mpps	mpps_pps_status_check	(((pps_status >= 0) AND (pps_status <= 2)))
study	study_completeness_check	(((completeness >= 0) AND (completeness <= 2)))
study	study_expiration_state_check	(((expiration_state >= 0) AND (expiration_state <= 5)))
study	study_rejection_state_check	(((rejection_state >= 0) AND (rejection_state <= 3)))
mwl_item	mwl_item_sps_status_check	(((sps_status >= 0) AND (sps_status <= 7)))
ups	ups_input_readiness_state_check	(((input_readiness_state >= 0) AND (input_readiness_state <= 2)))
ups	ups_ups_priority_check	(((ups_priority >= 0) AND (ups_priority <= 2)))
ups	ups_ups_state_check	(((ups_state >= 0) AND (ups_state <= 3)))
soundex_code	soundex_code_sx_pn_comp_check	(((sx_pn_comp >= 0) AND (sx_pn_comp <= 4)))
hl7psu_task	hl7psu_task_pps_status_check	(((pps_status >= 0) AND (pps_status <= 2)))
series_query_attrs	series_query_attrs_availability_check	(((availability >= 0) AND (availability <= 3)))
task	task_stgcmt_policy_check	(((stgcmt_policy >= 0) AND (stgcmt_policy <= 5)))
task	task_task_status_check	(((task_status >= 0) AND (task_status <= 6)))
task	task_task_type_check	(((task_type >= 0) AND (task_type <= 10)))
series	series_completeness_check	(((completeness >= 0) AND (completeness <= 2)))
series	series_expiration_state_check	(((expiration_state >= 0) AND (expiration_state <= 5)))
series	series_inst_purge_state_check	(((inst_purge_state >= 0) AND (inst_purge_state <= 2)))
series	series_rejection_state_check	(((rejection_state >= 0) AND (rejection_state <= 3)))
instance	instance_availability_check	(((availability >= 0) AND (availability <= 3)))
stgcmt_result	stgcmt_result_stgcmt_status_check	(((stgcmt_status >= 0) AND (stgcmt_status <= 3)))
study_query_attrs	study_query_attrs_availability_check	(((availability >= 0) AND (availability <= 3)))
patient	patient_verification_status_check	(((verification_status >= 0) AND (verification_status <= 4)))
metadata	metadata_status_check	(((status >= 0) AND (status <= 9)))