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

Table: sig_placeau_lisieres

 

 

Schema

public

 

Owner

arboretum

 

Tablespace

(default)

 

Descriptions

There is no description for table sig_placeau_lisieres

 

Columns

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

gid

serial

 

nextval('arbo_placeau_lisieres_gid_seq'::regclass)

 

 

 

fid_placea

bigint

 

 

 

 

 

 

 

id

integer

 

 

 

 

 

 

 

secteur

varchar(10)

 

 

 

 

 

 

 

placeau

varchar(10)

 

 

 

 

 

 

 

surface

numeric

 

 

 

 

 

 

 

perimetre

numeric

 

 

 

 

 

 

 

geom

public.geometry

 

 

 

 

 

 

Foreign Keys

There are no foreign keys for table sig_placeau_lisieres

 

Check Constraints

There are no check constraints for table sig_placeau_lisieres

 

Indices

Name

Type

Function

Columns

Primary Key

Unique

Description

arbo_placeau_lisieres_geom_idx

gist

 

geom

 

 

 

arbo_placeau_lisieres_pkey

btree

 

gid

 

 

Triggers

There are no triggers for table sig_placeau_lisieres

 

Rules

There are no rules for table sig_placeau_lisieres

 

Policies

There are no policies for table sig_placeau_lisieres

 

Referenced

There are no tables referenced by table sig_placeau_lisieres

 

Properties

Property

Value

Inherited From

 

Rows

132

Pages

11

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE public.sig_placeau_lisieres (
 gid SERIAL,
 fid_placea BIGINT,
 id INTEGER,
 secteur VARCHAR(10),
 placeau VARCHAR(10),
 surface NUMERIC,
 perimetre NUMERIC,
 geom public.geometry,
 CONSTRAINT arbo_placeau_lisieres_pkey PRIMARY KEY(gid)
) ;

CREATE INDEX arbo_placeau_lisieres_geom_idx ON public.sig_placeau_lisieres
 USING gist (geom public.gist_geometry_ops_2d);

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