db.silva.inrae.fr/db_biljou_param - db_biljou_param on db.silva.inrae.fr |
|
Table: tr_srid_sri
db.silva.inrae.fr/db_biljou_param - db_biljou_param on db.silva.inrae.fr |
|
Table: tr_srid_sri
Schema
Owner
postgres
Tablespace
(default)
Descriptions
table contenant les différents identifiants de référence spatiale
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
sri_id |
serial |
|
|
|
nextval('tr_srid_sri_sri_id_seq'::regclass) |
identifiant automatique du srid |
|
|
sri_nom |
varchar(50) |
|
|
|
|
nom du srid |
|
|
sri_code_epsg |
integer |
|
|
|
|
code epsg (European Petroleum Survey Group) |
|
|
sri_xmin |
double precision |
|
|
|
|
Borne inférieure des valeurs X autorisées |
|
|
sri_xmax |
double precision |
|
|
|
|
Borne supérieure des valeurs X autorisées |
|
|
sri_ymin |
double precision |
|
|
|
|
Borne inférieure des valeurs Y autorisées |
|
|
sri_ymax |
double precision |
|
|
|
|
Borne supérieure des valeurs Y autorisées |
Foreign Keys
There are no foreign keys for table tr_srid_sri
Check Constraints
There are no check constraints for table tr_srid_sri
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
sri_code_epsg |
|
|
unicité du code EPSG |
|
btree |
|
sri_nom |
|
|
unicité du nom du SRI |
|
btree |
|
sri_id |
|
|
|
Triggers
There are no triggers for table tr_srid_sri
Rules
There are no rules for table tr_srid_sri
Policies
There are no policies for table tr_srid_sri
Referenced
Table | Schema | Foreign Key | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
geo_sri_id |
sri_id |
No Action |
No Action |
|
Immediate |
Une géométrie est rattachée à un et un seul srid |
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
5 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
|
Definition
sri_id SERIAL,
sri_nom VARCHAR(50) NOT NULL,
sri_code_epsg INTEGER NOT NULL,
sri_xmin DOUBLE PRECISION,
sri_xmax DOUBLE PRECISION,
sri_ymin DOUBLE PRECISION,
sri_ymax DOUBLE PRECISION,
CONSTRAINT c_uni_code_epsg_sri UNIQUE(sri_code_epsg),
CONSTRAINT c_uni_nom_sri UNIQUE(sri_nom),
CONSTRAINT tr_srid_sri_pkey PRIMARY KEY(sri_id)
) ;
COMMENT ON TABLE public.tr_srid_sri
IS 'table contenant les différents identifiants de référence spatiale';
COMMENT ON COLUMN public.tr_srid_sri.sri_id
IS 'identifiant automatique du srid';
COMMENT ON COLUMN public.tr_srid_sri.sri_nom
IS 'nom du srid';
COMMENT ON COLUMN public.tr_srid_sri.sri_code_epsg
IS 'code epsg (European Petroleum Survey Group)';
COMMENT ON COLUMN public.tr_srid_sri.sri_xmin
IS 'Borne inférieure des valeurs X autorisées';
COMMENT ON COLUMN public.tr_srid_sri.sri_xmax
IS 'Borne supérieure des valeurs X autorisées';
COMMENT ON COLUMN public.tr_srid_sri.sri_ymin
IS 'Borne inférieure des valeurs Y autorisées';
COMMENT ON COLUMN public.tr_srid_sri.sri_ymax
IS 'Borne supérieure des valeurs Y autorisées';
COMMENT ON CONSTRAINT c_uni_code_epsg_sri ON public.tr_srid_sri
IS 'unicité du code EPSG';
COMMENT ON CONSTRAINT c_uni_nom_sri ON public.tr_srid_sri
IS 'unicité du nom du SRI';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|