Schema
Owner
albenard
Tablespace
(default)
Descriptions
Avril 2008. creation de idlc_pos_balise puis remplissage a partir de position_balise(varchar) puis suppression de position_balise. Avril 20008 remplissage de num_ordre, puis not null puis contrainte pour unicite : per-for, groupe, num_ordre
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
idlc_type_materiel2 |
integer |
|
|
|
|
|
|
|
idlc_mode_plantation |
integer |
|
|
|
|
|
|
|
|
idliste_elimination |
integer |
|
|
|
|
Elément sorti de dispositif, mais transformé en travaux |
|
idlc_antecedent |
integer |
|
|
|
|
|
|
|
idlc_type_materiel1 |
integer |
|
|
|
|
|
|
|
idlc_preparation_racine |
integer |
|
|
|
|
|
|
|
idgroupe_dispo |
integer |
|
|
|
|
||
|
idlc_orientation_ligne |
integer |
|
|
|
|
|
|
|
idlc_niveau_activite |
integer |
|
|
|
|
|
|
idlieu |
integer |
|
|
|
||||
|
|
pep_for |
varchar(60) |
|
|
|
Mis en not null : valeur P ou F |
|
|
|
num_ordre_nom_court |
varchar(50) |
|
|
|
Avril 2008. complete puis not null |
|
|
|
annee_installation |
integer |
|
|
|
|
|
|
|
mois_installation |
integer |
|
|
|
|
|
|
|
surface_ini_en_dispo |
numeric |
|
|
|
|
|
|
|
surface_ini_hors_dispo |
numeric |
|
|
|
|
|
|
|
surface_actuel_en_dispo |
numeric |
|
|
|
|
|
|
|
surface_actuel_hors_dispo |
numeric |
|
|
|
|
|
|
|
annee_surface_actuel |
integer |
|
|
|
|
|
|
|
annee_preparation |
integer |
|
|
|
|
|
|
|
contexte |
varchar(128) |
|
|
|
|
|
|
|
age_materiel_mini |
integer |
|
|
|
|
|
|
|
age_materiel_maxi |
integer |
|
|
|
|
|
|
|
nb_plant_en_dispo |
integer |
|
|
|
|
|
|
|
nb_plant_hors_dispo |
integer |
|
|
|
|
|
|
|
repetition |
integer |
|
|
|
|
|
|
|
blocs |
integer |
|
|
|
|
|
|
|
traitement |
integer |
|
|
|
|
juin 2008. ancien nom = facteurs. exple : densite sylvicole |
|
|
geno |
integer |
|
|
|
|
nb total de genoypes |
|
|
geno_bloc |
integer |
|
|
|
|
juin 2008. ancien nom = traitement_bloc |
|
|
plant_pu_mini |
integer |
|
|
|
|
|
|
|
plant_pu_maxi |
integer |
|
|
|
|
|
|
|
distance_entre_lignes_mini |
numeric |
|
|
|
|
|
|
|
distance_entre_lignes_maxi |
numeric |
|
|
|
|
|
|
|
distance_entre_plants_mini |
numeric |
|
|
|
|
|
|
|
distance_entre_plants_maxi |
numeric |
|
|
|
|
|
|
|
convention_annee_signature |
integer |
|
|
|
|
|
|
|
convention_annee_debut |
integer |
|
|
|
|
|
|
|
convention_annee_fin |
integer |
|
|
|
|
|
|
|
etat_convention |
varchar(128) |
|
|
|
|
|
|
|
clause_particuliere |
varchar(128) |
|
|
|
|
|
|
idlc_type_dispo |
integer |
|
|
|
|
|
|
|
|
nb_plant_en_dispo_actuel |
integer |
|
|
|
|
|
|
|
nb_plant_hors_dispo_actuel |
integer |
|
|
|
|
|
|
|
recup_nom_lieu |
varchar(50) |
|
|
|
|
|
|
|
recup_nom_grpe_dispo |
varchar(50) |
|
|
|
|
|
|
|
recup_code_type_mat1 |
varchar(50) |
|
|
|
|
|
|
|
recup_code_mode_plant |
varchar(20) |
|
|
|
|
|
|
|
recup_code_elimination |
varchar(50) |
|
|
|
|
|
|
|
recup_code_antecedent |
varchar(50) |
|
|
|
|
|
|
|
recup_code_prepa1 |
varchar(50) |
|
|
|
|
|
|
|
recup_code_prepa2 |
varchar(50) |
|
|
|
|
|
|
|
recup_code_prep_racine |
varchar(50) |
|
|
|
|
|
|
|
recup_code_orientation |
varchar(50) |
|
|
|
|
|
|
|
recup_code_type_dispo |
varchar(50) |
|
|
|
|
|
|
|
recup_com1 |
text |
|
|
|
|
|
|
|
recup_com2 |
text |
|
|
|
|
|
|
|
recup_com3 |
text |
|
|
|
|
|
|
|
recup_com4 |
text |
|
|
|
|
|
|
|
commentaire |
text |
|
|
|
|
|
|
idlc_pos_balise |
integer |
|
|
|
|
|
Foreign Keys
Name | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|
idlc_antecedent |
id_lc |
No Action |
No Action |
|
Immediate |
|
||
idlc_type_dispo |
id_lc |
No Action |
No Action |
|
Immediate |
|
||
idgroupe_dispo |
idgroupe_dispo |
No Action |
No Action |
|
Immediate |
|
||
idlieu |
idlieu |
No Action |
No Action |
|
Immediate |
|
||
idlc_mode_plantation |
id_lc |
No Action |
No Action |
|
Immediate |
|
||
idlc_niveau_activite |
id_lc |
No Action |
No Action |
|
Immediate |
|
||
idlc_orientation_ligne |
id_lc |
No Action |
No Action |
|
Immediate |
|
||
idlc_pos_balise |
id_lc |
Restrict |
Restrict |
|
Immediate |
|
||
idlc_preparation_racine |
id_lc |
No Action |
No Action |
|
Immediate |
|
||
idlc_type_materiel2 |
id_lc |
No Action |
No Action |
|
Immediate |
|
||
idlc_type_materiel1 |
id_lc |
No Action |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table dispositif_lieu
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
idlieu |
|
|||
btree |
|
pep_for, idgroupe_dispo, num_ordre_nom_court |
|
|
Triggers
There are no triggers for table dispositif_lieu
Rules
There are no rules for table dispositif_lieu
Policies
There are no policies for table dispositif_lieu
Referenced
There are no tables referenced by table dispositif_lieu
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
397 |
Pages |
11 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.dispositif_lieu (
idlc_type_materiel2 INTEGER,
idlc_mode_plantation INTEGER,
idliste_elimination INTEGER,
idlc_antecedent INTEGER,
idlc_type_materiel1 INTEGER,
idlc_preparation_racine INTEGER,
idgroupe_dispo INTEGER NOT NULL,
idlc_orientation_ligne INTEGER,
idlc_niveau_activite INTEGER,
idlieu INTEGER NOT NULL,
pep_for VARCHAR(60) NOT NULL,
num_ordre_nom_court VARCHAR(50) NOT NULL,
annee_installation INTEGER,
mois_installation INTEGER,
surface_ini_en_dispo NUMERIC,
surface_ini_hors_dispo NUMERIC,
surface_actuel_en_dispo NUMERIC,
surface_actuel_hors_dispo NUMERIC,
annee_surface_actuel INTEGER,
annee_preparation INTEGER,
contexte VARCHAR(128),
age_materiel_mini INTEGER,
age_materiel_maxi INTEGER,
nb_plant_en_dispo INTEGER,
nb_plant_hors_dispo INTEGER,
repetition INTEGER,
blocs INTEGER,
traitement INTEGER,
geno INTEGER,
geno_bloc INTEGER,
plant_pu_mini INTEGER,
plant_pu_maxi INTEGER,
distance_entre_lignes_mini NUMERIC,
distance_entre_lignes_maxi NUMERIC,
distance_entre_plants_mini NUMERIC,
distance_entre_plants_maxi NUMERIC,
convention_annee_signature INTEGER,
convention_annee_debut INTEGER,
convention_annee_fin INTEGER,
etat_convention VARCHAR(128),
clause_particuliere VARCHAR(128),
idlc_type_dispo INTEGER,
nb_plant_en_dispo_actuel INTEGER,
nb_plant_hors_dispo_actuel INTEGER,
recup_nom_lieu VARCHAR(50),
recup_nom_grpe_dispo VARCHAR(50),
recup_code_type_mat1 VARCHAR(50),
recup_code_mode_plant VARCHAR(20),
recup_code_elimination VARCHAR(50),
recup_code_antecedent VARCHAR(50),
recup_code_prepa1 VARCHAR(50),
recup_code_prepa2 VARCHAR(50),
recup_code_prep_racine VARCHAR(50),
recup_code_orientation VARCHAR(50),
recup_code_type_dispo VARCHAR(50),
recup_com1 TEXT,
recup_com2 TEXT,
recup_com3 TEXT,
recup_com4 TEXT,
commentaire TEXT,
idlc_pos_balise INTEGER,
CONSTRAINT dispositif_lieu_pkey PRIMARY KEY(idlieu),
CONSTRAINT nom_synthetique UNIQUE(pep_for, idgroupe_dispo, num_ordre_nom_court),
CONSTRAINT fk_antecedent_dispo FOREIGN KEY (idlc_antecedent)
REFERENCES public.donnees_liste_classique(id_lc)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT fk_dispositif_lieu_donnees_liste FOREIGN KEY (idlc_type_dispo)
REFERENCES public.donnees_liste_classique(id_lc)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT fk_dispositif_lieu_groupe_dispos FOREIGN KEY (idgroupe_dispo)
REFERENCES public.groupe_dispositif_lieu(idgroupe_dispo)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT fk_dispositif_lieu_lieu FOREIGN KEY (idlieu)
REFERENCES public.lieu(idlieu)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT fk_mode_plantation FOREIGN KEY (idlc_mode_plantation)
REFERENCES public.donnees_liste_classique(id_lc)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT fk_niveau_activite FOREIGN KEY (idlc_niveau_activite)
REFERENCES public.donnees_liste_classique(id_lc)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT fk_orientation_ligne FOREIGN KEY (idlc_orientation_ligne)
REFERENCES public.donnees_liste_classique(id_lc)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT fk_pos_balise FOREIGN KEY (idlc_pos_balise)
REFERENCES public.donnees_liste_classique(id_lc)
ON DELETE RESTRICT
ON UPDATE RESTRICT
NOT DEFERRABLE,
CONSTRAINT fk_preparation_racine FOREIGN KEY (idlc_preparation_racine)
REFERENCES public.donnees_liste_classique(id_lc)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT fk_type_dispo FOREIGN KEY (idlc_type_materiel2)
REFERENCES public.donnees_liste_classique(id_lc)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT fk_type_materiel1 FOREIGN KEY (idlc_type_materiel1)
REFERENCES public.donnees_liste_classique(id_lc)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.dispositif_lieu
IS 'Avril 2008. creation de idlc_pos_balise puis remplissage a partir de position_balise(varchar) puis suppression de position_balise. Avril 20008 remplissage de num_ordre, puis not null puis contrainte pour unicite : per-for, groupe, num_ordre';
COMMENT ON COLUMN public.dispositif_lieu.idliste_elimination
IS 'Elément sorti de dispositif, mais transformé en travaux';
COMMENT ON COLUMN public.dispositif_lieu.pep_for
IS 'Mis en not null : valeur P ou F';
COMMENT ON COLUMN public.dispositif_lieu.num_ordre_nom_court
IS 'Avril 2008. complete puis not null';
COMMENT ON COLUMN public.dispositif_lieu.traitement
IS 'juin 2008. ancien nom = facteurs. exple : densite sylvicole';
COMMENT ON COLUMN public.dispositif_lieu.geno
IS 'nb total de genoypes';
COMMENT ON COLUMN public.dispositif_lieu.geno_bloc
IS 'juin 2008. ancien nom = traitement_bloc';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |