Can't create composite foreign key with a different cardinality

Question

1

(click on this box to dismiss)

I can't create composite foreign key with a different cardinality than the referenced table's primary key, even if there is a unique index:

CREATE TABLE "ITEMS" (

"ID" integer AUTO_INCREMENT PRIMARY KEY,

"ITEM_ID" integer FOREIGN KEY REFERENCES "ITEMS",

UNIQUE ("ITEM_ID", "ID"),

FOREIGN KEY ("ID", "ITEM_ID") REFERENCES "ITEMS"("ITEM_ID", "ID")

);

gives error:

The number of keys of the foreign key 'fk_items_id_item_id' is different from that of the primary key 'pk_items_id'.

링크 댓글 쓰기 (0)

질문시간 7달 전

55

Answer 1

0

Currently, foreign keys can only reference primary keys in CUBRID.

링크 댓글 쓰기 (0)

답변시간 7달 전

558

Related Questions