Foreign key fabrik

Good morning:D
I have a doubt
Can I do this directly from a Fabrik to create a foreign key?

Manually, I can do this using
ALTER TABLE `companies` ADD CONSTRAINT` companiescity2` FOREIGN KEY (`city`) REFERENCES` cities` (`idcity`);
I doubt if creating a databasejoin element from fabrik, the foreign key is created automatically.
Thanks for the help
 

Attachments

  • foreignkey.jpg
    foreignkey.jpg
    23.6 KB · Views: 48
A foreign key in Fabrik is just logically, nothing fixed in the database.
It's the column (Fabrik element e.g. type field, databasejoin, CCD...) which will hold the primary key of a record of the "parent" table.
 
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top