pggeodb.nancy.inrae.fr/db_arboretum |
|
Table: sig_pointgeodesique_geod
pggeodb.nancy.inrae.fr/db_arboretum |
|
Table: sig_pointgeodesique_geod
Schema
Owner
albenard
Tablespace
(default)
Descriptions
There is no description for table sig_pointgeodesique_geod
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
geod_id |
serial |
|
|
|
nextval('sig_pointgeodesique_geod_geod_id_seq'::regclass) |
|
|
|
geod_cle |
varchar(20) |
|
|
|
|
clé naturelle |
|
|
geod_libelle |
varchar(128) |
|
|
|
|
Libellé du point geodésique |
|
|
geod_forme |
varchar(64) |
|
|
|
|
Forme du repère (Borne, clocher ...) |
|
|
geod_xl93 |
double precision |
|
|
|
|
X en lambert 93 du point |
|
|
geod_yl93 |
double precision |
|
|
|
|
Y en lambert 93 du point |
|
|
geod_latitude |
varchar(20) |
|
|
|
|
Latitude textuelle (°, ', '') |
|
|
geod_longitude |
varchar(20) |
|
|
|
|
Longitude textuelle (°, ', '') |
|
|
geom |
public.geometry |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table sig_pointgeodesique_geod
Check Constraints
There are no check constraints for table sig_pointgeodesique_geod
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
geod_cle |
|
|
|
|
btree |
|
geod_id |
|
|
|
Triggers
There are no triggers for table sig_pointgeodesique_geod
Rules
There are no rules for table sig_pointgeodesique_geod
Policies
There are no policies for table sig_pointgeodesique_geod
Referenced
There are no tables referenced by table sig_pointgeodesique_geod
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
5 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
|
Definition
geod_id SERIAL,
geod_cle VARCHAR(20),
geod_libelle VARCHAR(128),
geod_forme VARCHAR(64),
geod_xl93 DOUBLE PRECISION,
geod_yl93 DOUBLE PRECISION,
geod_latitude VARCHAR(20),
geod_longitude VARCHAR(20),
geom public.geometry,
CONSTRAINT sig_pointgeodesique_geod_cle_key UNIQUE(geod_cle),
CONSTRAINT sig_pointgeodesique_geod_sig_pointgeodesique_pkey PRIMARY KEY(geod_id)
) ;
ALTER TABLE public.sig_pointgeodesique_geod
ALTER COLUMN geod_id SET STATISTICS 0;
ALTER TABLE public.sig_pointgeodesique_geod
ALTER COLUMN geod_cle SET STATISTICS 0;
ALTER TABLE public.sig_pointgeodesique_geod
ALTER COLUMN geod_libelle SET STATISTICS 0;
ALTER TABLE public.sig_pointgeodesique_geod
ALTER COLUMN geod_forme SET STATISTICS 0;
ALTER TABLE public.sig_pointgeodesique_geod
ALTER COLUMN geod_xl93 SET STATISTICS 0;
ALTER TABLE public.sig_pointgeodesique_geod
ALTER COLUMN geod_yl93 SET STATISTICS 0;
ALTER TABLE public.sig_pointgeodesique_geod
ALTER COLUMN geod_latitude SET STATISTICS 0;
ALTER TABLE public.sig_pointgeodesique_geod
ALTER COLUMN geod_longitude SET STATISTICS 0;
COMMENT ON COLUMN public.sig_pointgeodesique_geod.geod_cle
IS 'clé naturelle';
COMMENT ON COLUMN public.sig_pointgeodesique_geod.geod_libelle
IS 'Libellé du point geodésique';
COMMENT ON COLUMN public.sig_pointgeodesique_geod.geod_forme
IS 'Forme du repère (Borne, clocher ...)';
COMMENT ON COLUMN public.sig_pointgeodesique_geod.geod_xl93
IS 'X en lambert 93 du point';
COMMENT ON COLUMN public.sig_pointgeodesique_geod.geod_yl93
IS 'Y en lambert 93 du point';
COMMENT ON COLUMN public.sig_pointgeodesique_geod.geod_latitude
IS 'Latitude textuelle (°, '', '''')';
COMMENT ON COLUMN public.sig_pointgeodesique_geod.geod_longitude
IS 'Longitude textuelle (°, '', '''')';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|