Subversion Repositories Sites.obs-saisons.fr

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));