Constraints

2 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
sp_regions_node_id_fkey
sp_regions.node_id
nodes.id
Restrict delete
sp_points_node_id_fkey
sp_points.node_id
nodes.id
Restrict delete

Check Constraints

Table Constraint Name Constraint
sp_regions no_time_overlap ((NOT node_already_has_point_geometry_at_time((id)::bigint, node_id, time_start, time_end)))
sp_points no_time_overlap ((NOT node_already_has_point_geometry_at_time((id)::bigint, node_id, time_start, time_end)))