Constraints

5 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
markers_road_code_fkey
markers.road_code
roads.road_code
Restrict delete
edges_road_code_fkey
edges.road_code
roads.road_code
Restrict delete
edges_start_node_fkey
edges.start_node
nodes.id
Restrict delete
edges_end_node_fkey
edges.end_node
nodes.id
Restrict delete
roads_road_scale_fkey
roads.road_class
glossary_road_class.code
Restrict delete

Check Constraints

Table Constraint Name Constraint
glossary_graph_check glossary_graph_check_severity_values (severity = ANY (ARRAY['error'::text, 'warning'::text]))
markers markers_abscissa_check_positive (abscissa >= (0)::double precision)
markers markers_code_check_positive (code >= 0)
roads roads_road_type_values (road_type = ANY (ARRAY['road'::text, 'roundabout'::text]))
managed_objects check_geometry_type (lower(geometry_type) = ANY (ARRAY['point'::text, 'linestring'::text, 'multilinestring'::text]))
managed_objects check_update_policy_on_graph_change (update_policy_on_graph_change = ANY (ARRAY['geometry'::text, 'references'::text]))