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

Check Constraints

 

Schema

Table

Check Constraint

Condition

Description

placeautopo

t_placeau_topo_tpla

check_topogeom_topo

((topo).topology_id = 2) AND ((topo).layer_id = 1) AND ((topo).type = 2)

 

public

sig_points_rover

enforce_dims_geom1

st_ndims(geom1) = 2

 

public

sig_points_rover

enforce_dims_geom2

st_ndims(geom2) = 2

 

public

sig_points_rover

enforce_dims_geom3

st_ndims(geom3) = 2

 

public

sig_points_rover

enforce_dims_geombarycentre

st_ndims(geombarycentre) = 2

 

public

sig_points_rover

enforce_geotype_geom1

(geometrytype(geom1) = 'POINT'::text) OR (geom1 IS NULL)

 

public

sig_points_rover

enforce_geotype_geom2

(geometrytype(geom2) = 'POINT'::text) OR (geom2 IS NULL)

 

public

sig_points_rover

enforce_geotype_geom3

(geometrytype(geom3) = 'POINT'::text) OR (geom3 IS NULL)

 

public

sig_points_rover

enforce_geotype_geombarycentre

(geometrytype(geombarycentre) = 'POINT'::text) OR (geombarycentre IS NULL)

 

public

sig_points_rover

enforce_srid_geom1

st_srid(geom1) = 4326

 

public

sig_points_rover

enforce_srid_geom2

st_srid(geom2) = 4326

 

public

sig_points_rover

enforce_srid_geom3

st_srid(geom3) = 4326

 

public

sig_points_rover

enforce_srid_geombarycentre

st_srid(geombarycentre) = 4326

 

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