pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr |
|
Table: essaimcp
pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr |
|
Table: essaimcp
Schema
Owner
morellet
Tablespace
(default)
Descriptions
There is no description for table essaimcp
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
gid |
serial |
|
|
|
nextval('"analyse".essaimcp_gid_seq'::regclass) |
|
|
|
id |
varchar(80) |
|
|
|
|
|
|
|
area |
numeric |
|
|
|
|
|
|
|
geom |
public.geometry |
|
|
|
|
|
|
|
surface |
numeric |
|
|
|
|
|
|
|
ani_etiq |
char(16) |
|
|
|
|
|
|
|
annee |
integer |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table essaimcp
Check Constraints
There are no check constraints for table essaimcp
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
gist |
|
geom |
|
|
|
|
btree |
|
gid |
|
|
|
Triggers
There are no triggers for table essaimcp
Rules
There are no rules for table essaimcp
Policies
There are no policies for table essaimcp
Referenced
There are no tables referenced by table essaimcp
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
117 |
Pages |
11 |
System |
|
Temporary |
|
With OID |
|
Definition
gid SERIAL,
id VARCHAR(80),
area NUMERIC,
geom public.geometry,
surface NUMERIC,
ani_etiq CHAR(16),
annee INTEGER,
CONSTRAINT essaimcp_pkey PRIMARY KEY(gid)
)
WITH (oids = false);
CREATE INDEX essaimcp_geom_idx ON "analyse".essaimcp
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 |
|