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