db_biljou_carto on db.silva.inrae.fr |
|
Table: t_carte_statistique_indicateur_casind
db_biljou_carto on db.silva.inrae.fr |
|
Table: t_carte_statistique_indicateur_casind
Schema
Owner
biljoucarto
Tablespace
(default)
Descriptions
Table des cartes de statistiques d'indicateurs
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
casind_id |
serial |
|
|
|
nextval('t_carte_statistique_indicateur_casind_casind_id_seq'::regclass) |
Identifiant |
|
|
casind_nom_table |
varchar(100) |
|
|
|
|
Nom de la table fonctionnelle contenant les données |
|
|
casind_annee_debut |
smallint |
|
|
|
|
Année de début de la période |
|
|
casind_annee_fin |
smallint |
|
|
|
|
Année de fin de la période |
|
|
casind_est_publiable |
boolean |
|
|
|
|
Précise si la carte est publiable ou non |
|
|
casind_date_integration |
date |
|
|
|
|
Date de création de la carte |
|
|
casind_scen_id |
integer |
|
|
|
|
Clé étrangère table scénario |
|
|
casind_gri_id |
integer |
|
|
|
|
Clé étrangère table grille |
|
|
casind_comb_id |
integer |
|
|
|
|
Clé étrangère table combinaison |
|
|
casind_ind_id |
integer |
|
|
|
|
Clé étrangère table indicateur |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
casind_comb_id |
comb_id |
No Action |
No Action |
|
Immediate |
|
||
casind_gri_id |
gri_id |
No Action |
No Action |
|
Immediate |
|
||
casind_ind_id |
ind_id |
No Action |
No Action |
|
Immediate |
|
||
casind_scen_id |
scen_id |
No Action |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
t_carte_statistique_indicateur_casind_casind_annee_debut_check | (casind_annee_debut >= 1959) AND ((casind_annee_debut)::double precision <= date_part('year'::text, ('now'::text)::date)) |
|
t_carte_statistique_indicateur_casind_casind_annee_fin_check | (casind_annee_fin >= 1959) AND ((casind_annee_fin)::double precision <= date_part('year'::text, ('now'::text)::date)) |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
casind_annee_debut, casind_annee_fin, casind_comb_id, casind_ind_id, casind_scen_id, casind_gri_id |
|
|
|
|
btree |
|
casind_id |
|
|
|
Triggers
There are no triggers for table t_carte_statistique_indicateur_casind
Rules
There are no rules for table t_carte_statistique_indicateur_casind
Policies
There are no policies for table t_carte_statistique_indicateur_casind
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
caind_casind_id |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
debmed_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
defmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
||||
durmoy_cartid |
casind_id |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
960 |
Pages |
12 |
System |
|
Temporary |
|
With OID |
|
Definition
casind_id SERIAL,
casind_nom_table VARCHAR(100) NOT NULL,
casind_annee_debut SMALLINT,
casind_annee_fin SMALLINT,
casind_est_publiable BOOLEAN,
casind_date_integration DATE,
casind_scen_id INTEGER NOT NULL,
casind_gri_id INTEGER NOT NULL,
casind_comb_id INTEGER NOT NULL,
casind_ind_id INTEGER NOT NULL,
CONSTRAINT c_uni_casind UNIQUE(casind_annee_debut, casind_annee_fin, casind_comb_id, casind_ind_id, casind_scen_id, casind_gri_id),
CONSTRAINT t_carte_statistique_indicateur_casind_pkey PRIMARY KEY(casind_id),
CONSTRAINT t_carte_statistique_indicateur_casind_casind_annee_debut_check CHECK ((casind_annee_debut >= 1959) AND ((casind_annee_debut)::double precision <= date_part('year'::text, ('now'::text)::date))),
CONSTRAINT t_carte_statistique_indicateur_casind_casind_annee_fin_check CHECK ((casind_annee_fin >= 1959) AND ((casind_annee_fin)::double precision <= date_part('year'::text, ('now'::text)::date))),
CONSTRAINT t_carte_statistique_indicateur_casind_comb_id_fkey FOREIGN KEY (casind_comb_id)
REFERENCES public.tr_combinaison_comb(comb_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT t_carte_statistique_indicateur_casind_gri_id_fkey FOREIGN KEY (casind_gri_id)
REFERENCES public.tr_grille_gri(gri_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT t_carte_statistique_indicateur_casind_ind_id_fkey FOREIGN KEY (casind_ind_id)
REFERENCES public.tr_indicateur_ind(ind_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT t_carte_statistique_indicateur_casind_scen_id_fkey FOREIGN KEY (casind_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_indicateur_casind
IS 'Table des cartes de statistiques d''indicateurs';
COMMENT ON COLUMN public.t_carte_statistique_indicateur_casind.casind_id
IS 'Identifiant';
COMMENT ON COLUMN public.t_carte_statistique_indicateur_casind.casind_nom_table
IS 'Nom de la table fonctionnelle contenant les données';
COMMENT ON COLUMN public.t_carte_statistique_indicateur_casind.casind_annee_debut
IS 'Année de début de la période';
COMMENT ON COLUMN public.t_carte_statistique_indicateur_casind.casind_annee_fin
IS 'Année de fin de la période';
COMMENT ON COLUMN public.t_carte_statistique_indicateur_casind.casind_est_publiable
IS 'Précise si la carte est publiable ou non';
COMMENT ON COLUMN public.t_carte_statistique_indicateur_casind.casind_date_integration
IS 'Date de création de la carte';
COMMENT ON COLUMN public.t_carte_statistique_indicateur_casind.casind_scen_id
IS 'Clé étrangère table scénario';
COMMENT ON COLUMN public.t_carte_statistique_indicateur_casind.casind_gri_id
IS 'Clé étrangère table grille';
COMMENT ON COLUMN public.t_carte_statistique_indicateur_casind.casind_comb_id
IS 'Clé étrangère table combinaison';
COMMENT ON COLUMN public.t_carte_statistique_indicateur_casind.casind_ind_id
IS 'Clé étrangère table indicateur';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|