Constraints

35 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
SYS_CONSTRAINT_645afbba-0392-4453-845f-456cd9e88c90
PROCEDURES.ENCOUNTER
ENCOUNTERS.ID
Restrict delete
SYS_CONSTRAINT_1040a22b-d9eb-448e-876f-f924ae272090
PROCEDURES.PATIENT
PATIENTS.ID
Restrict delete
SYS_CONSTRAINT_6f8538f1-dd06-4a3e-b554-a5d33494e001
CLAIMS_TRANSACTIONS.PATIENTID
PATIENTS.ID
Restrict delete
SYS_CONSTRAINT_676356a4-d67c-49f9-b7f2-4c8a8bdfda1a
CLAIMS_TRANSACTIONS.CLAIMID
CLAIMS.ID
Restrict delete
SYS_CONSTRAINT_9b50a613-0087-48a5-a774-1a2914ffc590
CLAIMS_TRANSACTIONS.SUPERVISING_PROVIDER_ID
PROVIDERS.ID
Restrict delete
SYS_CONSTRAINT_b579a988-667d-404c-9aa6-f9f9efc91bbc
CLAIMS_TRANSACTIONS.PROVIDER_ID
PROVIDERS.ID
Restrict delete
SYS_CONSTRAINT_fd050e68-2816-4e4a-933b-03ed2b3e74d2
MEDICATIONS.PATIENT
PATIENTS.ID
Restrict delete
SYS_CONSTRAINT_0e092281-2d6e-471c-8475-e76ac484b3e1
MEDICATIONS.ENCOUNTER
ENCOUNTERS.ID
Restrict delete
SYS_CONSTRAINT_914c5209-21cb-408b-b648-cb5ee9e8e51c
MEDICATIONS.PAYER
PAYERS.ID
Restrict delete
SYS_CONSTRAINT_5276bbad-aa94-4aa1-8fe5-8062df7bbc16
CAREPLANS.ENCOUNTER
ENCOUNTERS.ID
Restrict delete
SYS_CONSTRAINT_77b204cd-a7bf-413e-96e7-be9b0085cf18
CAREPLANS.PATIENT
PATIENTS.ID
Restrict delete
SYS_CONSTRAINT_927e5eb0-6c8c-4cc1-a4f2-064676de182a
ALLERGIES.ENCOUNTER
ENCOUNTERS.ID
Restrict delete
SYS_CONSTRAINT_f0ab3069-3f1d-4c1e-8bbb-6e571754b2c2
ALLERGIES.PATIENT
PATIENTS.ID
Restrict delete
SYS_CONSTRAINT_54277ced-c2e0-47d8-9ee5-5340cbb764f3
OBSERVATIONS.PATIENT
PATIENTS.ID
Restrict delete
SYS_CONSTRAINT_4b5caadd-24c2-4545-b02a-1941d5acc009
OBSERVATIONS.ENCOUNTER
ENCOUNTERS.ID
Restrict delete
SYS_CONSTRAINT_f590a959-834c-46b2-a915-6e35eacf4629
PAYER_TRANSITIONS.PAYER
PAYERS.ID
Restrict delete
SYS_CONSTRAINT_985b080e-597a-440b-af29-4078be588ce1
PAYER_TRANSITIONS.PATIENT
PATIENTS.ID
Restrict delete
SYS_CONSTRAINT_c8afb533-359a-4c0f-b21e-08aca4665862
SUPPLIES.ENCOUNTER
ENCOUNTERS.ID
Restrict delete
SYS_CONSTRAINT_15db7e07-794c-4149-8b3f-2eb2c2dbc8fd
SUPPLIES.PATIENT
PATIENTS.ID
Restrict delete
SYS_CONSTRAINT_74e6bc52-318f-4d9b-ae74-12e8776dbee7
IMMUNIZATIONS.ENCOUNTER
ENCOUNTERS.ID
Restrict delete
SYS_CONSTRAINT_19205834-e6b3-410c-866f-dad0617d00a3
IMMUNIZATIONS.PATIENT
PATIENTS.ID
Restrict delete
SYS_CONSTRAINT_2b47049d-4ec8-4e20-b2bf-dc99d9ac9b97
CLAIMS.PRIMARY_PAYER
PAYERS.ID
Restrict delete
SYS_CONSTRAINT_4597a0cb-8d64-4f2a-bff1-df1105eabf9a
CLAIMS.PROVIDER
PROVIDERS.ID
Restrict delete
SYS_CONSTRAINT_06aef3a8-f461-4b77-b8f7-6564a2521e22
CLAIMS.SUPERVISINGPROVIDERID
PROVIDERS.ID
Restrict delete
SYS_CONSTRAINT_07b0c7b7-417e-43df-9627-edd075257adb
CLAIMS.PATIENT
PATIENTS.ID
Restrict delete
SYS_CONSTRAINT_0c806c9c-2025-4196-aff7-62567b87176c
CLAIMS.SECONDARY_PAYER
PAYERS.ID
Restrict delete
SYS_CONSTRAINT_1b514eef-6d51-4e59-8004-7778a946dbaa
CLAIMS.REFERRINGPROVIDERID
PROVIDERS.ID
Restrict delete
SYS_CONSTRAINT_8fab7423-f175-4f84-83ef-9fd273d9fa79
CONDITIONS.ENCOUNTER
ENCOUNTERS.ID
Restrict delete
SYS_CONSTRAINT_3a3a128f-1fd2-48d3-b8d4-87eaa81cde23
CONDITIONS.PATIENT
PATIENTS.ID
Restrict delete
SYS_CONSTRAINT_8008afdf-0655-40c2-a4d2-c6ddb23848a3
PROVIDERS.ORGANIZATION
ORGANIZATIONS.ID
Restrict delete
SYS_CONSTRAINT_88977ccd-49e7-4219-90ba-1c9f439b1757
DEVICES.ENCOUNTER
ENCOUNTERS.ID
Restrict delete
SYS_CONSTRAINT_e2a1a98d-f168-4890-809f-d73aa8374427
DEVICES.PATIENT
PATIENTS.ID
Restrict delete
SYS_CONSTRAINT_e0684af9-ae3f-499c-a922-c005b4709394
ENCOUNTERS.PATIENT
PATIENTS.ID
Restrict delete
SYS_CONSTRAINT_f49cf6bc-f485-491e-a4e1-bcfde465e348
ENCOUNTERS.PAYER
PAYERS.ID
Restrict delete
SYS_CONSTRAINT_571a191b-05f1-487f-8066-08c10ca615ae
ENCOUNTERS.PROVIDER
PROVIDERS.ID
Restrict delete

Check Constraints

Table Constraint Name Constraint