pggeodb-preprod.nancy.inra.fr/db_diams |
|
Table: BDE
pggeodb-preprod.nancy.inra.fr/db_diams |
|
Table: BDE
Schema
Owner
postgres
Tablespace
(default)
Descriptions
There is no description for table BDE
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
id_0 |
serial |
|
|
|
nextval('"BDE_id_0_seq"'::regclass) |
|
|
|
geom |
public.geometry |
|
|
|
|
|
|
|
id |
bigint |
|
|
|
|
|
|
|
systeme |
varchar(2) |
|
|
|
|
|
|
|
bloc |
integer |
|
|
|
|
|
|
|
traitement |
varchar(1) |
|
|
|
|
|
|
|
rang |
integer |
|
|
|
|
|
|
|
nom |
varchar(7) |
|
|
|
|
|
|
|
superficie |
bigint |
|
|
|
|
|
|
|
s |
varchar(1) |
|
|
|
|
|
|
|
longueur |
integer |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table BDE
Check Constraints
There are no check constraints for table BDE
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
id_0 |
|
|
|
Triggers
There are no triggers for table BDE
Rules
There are no rules for table BDE
Policies
There are no policies for table BDE
Referenced
There are no tables referenced by table BDE
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
70 |
Pages |
2 |
System |
|
Temporary |
|
With OID |
|
Definition
id_0 SERIAL,
geom public.geometry,
id BIGINT,
systeme VARCHAR(2),
bloc INTEGER,
traitement VARCHAR(1),
rang INTEGER,
nom VARCHAR(7),
superficie BIGINT,
s VARCHAR(1),
longueur INTEGER,
CONSTRAINT "BDE_pkey" PRIMARY KEY(id_0)
) ;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|