pggeodb-preprod.nancy.inra.fr/db_diams |
|
Table: Tranchees
pggeodb-preprod.nancy.inra.fr/db_diams |
|
Table: Tranchees
Schema
Owner
postgres
Tablespace
(default)
Descriptions
There is no description for table Tranchees
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
id_tranch |
serial |
|
|
|
nextval('"Tranchees_id_tranch_seq"'::regclass) |
|
|
|
geom |
public.geometry |
|
|
|
|
|
|
|
id |
bigint |
|
|
|
|
|
|
|
départ |
varchar(10) |
|
|
|
|
|
|
|
arrivée |
varchar(10) |
|
|
|
|
|
|
|
fait |
integer |
|
|
|
|
|
|
|
ouv/est/d |
varchar(1) |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table Tranchees
Check Constraints
There are no check constraints for table Tranchees
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
id_tranch |
|
|
|
|
gist |
|
geom |
|
|
|
Triggers
There are no triggers for table Tranchees
Rules
There are no rules for table Tranchees
Policies
There are no policies for table Tranchees
Referenced
There are no tables referenced by table Tranchees
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
31 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
|
Definition
id_tranch SERIAL,
geom public.geometry,
id BIGINT,
"départ" VARCHAR(10),
"arrivée" VARCHAR(10),
fait INTEGER,
"ouv/est/d" VARCHAR(1),
CONSTRAINT "Tranchees_pkey" PRIMARY KEY(id_tranch)
) ;
CREATE INDEX "sidx_Tranchees_geom" ON public."Tranchees"
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 |
|