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
|
Structure des tables :
CREATE TABLE `CALENDRIER` (
`date` date DEFAULT NULL,
`id` int(11) NOT NULL,
`y` smallint(6) DEFAULT NULL,
`m` smallint(6) DEFAULT NULL,
`d` smallint(6) DEFAULT NULL,
`yw` smallint(6) DEFAULT NULL,
`w` smallint(6) DEFAULT NULL,
`q` smallint(6) DEFAULT NULL,
`wd` smallint(6) DEFAULT NULL,
`m_name` char(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`wd_name` char(10) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Table chargé du 01/01/2015 au 31/12/2049 permettant de trouver les dates manquantes dans les tables (ControlesBDD)';
CREATE TABLE `heurglis_lfpg` (
`HG_DATE` date NOT NULL,
`HG_HOURS_UTC` text COLLATE utf8_unicode_ci NOT NULL,
`ARR_09L` smallint(5) NOT NULL,
`ARR_27R` smallint(5) NOT NULL,
`ARR_09R` smallint(5) NOT NULL,
`ARR_27L` smallint(5) NOT NULL,
`ARR_08L` smallint(5) NOT NULL,
`ARR_26R` smallint(5) NOT NULL,
`ARR_08R` smallint(5) NOT NULL,
`ARR_26L` smallint(5) NOT NULL,
`TOT_ARR` smallint(5) NOT NULL,
`DEP_09L` smallint(5) NOT NULL,
`DEP_27R` smallint(5) NOT NULL,
`DEP_09R` smallint(5) NOT NULL,
`DEP_27L` smallint(5) NOT NULL,
`DEP_08L` smallint(5) NOT NULL,
`DEP_26R` smallint(5) NOT NULL,
`DEP_08R` smallint(5) NOT NULL,
`DEP_26L` smallint(5) NOT NULL,
`TOT_DEP` smallint(5) NOT NULL,
`TOT_GEN` smallint(5) NOT NULL,
`TOT_ARR_DN` smallint(5) NOT NULL,
`TOT_DEP_DN` smallint(5) NOT NULL,
`TOT_DN` smallint(5) NOT NULL,
`TOT_ARR_DS` smallint(5) NOT NULL,
`TOT_DEP_DS` smallint(5) NOT NULL,
`TOT_DS` smallint(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Fichier(s) source(s) : AAAA_MM_JJ_plateforme_lfpg_gliss_1h.csv';
CREATE TABLE `trafjour_4pltf` (
`ST_ANNEE_REF` smallint(4) NOT NULL,
`ST_DATE_MOUV_N` date NOT NULL,
`ST_NUM_SEMAINE_N` smallint(2) NOT NULL,
`ST_NOM_JOUR_N` text COLLATE utf8_unicode_ci NOT NULL,
`ST_PLTF` text COLLATE utf8_unicode_ci NOT NULL,
`ST_NB_MOUV_ARR_N` smallint(4) DEFAULT NULL,
`ST_NB_MOUV_DEP_N` smallint(4) DEFAULT NULL,
`ST_DATE_MOUV_N1` date NOT NULL,
`ST_NB_MOUV_ARR_N1` smallint(4) DEFAULT NULL,
`ST_NB_MOUV_DEP_N1` smallint(4) DEFAULT NULL,
`ST_DATE_MOUV_N2` date NOT NULL,
`ST_NB_MOUV_ARR_N2` smallint(4) DEFAULT NULL,
`ST_NB_MOUV_DEP_N2` smallint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Table calculée - LFPG - LFPO - LFPB - LFOB'; |
Partager