Schema
Owner
postgres
Tablespace
(default)
Descriptions
Table of environmental characteristic groups / Table des groupes de caractéristiques de l'environnement
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
gch_id |
serial |
|
nextval('t_group_characteristic_gch_gch_id_seq'::regclass) |
Automatic ID of the environmental characteristic group / Identifiant automatique du groupe de caractéristiques de l'environnement |
|||
|
|
gch_definition |
varchar(64) |
|
|
Environmental characteristic group definition /Définition liée au groupe de caractéristiques de l'environnement |
||
|
|
gch_author |
varchar(64) |
|
|
|
Environmental characteristic group author / Auteur ayant créé le groupe de caractéristiques de l'environnement |
Foreign Keys
There are no foreign keys for table t_group_characteristic_gch
Check Constraints
There are no check constraints for table t_group_characteristic_gch
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
gch_definition |
|
gch_definition must be unique / le champ gch_definition ne peut contenir de doublons |
||
btree |
|
gch_id |
|
Triggers
There are no triggers for table t_group_characteristic_gch
Rules
There are no rules for table t_group_characteristic_gch
Policies
There are no policies for table t_group_characteristic_gch
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|---|---|
conn_gch_id |
gch_id |
No Action |
No Action |
|
Immediate |
Connection involves only one characteristic group / L'association concerne un et un seul groupe de caractéristiques |
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
CREATE TABLE public.t_group_characteristic_gch (
gch_id SERIAL,
gch_definition VARCHAR(64) NOT NULL,
gch_author VARCHAR(64) NOT NULL,
CONSTRAINT c_uni_definition_gch UNIQUE(gch_definition),
CONSTRAINT t_group_characteristic_gch_pkey PRIMARY KEY(gch_id)
)
WITH (oids = false);
COMMENT ON TABLE public.t_group_characteristic_gch
IS 'Table of environmental characteristic groups / Table des groupes de caractéristiques de l''environnement ';
COMMENT ON COLUMN public.t_group_characteristic_gch.gch_id
IS 'Automatic ID of the environmental characteristic group / Identifiant automatique du groupe de caractéristiques de l''environnement';
COMMENT ON COLUMN public.t_group_characteristic_gch.gch_definition
IS 'Environmental characteristic group definition /Définition liée au groupe de caractéristiques de l''environnement';
COMMENT ON COLUMN public.t_group_characteristic_gch.gch_author
IS 'Environmental characteristic group author / Auteur ayant créé le groupe de caractéristiques de l''environnement';
COMMENT ON CONSTRAINT c_uni_definition_gch ON public.t_group_characteristic_gch
IS 'gch_definition must be unique / le champ gch_definition ne peut contenir de doublons';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 19/06/2019 10:17 |