pggeodb.nancy.inrae.fr/db_arboretum |
|
Table: sig_points_rover
pggeodb.nancy.inrae.fr/db_arboretum |
|
Table: sig_points_rover
Schema
Owner
albenard
Tablespace
(default)
Descriptions
There is no description for table sig_points_rover
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
rover_id |
serial |
|
|
|
nextval('sig_points_rover_rover_id_seq'::regclass) |
|
|
|
submissiondate |
varchar(40) |
|
|
|
|
|
|
|
lat1 |
real |
|
|
|
|
|
|
|
long1 |
real |
|
|
|
|
|
|
|
lat2 |
real |
|
|
|
|
|
|
|
long2 |
real |
|
|
|
|
|
|
|
lat3 |
real |
|
|
|
|
|
|
|
long3 |
real |
|
|
|
|
|
|
|
geom1 |
public.geometry |
|
|
|
|
|
|
|
geom2 |
public.geometry |
|
|
|
|
|
|
|
geom3 |
public.geometry |
|
|
|
|
|
|
|
repere_point |
varchar(128) |
|
|
|
|
|
|
|
commentaire |
varchar(128) |
|
|
|
|
|
|
|
geombarycentre |
public.geometry |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table sig_points_rover
Check Constraints
Name | Condition | Description |
|---|---|---|
st_ndims(geom1) = 2 |
|
|
st_ndims(geom2) = 2 |
|
|
st_ndims(geom3) = 2 |
|
|
st_ndims(geombarycentre) = 2 |
|
|
(geometrytype(geom1) = 'POINT'::text) OR (geom1 IS NULL) |
|
|
(geometrytype(geom2) = 'POINT'::text) OR (geom2 IS NULL) |
|
|
(geometrytype(geom3) = 'POINT'::text) OR (geom3 IS NULL) |
|
|
(geometrytype(geombarycentre) = 'POINT'::text) OR (geombarycentre IS NULL) |
|
|
st_srid(geom1) = 4326 |
|
|
st_srid(geom2) = 4326 |
|
|
st_srid(geom3) = 4326 |
|
|
st_srid(geombarycentre) = 4326 |
|
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
rover_id |
|
|
|
Triggers
There are no triggers for table sig_points_rover
Rules
There are no rules for table sig_points_rover
Policies
There are no policies for table sig_points_rover
Referenced
There are no tables referenced by table sig_points_rover
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
21 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
|
Definition
rover_id SERIAL,
submissiondate VARCHAR(40),
lat1 REAL,
long1 REAL,
lat2 REAL,
long2 REAL,
lat3 REAL,
long3 REAL,
geom1 public.geometry,
geom2 public.geometry,
geom3 public.geometry,
repere_point VARCHAR(128),
commentaire VARCHAR(128),
geombarycentre public.geometry,
CONSTRAINT sig_points_rover_pkey PRIMARY KEY(rover_id),
CONSTRAINT enforce_dims_geom1 CHECK (st_ndims(geom1) = 2),
CONSTRAINT enforce_dims_geom2 CHECK (st_ndims(geom2) = 2),
CONSTRAINT enforce_dims_geom3 CHECK (st_ndims(geom3) = 2),
CONSTRAINT enforce_dims_geombarycentre CHECK (st_ndims(geombarycentre) = 2),
CONSTRAINT enforce_geotype_geom1 CHECK ((geometrytype(geom1) = 'POINT'::text) OR (geom1 IS NULL)),
CONSTRAINT enforce_geotype_geom2 CHECK ((geometrytype(geom2) = 'POINT'::text) OR (geom2 IS NULL)),
CONSTRAINT enforce_geotype_geom3 CHECK ((geometrytype(geom3) = 'POINT'::text) OR (geom3 IS NULL)),
CONSTRAINT enforce_geotype_geombarycentre CHECK ((geometrytype(geombarycentre) = 'POINT'::text) OR (geombarycentre IS NULL)),
CONSTRAINT enforce_srid_geom1 CHECK (st_srid(geom1) = 4326),
CONSTRAINT enforce_srid_geom2 CHECK (st_srid(geom2) = 4326),
CONSTRAINT enforce_srid_geom3 CHECK (st_srid(geom3) = 4326),
CONSTRAINT enforce_srid_geombarycentre CHECK (st_srid(geombarycentre) = 4326)
) ;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|