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 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72
|
CREATE TABLE `taches` (
`IDtache` int(10) unsigned NOT NULL auto_increment,
`IDprojet` int(10) unsigned NOT NULL default '0',
`IDtacheMere` int(10) unsigned default NULL,
`Type` char(1) NOT NULL default '',
`SousType` varchar(4) default NULL,
`NiveauCriticite` int(10) unsigned NOT NULL default '0',
`NiveauPriorite` int(10) unsigned NOT NULL default '0',
`StatutActuel` int(3) unsigned NOT NULL default '0',
`CouleurStatutActuel` char(1) NOT NULL default '',
`LibStatutActuel` varchar(20) NOT NULL default '',
`ReferenceClient` varchar(20) default NULL,
`Initiateur` varchar(20) default NULL,
`DescriptionCourte` varchar(150) NOT NULL default '',
`DescriptionLongue` text,
`Commentaires` text,
`Intervenant` int(10) unsigned default NULL,
`ContexteFacturation` varchar(10) default NULL,
`ReferenceFacturation` varchar(20) default NULL,
`DateDebutPrevue` datetime default NULL,
`DateFinPrevue` datetime default NULL,
`DateDebutReelle` datetime default NULL,
`DateFinReelle` datetime default NULL,
`ChargePrevue` int(10) unsigned default NULL,
`ChargeReelle` int(10) unsigned default NULL,
`ResteAFaire` int(10) unsigned default NULL,
`Environnement` int(10) unsigned NOT NULL default '0',
`Origine` int(10) unsigned default NULL,
`Typologie` int(10) unsigned default NULL,
`CodeCatclient` varchar(5) default NULL,
`ExclureCalculIndicateurs` char(1) NOT NULL default 'N',
`PourcentageRealise` int(3) unsigned default '0',
`chaine` varchar(25) default NULL,
`EnvoiDevisPrevue` date default NULL,
`EnvoiDevisReelle` date default NULL,
`DevisLivraisonDemande` date default NULL,
`DevisLivraisonPropose` date default NULL,
`EtatDevis` char(1) default NULL,
`DateValidDevis` date default NULL,
`ImpressionDevis` int(1) default NULL,
`LivraisonRecettePrevue` date default NULL,
`LivraisonRecetteReelle` date default NULL,
`DebutRecettePrevue` date default NULL,
`FinRecettePrevue` date default NULL,
`DebutRecetteReelle` date default NULL,
`FinRecetteReelle` date default NULL,
`ProductionPrevue` date default NULL,
`ProductionReelle` date default NULL,
`CommentairesRecette` varchar(150) default NULL,
`ImpressionRecette` int(1) default NULL,
PRIMARY KEY (`IDtache`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=20382 ;
CREATE TABLE `cras` (
`IDactivite` int(10) unsigned NOT NULL auto_increment,
`IDressource` int(10) unsigned NOT NULL default '0',
`Date` date NOT NULL default '0000-00-00',
`IDabsence` int(10) unsigned default NULL,
`IDtache` int(10) unsigned default NULL,
`DescriptionCourteTache` varchar(150) default NULL,
`Duree` int(10) unsigned NOT NULL default '0',
`Nature` int(10) unsigned default NULL,
`LibelleNature` varchar(35) default NULL,
`Descriptif` varchar(50) default NULL,
`Remarques` varchar(80) default NULL,
`DemandeModifStatut` int(10) unsigned default NULL,
PRIMARY KEY (`IDactivite`),
KEY `IDactivite` (`IDactivite`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=133198 ; |
Partager