+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Feature Requests (https://forum.codeigniter.com/forumdisplay.php?fid=29)
+--- Thread: Composite key as foreign key (/showthread.php?tid=77129)
Composite key as foreign key - luispastendev - 07-22-2020
Hi!
There is not yet a method to assign compound foreign keys to reference with another table
Currently there is only one forge method to assign primary keys as compounds. addKey()
I think there should be a method that works similarly but for foreign keys, to have a result like this:
Code:
create table Music (
type char(1) not null check (type = 'M'),
id integer not null,
primary key (type, id),
foreign key (type, id) references Product
);RE: Composite key as foreign key - kenjis - 03-05-2023
https://codeigniter4.github.io/CodeIgniter4/dbmgmt/forge.html#adding-foreign-keys