Constraints

70 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
conversion_map_chain_update_user_fkey
conversion_map_chain.update_user
user_profile.id
Restrict delete
conversion_map_chain_conversion_chain_id_fkey
conversion_map_chain.conversion_chain_id
conversion_chain.id
Restrict delete
conversion_map_chain_map_id_fkey
conversion_map_chain.map_id
map.id
Restrict delete
conversion_map_chain_create_user_fkey
conversion_map_chain.create_user
user_profile.id
Restrict delete
data_format_create_user_fkey
data_format.create_user
user_profile.id
Restrict delete
data_format_data_type_id_fkey
data_format.data_type_id
data_type.id
Restrict delete
data_format_update_user_fkey
data_format.update_user
user_profile.id
Restrict delete
conversion_source_data_id_fkey
conversion.source_data_id
data.id
Restrict delete
conversion_update_user_fkey
conversion.update_user
user_profile.id
Restrict delete
conversion_target_data_id_fkey
conversion.target_data_id
data.id
Restrict delete
conversion_create_user_fkey
conversion.create_user
user_profile.id
Restrict delete
conversion_target_dictionary_id_fkey
conversion.target_dictionary_id
dictionary.id
Restrict delete
conversion_source_dictionary_id_fkey
conversion.source_dictionary_id
dictionary.id
Restrict delete
conversion_map_id_fkey
conversion.map_id
map.id
Restrict delete
field_aggregate_field_id_fkey
field.aggregate_field_id
field.id
Restrict delete
field_data_type_id_fkey
field.data_type_id
data_type.id
Restrict delete
field_row_id_fkey
field.row_id
row.id
Restrict delete
field_aggregate_definition_id_fkey
field.aggregate_definition_id
aggregate_definition.id
Restrict delete
field_aggregate_row_id_fkey
field.aggregate_row_id
row.id
Restrict delete
function_definition_create_user_fkey
function_definition.create_user
user_profile.id
Restrict delete
function_definition_update_user_fkey
function_definition.update_user
user_profile.id
Restrict delete
mapping_function_create_user_fkey
mapping_function.create_user
user_profile.id
Restrict delete
mapping_function_update_user_fkey
mapping_function.update_user
user_profile.id
Restrict delete
mapping_function_function_definition_id_fkey
mapping_function.function_definition_id
function_definition.id
Restrict delete
mapping_function_mapping_id_fkey
mapping_function.mapping_id
mapping.id
Restrict delete
dynamic_field_data_type_id_fkey
dynamic_field.data_type_id
data_type.id
Restrict delete
dynamic_field_field_id_fkey
dynamic_field.field_id
field.id
Restrict delete
data_dictionary_id_fkey
data.dictionary_id
dictionary.id
Restrict delete
data_create_user_fkey
data.create_user
user_profile.id
Restrict delete
data_update_user_fkey
data.update_user
user_profile.id
Restrict delete
data_field_data_row_id_fkey
data_field.data_row_id
data_row.id
Restrict delete
data_field_data_type_id_fkey
data_field.data_type_id
data_type.id
Restrict delete
data_field_field_id_fkey
data_field.field_id
field.id
Restrict delete
data_field_update_user_fkey
data_field.update_user
user_profile.id
Restrict delete
data_field_dictionary_id_fkey
data_field.dictionary_id
dictionary.id
Restrict delete
data_field_create_user_fkey
data_field.create_user
user_profile.id
Restrict delete
user_profile_create_user_fkey
user_profile.create_user
user_profile.id
Restrict delete
user_profile_update_user_fkey
user_profile.update_user
user_profile.id
Restrict delete
user_profile_customer_id_fkey
user_profile.customer_id
customer.id
Restrict delete
dictionary_customer_id_fkey
dictionary.customer_id
customer.id
Restrict delete
dictionary_update_user_fkey
dictionary.update_user
user_profile.id
Restrict delete
dictionary_create_user_fkey
dictionary.create_user
user_profile.id
Restrict delete
data_row_create_user_fkey
data_row.create_user
user_profile.id
Restrict delete
data_row_row_id_fkey
data_row.row_id
row.id
Restrict delete
data_row_data_id_fkey
data_row.data_id
data.id
Restrict delete
data_row_update_user_fkey
data_row.update_user
user_profile.id
Restrict delete
customer_update_user_fkey
customer.update_user
user_profile.id
Restrict delete
customer_create_user_fkey
customer.create_user
user_profile.id
Restrict delete
conversion_chain_create_user_fkey
conversion_chain.create_user
user_profile.id
Restrict delete
conversion_chain_update_user_fkey
conversion_chain.update_user
user_profile.id
Restrict delete
mapping_map_id_fkey
mapping.map_id
map.id
Restrict delete
mapping_target_field_id_fkey
mapping.target_field_id
field.id
Restrict delete
mapping_create_user_fkey
mapping.create_user
user_profile.id
Restrict delete
mapping_update_user_fkey
mapping.update_user
user_profile.id
Restrict delete
mapping_source_field_id_fkey
mapping.source_field_id
field.id
Restrict delete
rule_field_id_fkey
rule.field_id
field.id
Restrict delete
rule_rule_definition_id_fkey
rule.rule_definition_id
rule_definition.id
Restrict delete
rule_error_level_id_fkey
rule.error_level_id
error_level.id
Restrict delete
row_dictionary_id_fkey
row.dictionary_id
dictionary.id
Restrict delete
row_create_user_fkey
row.create_user
user_profile.id
Restrict delete
row_parent_row_id_fkey
row.parent_row_id
row.id
Restrict delete
row_update_user_fkey
row.update_user
user_profile.id
Restrict delete
row_next_row_id_fkey
row.next_row_id
row.id
Restrict delete
map_customer_id_fkey
map.customer_id
customer.id
Restrict delete
map_source_dictionary_id_fkey
map.source_dictionary_id
dictionary.id
Restrict delete
map_update_user_fkey
map.update_user
user_profile.id
Restrict delete
map_target_dictionary_id_fkey
map.target_dictionary_id
dictionary.id
Restrict delete
map_create_user_fkey
map.create_user
user_profile.id
Restrict delete
data_type_create_user_fkey
data_type.create_user
user_profile.id
Restrict delete
data_type_update_user_fkey
data_type.update_user
user_profile.id
Restrict delete

Check Constraints

Table Constraint Name Constraint
None detected