Table tr_parametre_simulation

db_biljou_carto on db.silva.inrae.fr

Table: tr_parametre_simulation_pars

Schema

public

Owner

biljoucarto

Tablespace

(default)

Descriptions

Table des paramètres de simulation

Fields

Name	Data type	Default	Description
pars_id	serial	nextval('tr_parametre_simulation_pars_pars_id_seq'::regclass)	Identifiant
pars_libelle_fr	varchar(50)		Libellé en français du paramètre
pars_libelle_en	varchar(50)		Libellé en anglais du paramètre
pars_code_fr	varchar(9)		Code du paramètre en français
pars_code_en	varchar(9)		Code du paramètre en anglais

Foreign Keys

There are no foreign keys for table tr_parametre_simulation_pars

Check Constraints

There are no check constraints for table tr_parametre_simulation_pars

Indices

Name	Type	Function	Fields	Primary Key	Unique	Description
c_uni_pars	btree		pars_libelle_fr, pars_libelle_en, pars_code_fr, pars_code_en
tr_parametre_simulation_pars_pkey	btree		pars_id

Triggers

There are no triggers for table tr_parametre_simulation_pars

Rules

There are no rules for table tr_parametre_simulation_pars

Policies

There are no policies for table tr_parametre_simulation_pars

Referenced

Table	Schema	Foreign Key	Fields	FK Table	FK Fields	Delete Action	Update Action	Check Time
t_carte_parametre_simulation_capars	public	t_carte_parametre_simulation_capars_pars_id_fkey	pars_id	public.tr_parametre_simulation_pars	pars_id	No Action	No Action	Immediate
t_carte_statistique_parametre_simulation_caspars	public	t_carte_statistique_parametre_simulation_caspars_pars_id_fkey	pars_id	public.tr_parametre_simulation_pars	pars_id	No Action	No Action	Immediate
tr_style_sty	public	tr_style_sty_pars_id_fkey	sty_pars_id	public.tr_parametre_simulation_pars	pars_id	No Action	No Action	Immediate

Properties

Property	Value
Inherited From
Rows	8
Pages	1
System
Temporary
With OID

Definition

CREATE TABLE public.tr_parametre_simulation_pars ( pars_id SERIAL, pars_libelle_fr VARCHAR(50), pars_libelle_en VARCHAR(50), pars_code_fr VARCHAR(9), pars_code_en VARCHAR(9), CONSTRAINT c_uni_pars UNIQUE(pars_libelle_fr, pars_libelle_en, pars_code_fr, pars_code_en), CONSTRAINT tr_parametre_simulation_pars_pkey PRIMARY KEY(pars_id) ) ; COMMENT ON TABLE public.tr_parametre_simulation_pars IS 'Table des paramètres de simulation'; COMMENT ON COLUMN public.tr_parametre_simulation_pars.pars_id IS 'Identifiant'; COMMENT ON COLUMN public.tr_parametre_simulation_pars.pars_libelle_fr IS 'Libellé en français du paramètre '; COMMENT ON COLUMN public.tr_parametre_simulation_pars.pars_libelle_en IS 'Libellé en anglais du paramètre '; COMMENT ON COLUMN public.tr_parametre_simulation_pars.pars_code_fr IS 'Code du paramètre en français'; COMMENT ON COLUMN public.tr_parametre_simulation_pars.pars_code_en IS 'Code du paramètre en anglais';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23