Schema
Owner
albenard
Tablespace
(default)
Descriptions
There is no description for table sig_collection_anc
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
collection |
public.ltree |
|
|
|
|||
|
|
geom_text |
text |
|
|
|
|
|
|
|
geom |
public.geometry |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table sig_collection_anc
Check Constraints
There are no check constraints for table sig_collection_anc
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
collection |
|
Triggers
There are no triggers for table sig_collection_anc
Rules
There are no rules for table sig_collection_anc
Policies
There are no policies for table sig_collection_anc
Referenced
There are no tables referenced by table sig_collection_anc
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
678 |
Pages |
67 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.sig_collection_anc (
collection public.ltree NOT NULL,
geom_text TEXT,
geom public.geometry,
CONSTRAINT sig_collection_anc_pkey PRIMARY KEY(collection)
) ;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |