45 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| syst_access_accounts_owners_fk |
|
|
Cascade on delete | ||
| syst_access_accounts_access_account_states_fk |
|
|
Restrict delete | ||
| syst_enum_items_enum_fk |
|
|
Cascade on delete | ||
| syst_enum_items_enum_functional_type_fk |
|
|
Restrict delete | ||
| syst_owner_password_rules_owner_fk |
|
|
Cascade on delete | ||
| syst_instances_applications_fk |
|
|
Restrict delete | ||
| syst_instances_owners_fk |
|
|
Restrict delete | ||
| syst_instances_owning_instance_fk |
|
|
Restrict delete | ||
| syst_instances_enum_instance_state_fk |
|
|
Restrict delete | ||
| syst_instances_enum_instance_type_fk |
|
|
Restrict delete | ||
| syst_instance_contexts_instances_fk |
|
|
Cascade on delete | ||
| syst_instance_contexts_application_contexts_fk |
|
|
Cascade on delete | ||
| syst_instance_network_rules_instance_fk |
|
|
Cascade on delete | ||
| syst_hierarchy_items_hierarchy_fk |
|
|
Cascade on delete | ||
| syst_identities_access_accounts_fk |
|
|
Cascade on delete | ||
| syst_identities_identity_types_fk |
|
|
Cascade on delete | ||
| syst_identities_validates_identities_fk |
|
|
Cascade on delete | ||
| syst_hierarchies_hierarchy_state_fk |
|
|
Restrict delete | ||
| syst_hierarchies_hierarchy_type_fk |
|
|
Cascade on delete | ||
| syst_credentials_credential_types_fk |
|
|
Restrict delete | ||
| syst_credentials_access_accounts_fk |
|
|
Cascade on delete | ||
| syst_credentials_for_identities_fk |
|
|
Cascade on delete | ||
| syst_enum_functional_types_enum_fk |
|
|
Cascade on delete | ||
| syst_actions_action_group_fk |
|
|
Restrict delete | ||
| syst_perms_perm_functional_type_fk |
|
|
Restrict delete | ||
| syst_instance_type_contexts_inst_type_app_fk |
|
|
Cascade on delete | ||
| syst_instance_type_contexts_application_contexts_fk |
|
|
Cascade on delete | ||
| syst_access_account_instance_assocs_instances_fk |
|
|
Cascade on delete | ||
| syst_access_account_instance_assocs_access_accounts_fk |
|
|
Cascade on delete | ||
| syst_perm_role_grants_perm_role_fk |
|
|
Cascade on delete | ||
| syst_perm_role_grants_perm_fk |
|
|
Cascade on delete | ||
| syst_perm_roles_perm_functional_type_fk |
|
|
Restrict delete | ||
| syst_access_account_perm_role_assigns_access_account_fk |
|
|
Cascade on delete | ||
| syst_access_account_perm_role_assigns_perm_role_fk |
|
|
Cascade on delete | ||
| syst_owner_network_rules_owner_fk |
|
|
Cascade on delete | ||
| syst_owner_owner_states_fk |
|
|
Restrict delete | ||
| syst_menu_items_submenu_menu_fk |
|
|
Restrict delete | ||
| syst_menu_items_parent_menu_item_fk |
|
|
Restrict delete | ||
| syst_menu_items_menu_fk |
|
|
Cascade on delete | ||
| syst_menu_items_action_fk |
|
|
Restrict delete | ||
| syst_password_history_access_account_fk |
|
|
Cascade on delete | ||
| syst_application_contexts_applications_fk |
|
|
Cascade on delete | ||
| syst_menus_menu_state_fk |
|
|
Restrict delete | ||
| syst_instance_type_applications_applications_fk |
|
|
Cascade on delete | ||
| syst_instance_type_applications_instance_types_fk |
|
|
Cascade on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| syst_instances | syst_instances_self_ownership_chk | (((owning_instance_id IS NULL) OR (owning_instance_id <> id))) |
| syst_instance_contexts | syst_instance_contexts_db_pool_size_chk | ((db_pool_size >= 0)) |
| syst_instance_network_rules | syst_instance_network_rules_functional_type_chk | ((functional_type = ANY (ARRAY['allow'::text, 'deny'::text]))) |
| syst_instance_network_rules | syst_instance_network_rules_host_or_range_chk | ((((ip_host_or_network IS NOT NULL) AND (ip_host_range_lower IS NULL) AND (ip_host_range_upper IS NULL)) OR ((ip_host_or_network IS NULL) AND (ip_host_range_lower IS NOT NULL) AND (ip_host_range_upper IS NOT NULL)))) |
| syst_instance_network_rules | syst_instance_network_rules_ip_range_family_chk | ((family(ip_host_range_lower) = family(ip_host_range_upper))) |
| syst_actions | syst_actions_command_validity_chk | ((((command IS NULL) AND (command_config IS NULL) AND (command_aliases IS NULL) AND (command_search IS NULL)) OR ((command IS NOT NULL) AND (command_config IS NOT NULL) AND (command_aliases IS NOT NULL) AND (command_search IS NOT NULL)))) |
| syst_perms | syst_perms_admin_scope_options_chk | (((cardinality(admin_scope_options) > 0) AND (admin_scope_options <@ ARRAY['unused'::text, 'deny'::text, 'same_user'::text, 'same_group'::text, 'all'::text]))) |
| syst_perms | syst_perms_maint_scope_options_chk | (((cardinality(maint_scope_options) > 0) AND (maint_scope_options <@ ARRAY['unused'::text, 'deny'::text, 'same_user'::text, 'same_group'::text, 'all'::text]))) |
| syst_perms | syst_perms_ops_scope_options_chk | (((cardinality(ops_scope_options) > 0) AND (ops_scope_options <@ ARRAY['unused'::text, 'deny'::text, 'same_user'::text, 'same_group'::text, 'all'::text]))) |
| syst_perms | syst_perms_view_scope_options_chk | (((cardinality(view_scope_options) > 0) AND (view_scope_options <@ ARRAY['unused'::text, 'deny'::text, 'same_user'::text, 'same_group'::text, 'all'::text]))) |
| syst_instance_type_contexts | syst_instance_type_contexts_default_db_pool_size_chk | ((default_db_pool_size >= 0)) |
| syst_action_groups | syst_action_groups_command_validity_chk | ((((command IS NULL) AND (command_config IS NULL) AND (command_aliases IS NULL) AND (command_search IS NULL)) OR ((command IS NOT NULL) AND (command_config IS NOT NULL) AND (command_aliases IS NOT NULL) AND (command_search IS NOT NULL)))) |
| syst_owner_network_rules | syst_owner_network_rules_functional_type_chk | ((functional_type = ANY (ARRAY['allow'::text, 'deny'::text]))) |
| syst_owner_network_rules | syst_owner_network_rules_host_or_range_chk | ((((ip_host_or_network IS NOT NULL) AND (ip_host_range_lower IS NULL) AND (ip_host_range_upper IS NULL)) OR ((ip_host_or_network IS NULL) AND (ip_host_range_lower IS NOT NULL) AND (ip_host_range_upper IS NOT NULL)))) |
| syst_owner_network_rules | syst_owner_network_rules_ip_range_family_chk | ((family(ip_host_range_lower) = family(ip_host_range_upper))) |
| syst_global_network_rules | syst_global_network_rules_functional_type_chk | ((functional_type = ANY (ARRAY['allow'::text, 'deny'::text]))) |
| syst_global_network_rules | syst_global_network_rules_host_or_range_chk | ((((ip_host_or_network IS NOT NULL) AND (ip_host_range_lower IS NULL) AND (ip_host_range_upper IS NULL)) OR ((ip_host_or_network IS NULL) AND (ip_host_range_lower IS NOT NULL) AND (ip_host_range_upper IS NOT NULL)))) |
| syst_global_network_rules | syst_global_network_rules_ip_range_family_chk | ((family(ip_host_range_lower) = family(ip_host_range_upper))) |