pggeodb-preprod.nancy.inra.fr/db_diams |
|
Table: bloc_diams
pggeodb-preprod.nancy.inra.fr/db_diams |
|
Table: bloc_diams
Schema
Owner
postgres
Tablespace
(default)
Descriptions
There is no description for table bloc_diams
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
id_bloc |
serial |
|
|
|
nextval('bloc_diams_id_bloc_seq'::regclass) |
|
|
|
bloc |
integer |
|
|
|
|
|
|
|
geom |
public.geometry |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table bloc_diams
Check Constraints
There are no check constraints for table bloc_diams
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
id_bloc |
|
|
|
Triggers
There are no triggers for table bloc_diams
Rules
There are no rules for table bloc_diams
Policies
There are no policies for table bloc_diams
Referenced
Table | Schema | Foreign Key | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
id_bloc_placette |
id_bloc |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
3 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
|
Definition
id_bloc SERIAL,
bloc INTEGER,
geom public.geometry,
CONSTRAINT pmk_bloc PRIMARY KEY(id_bloc)
) ;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|