Subversion Repositories Applications.referentiel

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

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