Re: FOREIGN KEY ERROR
Posted by:
Rick James
Date: August 05, 2015 06:18PM
PRIMARY KEY(a, b) -- says that the combination is unique
UNIQUE (b) -- says that b, by itself, is unique, hence the PK is wasted. Why have `a` at all?
Or... Maybe (b) should be just a non-unique INDEX??
Is CTABLE a mapping between between PROPOSERs and REJETION_REMARKs? With DRAFT_COL as extra info? If no, then what is the "purpose" of this table?
Here is my design pattern for mapping tables:
http://mysql.rjweb.org/doc.php/index_cookbook_mysql#many_to_many_mapping_table
Subject
Written By
Posted
Re: FOREIGN KEY ERROR
August 05, 2015 06:18PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.