pggeodb.nancy.inrae.fr/db_arboretum |
|
Table: face
pggeodb.nancy.inrae.fr/db_arboretum |
|
Table: face
Schema
Owner
albenard
Tablespace
(default)
Descriptions
Contains face topology primitives
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
face_id |
serial |
|
|
|
nextval('placeautopo.face_face_id_seq'::regclass) |
|
|
|
mbr |
public.geometry |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table face
Check Constraints
There are no check constraints for table face
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
gist |
|
mbr |
|
|
|
|
btree |
|
face_id |
|
|
|
Triggers
There are no triggers for table face
Rules
There are no rules for table face
Policies
There are no policies for table face
Referenced
Table | Schema | Foreign Key | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
left_face |
face_id |
No Action |
No Action |
|
Immediate |
|
||||
right_face |
face_id |
No Action |
No Action |
|
Immediate |
|
||||
containing_face |
face_id |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
99 |
Pages |
2 |
System |
|
Temporary |
|
With OID |
|
Definition
face_id SERIAL,
mbr public.geometry,
CONSTRAINT face_primary_key PRIMARY KEY(face_id)
) ;
COMMENT ON TABLE placeautopo.face
IS 'Contains face topology primitives';
CREATE INDEX face_gist ON placeautopo.face
USING gist (mbr public.gist_geometry_ops_2d);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|