Schema
Owner
biljoucarto
Tablespace
(default)
Descriptions
Table des cartes de paramètres de simulation
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
capars_id |
serial |
|
nextval('t_carte_parametre_simulation_capars_capars_id_seq'::regclass) |
Identifiant |
|||
|
|
capars_nom_table |
varchar(100) |
|
|
|
Nom de la table contenant les données |
|
|
|
capars_annee |
smallint |
|
|
|
|
Année |
|
|
cappasim_date_suppression |
date |
|
|
|
|
Date de suppression de la carte |
|
|
capars_est_publiable |
boolean |
|
|
|
|
Indique si la carte peut être publiée sur le site web |
|
|
capars_date_integration |
date |
|
|
|
|
Date de création de la carte |
|
gri_id |
integer |
|
|
|
Clé étrangère de la table tr_grille_gri |
||
|
pars_id |
integer |
|
|
|
Clé étrangère de la table tr_parametre_simulation_pars |
||
|
fic_id |
integer |
|
|
|
Clé étrangère de la table tr_fichier_fic |
||
|
scen_id |
integer |
|
|
|
Clé étrangère de la table tr_scenario_scen |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|
fic_id |
fic_id |
No Action |
No Action |
|
Immediate |
|
||
gri_id |
gri_id |
No Action |
No Action |
|
Immediate |
|
||
pars_id |
pars_id |
No Action |
No Action |
|
Immediate |
|
||
scen_id |
scen_id |
No Action |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
---|---|---|
(capars_annee >= 1959) AND ((capars_annee)::double precision <= date_part('year'::text, ('now'::text)::date)) |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
capars_id |
|
Triggers
There are no triggers for table t_carte_parametre_simulation_capars
Rules
There are no rules for table t_carte_parametre_simulation_capars
Policies
There are no policies for table t_carte_parametre_simulation_capars
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|---|---|
caindpars_capars_id |
capars_id |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.t_carte_parametre_simulation_capars (
capars_id SERIAL,
capars_nom_table VARCHAR(100) NOT NULL,
capars_annee SMALLINT,
cappasim_date_suppression DATE,
capars_est_publiable BOOLEAN,
capars_date_integration DATE,
gri_id INTEGER NOT NULL,
pars_id INTEGER NOT NULL,
fic_id INTEGER NOT NULL,
scen_id INTEGER NOT NULL,
CONSTRAINT t_carte_parametre_simulation_capars_pkey PRIMARY KEY(capars_id),
CONSTRAINT t_carte_parametre_simulation_capars_capars_annee_check CHECK ((capars_annee >= 1959) AND ((capars_annee)::double precision <= date_part('year'::text, ('now'::text)::date))),
CONSTRAINT t_carte_parametre_simulation_capars_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_parametre_simulation_capars_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_parametre_simulation_capars_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_parametre_simulation_capars_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_parametre_simulation_capars
IS 'Table des cartes de paramètres de simulation';
COMMENT ON COLUMN public.t_carte_parametre_simulation_capars.capars_id
IS 'Identifiant';
COMMENT ON COLUMN public.t_carte_parametre_simulation_capars.capars_nom_table
IS 'Nom de la table contenant les données';
COMMENT ON COLUMN public.t_carte_parametre_simulation_capars.capars_annee
IS 'Année';
COMMENT ON COLUMN public.t_carte_parametre_simulation_capars.cappasim_date_suppression
IS 'Date de suppression de la carte';
COMMENT ON COLUMN public.t_carte_parametre_simulation_capars.capars_est_publiable
IS 'Indique si la carte peut être publiée sur le site web';
COMMENT ON COLUMN public.t_carte_parametre_simulation_capars.capars_date_integration
IS 'Date de création de la carte';
COMMENT ON COLUMN public.t_carte_parametre_simulation_capars.gri_id
IS 'Clé étrangère de la table tr_grille_gri';
COMMENT ON COLUMN public.t_carte_parametre_simulation_capars.pars_id
IS 'Clé étrangère de la table tr_parametre_simulation_pars';
COMMENT ON COLUMN public.t_carte_parametre_simulation_capars.fic_id
IS 'Clé étrangère de la table tr_fichier_fic';
COMMENT ON COLUMN public.t_carte_parametre_simulation_capars.scen_id
IS 'Clé étrangère de la table tr_scenario_scen';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
![]() ![]() ![]() |