db_biljou_carto on db.silva.inrae.fr
Previous topic Chapter index Next topic

Table: t_carte_parametre_simulation_capars

 

 

Schema

public

 

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

t_carte_parametre_simulation_capars_fic_id_fkey

fic_id

public.tr_fichier_fic

fic_id

No Action

No Action

 

Immediate

 

t_carte_parametre_simulation_capars_gri_id_fkey

gri_id

public.tr_grille_gri

gri_id

No Action

No Action

 

Immediate

 

t_carte_parametre_simulation_capars_pars_id_fkey

pars_id

public.tr_parametre_simulation_pars

pars_id

No Action

No Action

 

Immediate

 

t_carte_parametre_simulation_capars_scen_id_fkey

scen_id

public.tr_scenario_scen

scen_id

No Action

No Action

 

Immediate

 

 

Check Constraints

Name

Condition

Description

t_carte_parametre_simulation_capars_capars_annee_check

(capars_annee >= 1959) AND ((capars_annee)::double precision <= date_part('year'::text, ('now'::text)::date))

 

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

t_carte_parametre_simulation_capars_pkey

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

tj_carte_ind_carte_pars_caindpars

public

tj_carte_ind_carte_pars_caindpars_caindpars_capars_id_fkey

caindpars_capars_id

public.t_carte_parametre_simulation_capars

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
Previous topic Chapter index Next topic