Data_Model_Resource_Book icon indicating copy to clipboard operation
Data_Model_Resource_Book copied to clipboard

Ch2: Invalid FK for organization_contact_relationship_party_relationship_fk

Open dfhawthorne opened this issue 2 years ago • 0 comments

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,
                                        party_role_party_party_id,
                                        party_role_party_role_id2,
                                        party_role_party_party_id2 )
    NOT DEFERRABLE
Error report -
ORA-02256: number of referencing columns must match referenced columns
02256. 00000 -  "number of referencing columns must match referenced columns"
*Cause:    The number of columns in the foreign-key referencing list is not
           equal to the number of columns in the referenced list.
*Action:   Make sure that the referencing columns match the referenced
           columns.

dfhawthorne avatar Aug 25 '23 02:08 dfhawthorne