1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
CREATE TABLE IF NOT EXISTS `op` (
`num_op` int(4) NOT NULL,
`qte_en_cours` int(4) NOT NULL,
`qte_finie` int(4) NOT NULL,
`qte_rejetee` int(4) NOT NULL,
`qte_reprise` int(4) NOT NULL,
`tp_reglage` float(5,3) NOT NULL,
`tp_execution` float(5,3) NOT NULL,
`commentaire` text NOT NULL,
`ref_art` varchar(25) NOT NULL,
`nom_at` varchar(10) NOT NULL,
`num_of` varchar(20) NOT NULL,
PRIMARY KEY (`num_op`,`num_of`),
FOREIGN KEY (`ref_art`) REFERENCES article (`ref_art`),
FOREIGN KEY (`nom_at`) REFERENCES atelier (`nom_at`),
FOREIGN KEY (`num_of`) REFERENCES of (`num_of`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
Partager