db_biljou_carto on db.silva.inrae.fr |
|
Table: t_carte_statistique_parametre_simulation_caspars
db_biljou_carto on db.silva.inrae.fr |
|
Table: t_carte_statistique_parametre_simulation_caspars
Schema
Owner
biljoucarto
Tablespace
(default)
Descriptions
Table de statistiques des cartes de paramètres de simulation
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
caspars_id |
serial |
|
|
|
nextval('t_carte_statistique_parametre_simulation_caspars_caspars_id_seq'::regclass) |
Identifiant |
|
|
caspars_nom_table |
varchar(100) |
|
|
|
|
Nom de la table ou sont contenues les données |
|
|
caspars_annee_debut |
smallint |
|
|
|
|
Date de début |
|
|
caspars_annee_fin |
smallint |
|
|
|
|
Date de fin |
|
|
caspars_date_suppression |
date |
|
|
|
|
Date de suppression |
|
|
caspars_est_publiable |
boolean |
|
|
|
|
Indique si la carte est publiable sur le site web |
|
|
caspars_date_integration |
date |
|
|
|
|
Date de création de la carte |
|
|
gri_id |
integer |
|
|
|
|
Clé étrangère de la table tr_grille_gri |
|
|
scen_id |
integer |
|
|
|
|
Clé étrangère de la table tr_scenario_scen |
|
|
pars_id |
integer |
|
|
|
|
Clé étrangère de la table tr_parametre_simulation_pars |
|
|
fic_id |
integer |
|
|
|
|
|
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
t_carte_statistique_parametre_simulation_caspars_fic_id_fkey | fic_id |
fic_id |
No Action |
No Action |
|
Immediate |
|
|
t_carte_statistique_parametre_simulation_caspars_gri_id_fkey | gri_id |
gri_id |
No Action |
No Action |
|
Immediate |
|
|
t_carte_statistique_parametre_simulation_caspars_pars_id_fkey | pars_id |
pars_id |
No Action |
No Action |
|
Immediate |
|
|
t_carte_statistique_parametre_simulation_caspars_scen_id_fkey | scen_id |
scen_id |
No Action |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
t_carte_statistique_parametre_simulat_caspars_annee_debut_check | (caspars_annee_debut >= 1959) AND ((caspars_annee_debut)::double precision <= date_part('year'::text, ('now'::text)::date)) |
|
t_carte_statistique_parametre_simulatio_caspars_annee_fin_check | (caspars_annee_fin >= 1959) AND ((caspars_annee_fin)::double precision <= date_part('year'::text, ('now'::text)::date)) |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
caspars_id |
|
|
|
Triggers
There are no triggers for table t_carte_statistique_parametre_simulation_caspars
Rules
There are no rules for table t_carte_statistique_parametre_simulation_caspars
Policies
There are no policies for table t_carte_statistique_parametre_simulation_caspars
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
tj_carte_ind_carte_stat_pars_caindsp_caindspars_caspars_id_fkey | caindspars_caspars_id |
caspars_id |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
caspars_id SERIAL,
caspars_nom_table VARCHAR(100) NOT NULL,
caspars_annee_debut SMALLINT,
caspars_annee_fin SMALLINT,
caspars_date_suppression DATE,
caspars_est_publiable BOOLEAN,
caspars_date_integration DATE,
gri_id INTEGER NOT NULL,
scen_id INTEGER NOT NULL,
pars_id INTEGER NOT NULL,
fic_id INTEGER NOT NULL,
CONSTRAINT t_carte_statistique_parametre_simulation_caspars_pkey PRIMARY KEY(caspars_id),
CONSTRAINT t_carte_statistique_parametre_simulat_caspars_annee_debut_check CHECK ((caspars_annee_debut >= 1959) AND ((caspars_annee_debut)::double precision <= date_part('year'::text, ('now'::text)::date))),
CONSTRAINT t_carte_statistique_parametre_simulatio_caspars_annee_fin_check CHECK ((caspars_annee_fin >= 1959) AND ((caspars_annee_fin)::double precision <= date_part('year'::text, ('now'::text)::date))),
CONSTRAINT t_carte_statistique_parametre_simulation_caspars_fic_id_fkey FOREIGN KEY (fic_id)
REFERENCES public.tr_fichier_fic(fic_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT t_carte_statistique_parametre_simulation_caspars_gri_id_fkey FOREIGN KEY (gri_id)
REFERENCES public.tr_grille_gri(gri_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT t_carte_statistique_parametre_simulation_caspars_pars_id_fkey FOREIGN KEY (pars_id)
REFERENCES public.tr_parametre_simulation_pars(pars_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT t_carte_statistique_parametre_simulation_caspars_scen_id_fkey FOREIGN KEY (scen_id)
REFERENCES public.tr_scenario_scen(scen_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.t_carte_statistique_parametre_simulation_caspars
IS 'Table de statistiques des cartes de paramètres de simulation';
COMMENT ON COLUMN public.t_carte_statistique_parametre_simulation_caspars.caspars_id
IS 'Identifiant';
COMMENT ON COLUMN public.t_carte_statistique_parametre_simulation_caspars.caspars_nom_table
IS 'Nom de la table ou sont contenues les données';
COMMENT ON COLUMN public.t_carte_statistique_parametre_simulation_caspars.caspars_annee_debut
IS 'Date de début';
COMMENT ON COLUMN public.t_carte_statistique_parametre_simulation_caspars.caspars_annee_fin
IS 'Date de fin';
COMMENT ON COLUMN public.t_carte_statistique_parametre_simulation_caspars.caspars_date_suppression
IS 'Date de suppression';
COMMENT ON COLUMN public.t_carte_statistique_parametre_simulation_caspars.caspars_est_publiable
IS 'Indique si la carte est publiable sur le site web';
COMMENT ON COLUMN public.t_carte_statistique_parametre_simulation_caspars.caspars_date_integration
IS 'Date de création de la carte';
COMMENT ON COLUMN public.t_carte_statistique_parametre_simulation_caspars.gri_id
IS 'Clé étrangère de la table tr_grille_gri';
COMMENT ON COLUMN public.t_carte_statistique_parametre_simulation_caspars.scen_id
IS 'Clé étrangère de la table tr_scenario_scen';
COMMENT ON COLUMN public.t_carte_statistique_parametre_simulation_caspars.pars_id
IS 'Clé étrangère de la table tr_parametre_simulation_pars';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|