pggeodb-preprod.nancy.inra.fr/db_pgd - db_pgd on pggeodb-preprod.nancy.inra.fr |
|
Table: layer
pggeodb-preprod.nancy.inra.fr/db_pgd - db_pgd on pggeodb-preprod.nancy.inra.fr |
|
Table: layer
Schema
Owner
postgres
Tablespace
(default)
Descriptions
There is no description for table layer
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
topology_id |
integer |
|
|
|
|
|
|
|
layer_id |
integer |
|
|
|
|
|
|
|
schema_name |
varchar |
|
|
|
|
|
|
|
table_name |
varchar |
|
|
|
|
|
|
|
feature_column |
varchar |
|
|
|
|
|
|
|
feature_type |
integer |
|
|
|
|
|
|
|
level |
integer |
|
|
|
0 |
|
|
|
child_id |
integer |
|
|
|
|
|
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
topology_id |
id |
No Action |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table layer
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
topology_id, layer_id |
|
|
|
|
btree |
|
schema_name, table_name, feature_column |
|
|
|
Triggers
Name | Type | Function | Arguments | Description |
|---|---|---|---|---|
layer_integrity_checks |
BEFORE UPDATE OR DELETE |
topology.layertrigger |
|
|
Rules
There are no rules for table layer
Policies
There are no policies for table layer
Referenced
There are no tables referenced by table layer
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
topology_id INTEGER NOT NULL,
layer_id INTEGER NOT NULL,
schema_name VARCHAR NOT NULL,
table_name VARCHAR NOT NULL,
feature_column VARCHAR NOT NULL,
feature_type INTEGER NOT NULL,
level INTEGER DEFAULT 0 NOT NULL,
child_id INTEGER,
CONSTRAINT layer_pkey PRIMARY KEY(topology_id, layer_id),
CONSTRAINT layer_schema_name_table_name_feature_column_key UNIQUE(schema_name, table_name, feature_column),
CONSTRAINT layer_topology_id_fkey FOREIGN KEY (topology_id)
REFERENCES topology.topology(id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
CREATE TRIGGER layer_integrity_checks
BEFORE UPDATE OR DELETE
ON topology.layer
FOR EACH ROW
EXECUTE PROCEDURE topology.layertrigger();
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|