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