Constraints

109 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
node_roles_node_type_id_fkey
node_roles.node_type_id
node_types.id
Restrict delete
step_inds_ind_id_fkey
step_inds.ind_id
inds.id
Restrict delete
step_inds_ref_id_fkey
step_inds.ref_id
refs.id
Restrict delete
step_inds_step_id_fkey
step_inds.step_id
steps.id
Cascade on delete
node_inds_ind_id_fkey
node_inds.ind_id
inds.id
Restrict delete
node_inds_ref_id_fkey
node_inds.ref_id
refs.id
Restrict delete
node_inds_node_id_fkey
node_inds.node_id
nodes.id
Restrict delete
flow_inds_flow_id_fkey
flow_inds.flow_id
flows.id
Cascade on delete
flow_inds_ref_id_fkey
flow_inds.ref_id
refs.id
Restrict delete
flow_inds_ind_id_fkey
flow_inds.ind_id
inds.id
Restrict delete
trader_labels_trader_id_fkey
trader_labels.trader_id
nodes.id
Cascade on delete
trader_labels_label_id_fkey
trader_labels.label_id
nodes.id
Cascade on delete
step_quals_qual_id_fkey
step_quals.qual_id
quals.id
Restrict delete
step_quals_step_id_fkey
step_quals.step_id
steps.id
Cascade on delete
step_quals_flow_id_fkey
step_quals.step_id
steps.id
Cascade on delete
step_quals_ref_id_fkey
step_quals.ref_id
refs.id
Restrict delete
quants_country_id_fkey
quants.country_id
nodes.id
Restrict delete
quants_com_id_fkey
quants.com_id
commodities.id
Restrict delete
flows_ref_id_fkey
flows.ref_id
refs.id
Restrict delete
flows_raw_id_fkey
flows.raw_id
commodities.id
Restrict delete
flows_com_eq_group_ref_id_fkey
flows.com_eq_group_id
commodity_equivalence_groups.id
Restrict delete
link_inds_link_id_fkey
link_inds.link_id
links.id
Cascade on delete
link_inds_ind_id_fkey
link_inds.ind_id
inds.id
Restrict delete
link_inds_ref_id_fkey
link_inds.ref_id
refs.id
Restrict delete
trader_aggregates_trader_id_fkey
trader_aggregates.trader_id
nodes.id
Cascade on delete
trader_aggregates_aggregate_id_fkey
trader_aggregates.aggregate_id
nodes.id
Cascade on delete
release_refs_ref_id_fkey
release_refs.ref_id
refs.id
Restrict delete
release_refs_release_id_fkey
release_refs.release_id
releases.id
Restrict delete
release_node_quals_release_id_fkey
release_node_quals.release_id
releases.id
Restrict delete
release_node_quals_context_id_fkey
release_node_quals.context_id
contexts.id
Restrict delete
release_node_quals_qual_id_fkey
release_node_quals.qual_id
quals.id
Restrict delete
flow_quants_quant_id_fkey
flow_quants.quant_id
quants.id
Restrict delete
flow_quants_ref_id_fkey
flow_quants.ref_id
refs.id
Restrict delete
flow_quants_flow_id_fkey
flow_quants.flow_id
flows.id
Cascade on delete
cost_refs_country_id_fkey
cost_refs.country_id
nodes.id
Restrict delete
commodity_names_com_id_fkey
commodity_names.com_id
commodities.id
Restrict delete
release_node_inds_ind_id_fkey
release_node_inds.ind_id
inds.id
Restrict delete
release_node_inds_release_id_fkey
release_node_inds.release_id
releases.id
Restrict delete
release_node_inds_context_id_fkey
release_node_inds.context_id
contexts.id
Restrict delete
reference_node_roles_node_role_id_fkey
reference_node_roles.node_role_id
node_roles.id
Restrict delete
reference_node_roles_ref_id_fkey
reference_node_roles.ref_id
refs.id
Restrict delete
flow_paths_node_id_fkey
flow_paths.node_id
nodes.id
Restrict delete
flow_paths_flow_id_fkey
flow_paths.flow_id
flows.id
Cascade on delete
release_node_quants_release_id_fkey
release_node_quants.release_id
releases.id
Restrict delete
release_node_quants_quant_id_fkey
release_node_quants.quant_id
quants.id
Restrict delete
release_node_quants_context_id_fkey
release_node_quants.context_id
contexts.id
Restrict delete
steps_com_eq_factor_id_fkey
steps.com_eq_factor_id
commodity_equivalence_factors.id
Restrict delete
steps_flow_id_fkey
steps.flow_id
flows.id
Cascade on delete
steps_com_id_fkey
steps.com_id
commodities.id
Restrict delete
main_id_fkey
release_nodes.main_id
nodes.id
Restrict delete
new_commodity_equivalence_factors_node_id_fkey
commodity_equivalence_factors.node_id
nodes.id
Restrict delete
new_commodity_equivalence_factors_ref_id_fkey
commodity_equivalence_factors.ref_id
commodity_equivalence_refs.id
Restrict delete
new_commodity_equivalence_factors_com_id_fkey
commodity_equivalence_factors.com_id
commodities.id
Restrict delete
node_quants_ref_id_fkey
node_quants.ref_id
refs.id
Restrict delete
node_quants_quant_id_fkey
node_quants.quant_id
quants.id
Restrict delete
node_quants_node_id_fkey
node_quants.node_id
nodes.id
Restrict delete
link_quals_ref_id_fkey
link_quals.ref_id
nodes.id
Restrict delete
link_quals_link_id_fkey
link_quals.link_id
links.id
Cascade on delete
link_quals_qual_id_fkey
link_quals.qual_id
quals.id
Restrict delete
links_ref_id_fkey
links.ref_id
refs.id
Restrict delete
links_com_id_fkey
links.raw_id
commodities.id
Restrict delete
links_link_type_id_fkey
links.link_type_id
link_types.id
Restrict delete
flow_quals_ref_id_fkey
flow_quals.ref_id
refs.id
Restrict delete
flow_quals_qual_id_fkey
flow_quals.qual_id
quals.id
Restrict delete
flow_quals_flow_id_fkey
flow_quals.flow_id
flows.id
Cascade on delete
node_id_fkey
node_names.node_id
nodes.id
Restrict delete
link_paths_node_id_fkey
link_paths.node_id
nodes.id
Restrict delete
link_paths_link_id_fkey
link_paths.link_id
links.id
Cascade on delete
commodity_equivalence_group_factors_com_eq_factor_id_fkey
commodity_equivalence_group_factors.com_eq_factor_id
commodity_equivalence_factors.id
Restrict delete
commodity_equivalence_group_factors_com_eq_group_ref_id_fkey
commodity_equivalence_group_factors.com_eq_group_id
commodity_equivalence_groups.id
Restrict delete
release_actor_node_inds_ind_id_fkey
release_actor_node_inds.ind_id
inds.id
Restrict delete
release_actor_node_inds_release_id_fkey
release_actor_node_inds.release_id
releases.id
Restrict delete
commodity_equivalence_groups_com_id_fkey
commodity_equivalence_groups.com_id
commodities.id
Restrict delete
inds_country_id_fkey
inds.country_id
nodes.id
Restrict delete
inds_com_id_fkey
inds.com_id
commodities.id
Restrict delete
step_refs_ref_id_fkey
step_refs.ref_id
refs.id
Restrict delete
step_refs_step_id_fkey
step_refs.step_id
steps.id
Cascade on delete
ref_id_fkey
ref_years.ref_id
refs.id
Restrict delete
country_levels_country_id_fkey
country_levels.country_id
nodes.id
Restrict delete
nodes_type_id_fkey
nodes.type_id
node_types.id
Restrict delete
commodity_code_values_com_id_fkey
commodity_code_values.com_id
commodities.id
Restrict delete
commodity_code_values_com_code_id_fkey
commodity_code_values.com_code_id
commodity_codes.id
Restrict delete
refs_country_id_fkey
refs.country_id
nodes.id
Restrict delete
refs_com_id_fkey
refs.com_id
commodities.id
Restrict delete
step_quants_step_id_fkey
step_quants.step_id
steps.id
Cascade on delete
step_quants_ref_id_fkey
step_quants.ref_id
refs.id
Restrict delete
step_quants_quant_id_fkey
step_quants.quant_id
quants.id
Restrict delete
link_quants_link_id_fkey
link_quants.link_id
links.id
Cascade on delete
link_quants_quant_id_fkey
link_quants.quant_id
quants.id
Restrict delete
link_quants_ref_id_fkey
link_quants.ref_id
refs.id
Restrict delete
release_actor_node_quals_release_id_fkey
release_actor_node_quals.release_id
releases.id
Restrict delete
release_actor_node_quals_qual_id_fkey
release_actor_node_quals.qual_id
quals.id
Restrict delete
node_id_fkey
node_code_values.node_id
nodes.id
Restrict delete
code_id_fkey
node_code_values.code_id
node_codes.id
Restrict delete
contexts_country_id_fkey
contexts.country_id
nodes.id
Restrict delete
contexts_com_id_fkey
contexts.com_id
commodities.id
Restrict delete
node_quals_qual_id_fkey
node_quals.qual_id
quals.id
Restrict delete
node_quals_ref_id_fkey
node_quals.ref_id
refs.id
Restrict delete
node_quals_node_id_fkey
node_quals.node_id
nodes.id
Restrict delete
costs_ref_id_fkey
costs.ref_id
cost_refs.id
Restrict delete
costs_dest_id_fkey
costs.dest_id
nodes.id
Restrict delete
costs_orig_id_fkey
costs.orig_id
nodes.id
Restrict delete
quals_country_id_fkey
quals.country_id
nodes.id
Restrict delete
quals_com_id_fkey
quals.com_id
commodities.id
Restrict delete
commodities_parent_id_fkey
commodities.parent_id
commodities.id
Restrict delete
release_actor_node_quants_release_id_fkey
release_actor_node_quants.release_id
releases.id
Restrict delete
release_actor_node_quants_quant_id_fkey
release_actor_node_quants.quant_id
quants.id
Restrict delete
trader_countries_country_id_fkey
trader_countries.country_id
nodes.id
Restrict delete
trader_countries_trader_id_fkey
trader_countries.trader_id
nodes.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint
None detected