pggeodb.nancy.inrae.fr/db_arboretum
Previous topic Chapter index Next topic

Table: sig_collection

 

 

Schema

public

 

Owner

albenard

 

Tablespace

(default)

 

Descriptions

There is no description for table sig_collection

 

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

 

Check Constraints

There are no check constraints for table sig_collection

 

Indices

Name

Type

Function

Columns

Primary Key

Unique

Description

sig_collection_pkey

btree

 

collection

 

 

Triggers

There are no triggers for table sig_collection

 

Rules

There are no rules for table sig_collection

 

Policies

There are no policies for table sig_collection

 

Referenced

There are no tables referenced by table sig_collection

 

Properties

Property

Value

Inherited From

 

Rows

651

Pages

65

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE public.sig_collection (
 collection public.ltree NOT NULL,
 geom_text TEXT,
 geom public.geometry,
 CONSTRAINT sig_collection_pkey PRIMARY KEY(collection)
) ;

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23
Previous topic Chapter index Next topic