Subversion Repositories Applications.referentiel

Rev

Rev 23 | Go to most recent revision | Only display areas with differences | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 23 Rev 30
1 
CREATE TABLE ref_triple (
 1 
CREATE TABLE ref_triple (
2 
  id_triple INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
 2 
  id_triple INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
3 
  ressource VARCHAR(255)  NULL  ,
 3 
  ressource VARCHAR(255)  NULL  ,
4 
  propriete VARCHAR(255)  NULL  ,
 4 
  propriete VARCHAR(255)  NULL  ,
5 
  valeur TEXT  NULL    ,
 5 
  valeur TEXT  NULL    ,
6 
PRIMARY KEY(id_triple)  ,
 6 
PRIMARY KEY(id_triple)  ,
7 
INDEX ressource(ressource)  ,
 7 
INDEX ressource(ressource)  ,
8 
INDEX propriete(propriete));
 8 
INDEX propriete(propriete));
9 
 
 9 
 
10 
 
 10 
 
11 
 
 11 
 
12 
CREATE TABLE ref_traitement (
 12 
CREATE TABLE ref_traitement (
13 
  id_traitement INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
 13 
  id_traitement INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
14 
  referentiel_code VARCHAR(50)  NULL  ,
 14 
  referentiel_code VARCHAR(50)  NULL  ,
15 
  nom VARCHAR(100)  NULL  ,
 15 
  nom VARCHAR(100)  NULL  ,
16 
  date_debut DATETIME  NULL  ,
 16 
  date_debut DATETIME  NULL  ,
17 
  date_fin DATETIME  NULL  ,
 17 
  date_fin DATETIME  NULL  ,
18 
  meta_date_creation DATETIME  NULL    ,
 18 
  meta_date_creation DATETIME  NULL    ,
19 
PRIMARY KEY(id_traitement));
 19 
PRIMARY KEY(id_traitement));
20 
 
 20 
 
21 
 
 21 
 
22 
 
 22 
 
23 
 
 23 
 
24 
 
 24 
 
25 
 
 25 
 
26 
 
 26 
 
27 
 
 27 
 
28 
 
 28 
 
29 
CREATE TABLE ref_resultat (
 29 
CREATE TABLE ref_resultat (
30 
  id_resultat INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
 30 
  id_resultat INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
31 
  ce_traitement INTEGER UNSIGNED  NULL  ,
 31 
  ce_traitement INTEGER UNSIGNED  NULL  ,
32 
  nom VARCHAR(100)  NULL  ,
 32 
  nom VARCHAR(100)  NULL  ,
- 
 
 33 
  description TEXT  NULL  ,
- 
 
 34 
  resultat BOOL  NULL  ,
33 
  message MEDIUMTEXT  NULL  ,
 35 
  message MEDIUMTEXT  NULL  ,
34 
  meta_date_creation DATETIME  NULL    ,
 36 
  meta_date_creation DATETIME  NULL    ,
35 
PRIMARY KEY(id_resultat)  ,
 37 
PRIMARY KEY(id_resultat)  ,
36 
INDEX ce_traitement(ce_traitement));
 38 
INDEX ce_traitement(ce_traitement));
37 
 
 39 
 
38 
 
 40 
 
39 
 
 41 
 
40 
 
 42