1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
| DROP TABLE IF EXISTS `doc_qualite`;
CREATE TABLE `doc_qualite` (
`Ndq` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`Nchro` INT( 10 ) UNSIGNED NOT NULL ,
`nom` VARCHAR( 50 ) NOT NULL ,
`indice` INT( 3 ) DEFAULT '1' NOT NULL ,
`type` ENUM( 'T' ) NOT NULL ,
`date` DATE DEFAULT '''1000-01-01''' NOT NULL ,
`provenance` ENUM( 'Airbus' ) NOT NULL ,
PRIMARY KEY ( `Ndq` )
) TYPE = InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `service`;
CREATE TABLE `service` (
`Nserv` INT( 10 ) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT ,
`nom` VARCHAR( 50 ) NOT NULL ,
PRIMARY KEY ( `Nserv` )
) TYPE = InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `Dq_serv`;
CREATE TABLE `Dq_serv` (
`Ndq` INT( 10 ) NOT NULL ,
`Nserv` INT( 10 ) NOT NULL ,
`criticite` ENUM( '1', '2', '3' ) DEFAULT '1' NOT NULL ,
`action` TEXT NOT NULL ,
PRIMARY KEY ( `Ndq` , `Nserv` ),
INDEX `indx_Ndq_dq_serv` (`Ndq`) ,
FOREIGN KEY `fk_Ndq_doc_qualite_dq_serv` (`Ndq`) REFERENCES `doc_qualite` (`Ndq`) ON DELETE CASCADE,
INDEX `indx_Nserv_dq_serv` (`Nserv`) ,
FOREIGN KEY `fk_Nserv_serv_dq_serv` (`Nserv`) REFERENCES `service` (`Nserv`) ON DELETE CASCADE
) TYPE = InnoDB DEFAULT CHARSET=utf8; |
Partager