Schema
Owner
biljoucarto
Tablespace
(default)
Descriptions
Table des styles
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
sty_id |
serial |
|
nextval('tr_style_sty_sty_id_seq'::regclass) |
Identifiant |
|||
|
|
sty_nom_style_geoserver |
varchar(50) |
|
|
|
Nom du style sur Geoserver |
|
|
|
sty_libelle_fr |
varchar(50) |
|
|
|
Libellé du style en français |
|
|
|
sty_libelle_en |
varchar(50) |
|
|
|
Libellé du style en anglais |
|
|
|
sty_style_defaut |
boolean |
|
|
|
|
Indique si c'est le style par défaut |
|
sty_ind_id |
integer |
|
|
|
Clé étrangère de la table tr_indicateur_ind |
||
|
sty_pars_id |
integer |
|
|
|
Clé étrangère de la table tr_parametre_simulation_pars |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|
sty_ind_id |
ind_id |
No Action |
No Action |
|
Immediate |
|
||
sty_pars_id |
pars_id |
No Action |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table tr_style_sty
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
sty_id |
|
|||
btree |
|
sty_libelle_en |
|
|
||
btree |
|
sty_libelle_fr |
|
|
||
btree |
|
sty_nom_style_geoserver |
|
|
Triggers
There are no triggers for table tr_style_sty
Rules
There are no rules for table tr_style_sty
Policies
There are no policies for table tr_style_sty
Referenced
There are no tables referenced by table tr_style_sty
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
9 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.tr_style_sty (
sty_id SERIAL,
sty_nom_style_geoserver VARCHAR(50),
sty_libelle_fr VARCHAR(50),
sty_libelle_en VARCHAR(50),
sty_style_defaut BOOLEAN,
sty_ind_id INTEGER NOT NULL,
sty_pars_id INTEGER NOT NULL,
CONSTRAINT tr_style_sty_pkey PRIMARY KEY(sty_id),
CONSTRAINT tr_style_sty_sty_libelle_en_key UNIQUE(sty_libelle_en),
CONSTRAINT tr_style_sty_sty_libelle_fr_key UNIQUE(sty_libelle_fr),
CONSTRAINT tr_style_sty_sty_nom_style_geoserver_key UNIQUE(sty_nom_style_geoserver),
CONSTRAINT tr_style_sty_ind_id_fkey FOREIGN KEY (sty_ind_id)
REFERENCES public.tr_indicateur_ind(ind_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT tr_style_sty_pars_id_fkey FOREIGN KEY (sty_pars_id)
REFERENCES public.tr_parametre_simulation_pars(pars_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tr_style_sty
IS 'Table des styles ';
COMMENT ON COLUMN public.tr_style_sty.sty_id
IS 'Identifiant';
COMMENT ON COLUMN public.tr_style_sty.sty_nom_style_geoserver
IS 'Nom du style sur Geoserver';
COMMENT ON COLUMN public.tr_style_sty.sty_libelle_fr
IS 'Libellé du style en français';
COMMENT ON COLUMN public.tr_style_sty.sty_libelle_en
IS 'Libellé du style en anglais';
COMMENT ON COLUMN public.tr_style_sty.sty_style_defaut
IS 'Indique si c''est le style par défaut';
COMMENT ON COLUMN public.tr_style_sty.sty_ind_id
IS 'Clé étrangère de la table tr_indicateur_ind';
COMMENT ON COLUMN public.tr_style_sty.sty_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 |
![]() ![]() ![]() |