pggeodb-preprod.nancy.inra.fr/db_diams |
|
Table: robinier
pggeodb-preprod.nancy.inra.fr/db_diams |
|
Table: robinier
Schema
Owner
postgres
Tablespace
(default)
Descriptions
There is no description for table robinier
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
id_robin |
serial |
|
|
|
nextval('robinier_id_robin_seq'::regclass) |
|
|
|
geom |
public.geometry |
|
|
|
|
|
|
|
name |
varchar(16) |
|
|
|
|
|
|
|
code |
varchar(60) |
|
|
|
|
|
|
|
northing |
double precision |
|
|
|
|
|
|
|
easting |
double precision |
|
|
|
|
|
|
|
elevation |
double precision |
|
|
|
|
|
|
|
layer |
varchar(100) |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table robinier
Check Constraints
There are no check constraints for table robinier
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
id_robin |
|
|
|
|
gist |
|
geom |
|
|
|
Triggers
There are no triggers for table robinier
Rules
There are no rules for table robinier
Policies
There are no policies for table robinier
Referenced
There are no tables referenced by table robinier
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
1822 |
Pages |
32 |
System |
|
Temporary |
|
With OID |
|
Definition
id_robin SERIAL,
geom public.geometry,
name VARCHAR(16),
code VARCHAR(60),
northing DOUBLE PRECISION,
easting DOUBLE PRECISION,
elevation DOUBLE PRECISION,
layer VARCHAR(100),
CONSTRAINT robinier_pkey PRIMARY KEY(id_robin)
) ;
CREATE INDEX sidx_robinier_geom ON public.robinier
USING gist (geom public.gist_geometry_ops_2d);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|