Subversion Repositories Applications.referentiel

Rev

Rev 23 | Rev 44 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed

CREATE TABLE ref_triple (
  id_triple INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
  ressource VARCHAR(255)  NULL  ,
  propriete VARCHAR(255)  NULL  ,
  valeur TEXT  NULL    ,
PRIMARY KEY(id_triple)  ,
INDEX ressource(ressource)  ,
INDEX propriete(propriete));



CREATE TABLE ref_traitement (
  id_traitement INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
  referentiel_code VARCHAR(50)  NULL  ,
  nom VARCHAR(100)  NULL  ,
  date_debut DATETIME  NULL  ,
  date_fin DATETIME  NULL  ,
  meta_date_creation DATETIME  NULL    ,
PRIMARY KEY(id_traitement));









CREATE TABLE ref_resultat (
  id_resultat INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
  ce_traitement INTEGER UNSIGNED  NULL  ,
  nom VARCHAR(100)  NULL  ,
  description TEXT  NULL  ,
  resultat BOOL  NULL  ,
  message MEDIUMTEXT  NULL  ,
  meta_date_creation DATETIME  NULL    ,
PRIMARY KEY(id_resultat)  ,
INDEX ce_traitement(ce_traitement));