pggeodb.nancy.inrae.fr/db_arboretum |
|
Table: relation
pggeodb.nancy.inrae.fr/db_arboretum |
|
Table: relation
Schema
Owner
albenard
Tablespace
(default)
Descriptions
There is no description for table relation
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
topogeo_id |
integer |
|
|
|
|
|
|
|
layer_id |
integer |
|
|
|
|
|
|
|
element_id |
integer |
|
|
|
|
|
|
|
element_type |
integer |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table relation
Check Constraints
There are no check constraints for table relation
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
layer_id, topogeo_id, element_id, element_type |
|
|
|
Triggers
Name | Type | Function | Arguments | Description |
|---|---|---|---|---|
relation_integrity_checks |
BEFORE INSERT OR UPDATE |
topology.relationtrigger |
'2', 'placeautopo' |
|
Rules
There are no rules for table relation
Policies
There are no policies for table relation
Referenced
There are no tables referenced by table relation
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
144 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
|
Definition
topogeo_id INTEGER NOT NULL,
layer_id INTEGER NOT NULL,
element_id INTEGER NOT NULL,
element_type INTEGER NOT NULL,
CONSTRAINT relation_layer_id_topogeo_id_element_id_element_type_key UNIQUE(layer_id, topogeo_id, element_id, element_type)
) ;
CREATE TRIGGER relation_integrity_checks
BEFORE INSERT OR UPDATE
ON placeautopo.relation
FOR EACH ROW
EXECUTE PROCEDURE topology.relationtrigger('2', 'placeautopo');
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|