I carried out EER diagram in MySQL workbench including different relationships: one to one, one to many, zero or one to one, zero or one to zero or one, and one to zero or many.
However, when I apply the model to phpmyadmin using “Forward engineer”, all the relationships are converted to one to many, and I do not the reason and how to implement my original relationships?
UPDATE:
The relation between equipment and inspection is one to one, but it appears in phpmyadmin as one to many.
CREATE TABLE IF NOT EXISTS `equipment` (
`S_N` int(10) UNSIGNED NOT NULL ,
`Equipment_Description` varchar(45) NOT NULL,
`P_N` varchar(45) NOT NULL ,
`OrderNo` int(10) UNSIGNED NOT NULL,
`V_N` int(10) UNSIGNED NOT NULL,
`LS_N` int(10) UNSIGNED NOT NULL,
PRIMARY KEY (`S_N`),
UNIQUE KEY `S_N` (`S_N`),
KEY `OrderNo_idx` (`OrderNo`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `inspection` (
`Inspection_ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`FK_INS_S_N` int(10) UNSIGNED NOT NULL,
`Notification_No` int(10) UNSIGNED NOT NULL,
`Notification_Status` char(2) NOT NULL,
`Number_of_Defects` int(10) UNSIGNED NOT NULL,
`INS_Plant` varchar(25) NOT NULL,
`INS_Location` varchar(30) NOT NULL,
`INS_Work_Date_start` date NOT NULL,
`INS_Work_Time_start` time NOT NULL,
`INS_Work_Date_finish` date NOT NULL,
`INS_Work_Time_finish` time NOT NULL,
`INS_Actual_Duration` time NOT NULL,
`INS_Forecast duration` time NOT NULL,
`WBS` varchar(45) NOT NULL,
PRIMARY KEY (`Inspection_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
Thanks in advance.