pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr
Previous topic Chapter index Next topic

Table: tr_sig2006

 

 

Schema

public

 

Owner

cefs

 

Tablespace

(default)

 

Descriptions

There is no description for table tr_sig2006

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

gid

serial

 

nextval('tr_sig2006_gid_seq'::regclass)

 

 

 

recno

double precision

 

 

 

 

 

 

 

area

double precision

 

 

 

 

 

 

 

os_06

varchar(20)

 

 

 

 

 

 

 

grd_cat_06

varchar(20)

 

 

 

 

 

 

 

perimetre

numeric(10,0)

 

 

 

 

 

 

 

geom

public.geometry

 

 

 

 

 

 

Foreign Keys

There are no foreign keys for table tr_sig2006

 

Check Constraints

There are no check constraints for table tr_sig2006

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

tr_sig2006_geom_idx

gist

 

geom

 

 

 

tr_sig2006_pkey

btree

 

gid

 

 

Triggers

There are no triggers for table tr_sig2006

 

Rules

There are no rules for table tr_sig2006

 

Policies

There are no policies for table tr_sig2006

 

Referenced

There are no tables referenced by table tr_sig2006

 

Properties

Property

Value

Inherited From

 

Rows

20097

Pages

3167

System

 

Temporary

 

With OID

 

 

Definition

CREATE TABLE public.tr_sig2006 (
 gid SERIAL,
 recno DOUBLE PRECISION,
 area DOUBLE PRECISION,
 os_06 VARCHAR(20),
 grd_cat_06 VARCHAR(20),
 perimetre NUMERIC(10,0),
 geom public.geometry,
 CONSTRAINT tr_sig2006_pkey PRIMARY KEY(gid)
)
WITH (oids = false);

CREATE INDEX tr_sig2006_geom_idx ON public.tr_sig2006
 USING gist (geom public.gist_geometry_ops_2d);

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