Data_Model_Resource_Book

Data_Model_Resource_Book copied to clipboard

Ch2: Invalid FK for customer_relationship_party_relationship_fk

1

Adding FK fails with: ``` Error starting at line : 144 in command - ALTER TABLE customer_relationship ADD CONSTRAINT customer_relationship_party_relationship_fk FOREIGN KEY ( from_date ) REFERENCES party_relationship ( from_date, party_role_party_role_id,...

dfhawthorne

Adding FK fails with: ``` Error starting at line : 624 in command - ALTER TABLE supplier_relationship ADD CONSTRAINT supplier_relationship_party_relationship_fk FOREIGN KEY ( from_date ) REFERENCES party_relationship ( from_date, party_role_party_role_id,...

dfhawthorne

Adding FK fails with: ``` Error starting at line : 446 in command - ALTER TABLE partnership ADD CONSTRAINT partnership_party_relationship_fk FOREIGN KEY ( from_date ) REFERENCES party_relationship ( from_date, party_role_party_role_id,...

dfhawthorne

Adding FK fails with: ``` Error starting at line : 410 in command - ALTER TABLE organization_rollup ADD CONSTRAINT organization_rollup_party_relationship_fk FOREIGN KEY ( from_date ) REFERENCES party_relationship ( from_date, party_role_party_role_id,...

dfhawthorne

Adding FK fails with: ``` Error starting at line : 396 in command - ALTER TABLE organization_contact_relationship ADD CONSTRAINT organization_contact_relationship_party_relationship_fk FOREIGN KEY ( from_date ) REFERENCES party_relationship ( from_date, party_role_party_role_id,...

dfhawthorne

Adding FK fails with: ``` Error starting at line : 375 in command - ALTER TABLE organisation_rollup ADD CONSTRAINT organisation_rollup_party_relationship_fk FOREIGN KEY ( from_date ) REFERENCES party_relationship ( from_date, party_role_party_role_id,...

dfhawthorne

Adding FK fails with: ``` Error starting at line : 228 in command - ALTER TABLE employment ADD CONSTRAINT employment_party_relationship_fk FOREIGN KEY ( from_date ) REFERENCES party_relationship ( from_date, party_role_party_role_id,...

dfhawthorne

Adding FK for: ``` Error starting at line : 174 in command - ALTER TABLE distribution_channel_relationship ADD CONSTRAINT distribution_channel_relationship_party_relationship_fk FOREIGN KEY ( from_date ) REFERENCES party_relationship ( from_date, party_role_party_role_id, party_role_party_party_id,...

dfhawthorne