| New file |
|---|
| 0,0 → 1,115 |
|---|
| CREATE TABLE obs_stations ( |
| os_id_station INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, |
| os_ce_participant INTEGER UNSIGNED NULL , |
| os_nom VARCHAR(255) NULL , |
| os_ce_commune INTEGER UNSIGNED NULL , |
| os_latitude FLOAT NULL , |
| os_longitude FLOAT NULL , |
| os_altitude FLOAT NULL , |
| os_ce_environnement INTEGER UNSIGNED NULL , |
| os_commentaire TEXT NULL , |
| PRIMARY KEY(os_id_station)); |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| CREATE TABLE ods_communes ( |
| oc_id_commune INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, |
| oc_code_insee INTEGER UNSIGNED NULL , |
| oc_nom TEXT NULL , |
| oc_secteur VARCHAR(50) NULL , |
| oc_latitude FLOAT NULL , |
| oc_longitude FLOAT NULL , |
| PRIMARY KEY(oc_id_commune)); |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| CREATE TABLE ods_especes ( |
| oe_id_espece INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, |
| oe_nom_vernaculaire VARCHAR(255) NULL , |
| oe_nom_scientifique VARCHAR(255) NULL , |
| oe_espece_ecole BOOL NULL , |
| oe_description TEXT NULL , |
| oe_ce_climat INTEGER UNSIGNED NULL , |
| oe_ce_evenements INTEGER UNSIGNED NULL , |
| oe_ce_type INTEGER UNSIGNED NULL , |
| PRIMARY KEY(oe_id_espece)); |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| CREATE TABLE ods_individus ( |
| oi_id_individu INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, |
| oi_ce_espece INTEGER UNSIGNED NULL , |
| oi_ce_station INTEGER UNSIGNED NULL , |
| PRIMARY KEY(oi_id_individu)); |
| |
| |
| |
| |
| |
| |
| |
| CREATE TABLE ods_observations ( |
| oo_id_observation INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, |
| oo_ordre INTEGER UNSIGNED NOT NULL , |
| oo_ce_individu INTEGER UNSIGNED NULL , |
| oo_ce_evenement INTEGER UNSIGNED NULL , |
| oo_date DATE NULL , |
| oo_commentaire TEXT NULL , |
| oo_date_saisie DATE NULL , |
| oo_date_modification DATE NULL , |
| PRIMARY KEY(oo_id_observation)); |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| CREATE TABLE ods_triples ( |
| ot_id_triple INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, |
| ot_cle VARCHAR(255) NULL , |
| ot_ce_parent VARCHAR(255) NULL , |
| ot_valeur VARCHAR(255) NULL , |
| ot_description TEXT NULL , |
| PRIMARY KEY(ot_id_triple)); |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |