12 lines
585 B
MySQL
12 lines
585 B
MySQL
|
CREATE TABLE `contrat_conso` (
|
||
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
|
|
`contratId` int(11) NOT NULL,
|
||
|
|
`detailId` int(11) NOT NULL,
|
||
|
|
`code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
|
|
`type` enum('ForfaitNoLimit','ForfaitLimit','Unitaire') COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
|
|
`montant` decimal(10,2) NOT NULL,
|
||
|
|
`max` int(11) NOT NULL,
|
||
|
|
`doublon` enum('none','day','month','period') COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
|
|
PRIMARY KEY (`id`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Détail des éléments unitaire pour la facturation';
|