1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
|
DROP TABLE IF EXISTS `document`;
CREATE TABLE `document` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`titre` varchar(40) DEFAULT NULL,
`annee` int(4) DEFAULT NULL,
`acces_id` int(11) DEFAULT NULL,
`theme_id` int(11) DEFAULT NULL,
`mot_cle_id` int(11) DEFAULT NULL,
`format_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `acces_id` (`acces_id`),
KEY `theme_id` (`theme_id`),
KEY `mot_cle_id` (`mot_cle_id`),
KEY `format_id` (`format_id`),
CONSTRAINT `document_ibfk_1` FOREIGN KEY (`acces_id`) REFERENCES `acces` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `document_ibfk_2` FOREIGN KEY (`theme_id`) REFERENCES `theme` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `document_ibfk_3` FOREIGN KEY (`mot_cle_id`) REFERENCES `mot_cle` (`id`),
CONSTRAINT `document_ibfk_4` FOREIGN KEY (`format_id`) REFERENCES `format` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; |
Partager