Constraints

17 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
series_fk_id_actor_fkey
series.fk_id_actor
actor.id
Restrict delete
series_fk_id_indicator_fkey
series.fk_id_indicator
indicator.id
Restrict delete
series_fk_id_spatial_layer_fkey
series.fk_id_spatial_layer
spatial_layer.id
Restrict delete
series_fk_id_protocol_fkey
series.fk_id_protocol
protocol.id
Restrict delete
actor_id_category_fkey
actor.id_category
actor_category.id
Restrict delete
project_view_fk_id_spatial_layer_fkey
project_view.fk_id_spatial_layer
spatial_layer.id
Null on delete
project_view_fk_id_project_fkey
project_view.fk_id_project
project.id
Cascade on delete
spatial_layer_fk_id_actor_fkey
spatial_layer.fk_id_actor
actor.id
Restrict delete
import_fk_id_series_fkey
import.fk_id_series
series.id
Restrict delete
observation_fk_id_series_fkey
observation.fk_id_series
series.id
Restrict delete
observation_fk_id_spatial_object_fkey
observation.fk_id_spatial_object
spatial_object.id
Restrict delete
observation_fk_id_import_fkey
observation.fk_id_import
import.id
Restrict delete
r_indicator_node_fk_id_indicator_fkey
r_indicator_node.fk_id_indicator
indicator.id
Cascade on delete
r_indicator_node_fk_id_node_fkey
r_indicator_node.fk_id_node
graph_node.id
Cascade on delete
spatial_object_fk_id_spatial_layer_fkey
spatial_object.fk_id_spatial_layer
spatial_layer.id
Restrict delete
dimension_fk_id_indicator_fkey
dimension.fk_id_indicator
indicator.id
Restrict delete
document_fk_id_indicator_fkey
document.fk_id_indicator
indicator.id
Restrict delete

Check Constraints

Table Constraint Name Constraint