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