Schema
Owner
postgres
Tablespace
(default)
Descriptions
There is no description for table Fosses
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
id_fosse_perma |
serial |
|
nextval('"Fosses_permanentes_id_fosse_perma_seq"'::regclass) |
|
|||
|
|
geom |
public.geometry |
|
|
|
|
|
|
|
id |
bigint |
|
|
|
|
|
|
|
nom fosse |
varchar(10) |
|
|
|
|
|
|
|
bloc |
integer |
|
|
|
|
|
|
|
system |
varchar(2) |
|
|
|
|
|
|
|
traitement |
varchar(2) |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table Fosses
Check Constraints
There are no check constraints for table Fosses
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
id_fosse_perma |
|
|||
gist |
|
geom |
|
|
|
Triggers
There are no triggers for table Fosses
Rules
There are no rules for table Fosses
Policies
There are no policies for table Fosses
Referenced
There are no tables referenced by table Fosses
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
19 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public."Fosses" (
id_fosse_perma SERIAL,
geom public.geometry,
id BIGINT,
"nom fosse" VARCHAR(10),
bloc INTEGER,
system VARCHAR(2),
traitement VARCHAR(2),
CONSTRAINT "Fosses_permanentes_pkey" PRIMARY KEY(id_fosse_perma)
) ;
CREATE INDEX "sidx_Fosses_permanentes_geom" ON public."Fosses"
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 |