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

Options: ReplyQuote


Subject
Written By
Posted
July 30, 2015 11:08PM
August 01, 2015 11:19PM
August 02, 2015 11:40PM
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.