CREATE TABLE PATIENT (
MASTER_PATIENT_IDENTIFIER STRING(MAX) NOT NULL,
DATE_OF_BIRTH TIMESTAMP,
FIRST_NAME STRING(MAX),
LAST_NAME STRING(MAX),
MIDDLE_NAME STRING(MAX),
GENDER STRING(MAX),
) PRIMARY KEY(MASTER_PATIENT_IDENTIFIER);
CREATE TABLE FACILITY (
FACILITY_NUMBER STRING(MAX) NOT NULL,
FACILITY_NAME STRING(MAX),
PRIMARY_PHONE STRING(MAX),
) PRIMARY KEY(FACILITY_NUMBER);
CREATE TABLE CARE_ACTIVITY (
PATIENT_CARE_ACTIVITY_ID STRING(MAX) NOT NULL,
MASTER_PATIENT_IDENTIFIER STRING(MAX) NOT NULL,
FACILITY_NUMBER_CREATED_AT STRING(MAX),
FACILITY_NUMBER_COMPLETED_AT STRING(MAX),
CONSTRAINT FK_1 FOREIGN KEY(MASTER_PATIENT_IDENTIFIER) REFERENCES PATIENT(MASTER_PATIENT_IDENTIFIER),
CONSTRAINT FK_2 FOREIGN KEY(FACILITY_NUMBER_CREATED_AT) REFERENCES FACILITY(FACILITY_NUMBER),
) PRIMARY KEY(MASTER_PATIENT_IDENTIFIER, PATIENT_CARE_ACTIVITY_ID);
When we have DDL like this
the constraint
FK_1will be skipped.If you will switch positions of the
TABLE PATIENTandTABLE FACILITYin this DDL theFK_2will be skipped.