Good morning
I have the paid version but I am having problems with the Mysql code generation (which is the one that interests me) as a result I want the FK to relate to my tables under the keyword "reference" this allows me not to You can enter values that are not in the other table in your KEY.
Example I look for this:
CREATE TABLE `TB_CBS` (
`cod_Cbs` int NOT NULL AUTO_INCREMENT
`name` varchar(50)
`description` varchar(500)
`image` varchar(150)
PRIMARY KEY (`cod_Cbs`)
);
CREATE TABLE `TB_Bonuses_Cbs` (
`cod_Bonuses_Cbs` int NOT NULL AUTO_INCREMENT
`name` varchar(50)
`description` varchar(500)
`cod_Cbs` INT
PRIMARY KEY (`cod_Bonuses_Cbs`)
foreign key (`cod_Cbs`) references tb_cbs(cod_Cbs)
);
However what I get is this:
CREATE TABLE `TB_CBS` (
`cod_Cbs` int NOT NULL AUTO_INCREMENT
`name` varchar(50)
`description` varchar(50)
`image` varchar(50)
PRIMARY KEY (`cod_Cbs`)
);
CREATE TABLE `TB_Bonuses_Cbs` (
`cod_Bonuses_Cbs` int NOT NULL AUTO_INCREMENT
`name` varchar(50)
`description` varchar(50)
`cod_Bonuses_Cbs` int
PRIMARY KEY (`cod_Bonuses_Cbs`)
KEY `FK` (`cod_Bonuses_Cbs`)
);
I have searched for similar things and they say that in Lucidchart it is not possible to add "references". Can someone help me??