Constraints

36 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

syst_access_accounts_owners_fk

syst_access_accounts.owning_owner_id

Cascade on delete

syst_access_accounts_access_account_states_fk

syst_access_accounts.access_account_state_id

syst_enum_items.id

Restrict delete

syst_enum_items_enum_fk

syst_enum_items.enum_id

Cascade on delete

syst_enum_items_enum_functional_type_fk

syst_enum_items.functional_type_id

syst_enum_functional_types.id

Restrict delete

syst_instance_contexts_instances_fk

syst_instance_contexts.instance_id

syst_instances.id

Cascade on delete

syst_instance_contexts_application_contexts_fk

syst_instance_contexts.application_context_id

syst_application_contexts.id

Cascade on delete

syst_owner_password_rules_owner_fk

syst_owner_password_rules.owner_id

Cascade on delete

syst_instances_applications_fk

syst_instances.application_id

syst_applications.id

Restrict delete

syst_instances_owners_fk

syst_instances.owner_id

Restrict delete

syst_instances_owning_instance_fk

syst_instances.owning_instance_id

syst_instances.id

Restrict delete

syst_instances_enum_instance_state_fk

syst_instances.instance_state_id

syst_enum_items.id

Restrict delete

syst_instances_enum_instance_type_fk

syst_instances.instance_type_id

syst_enum_items.id

Restrict delete

syst_instance_network_rules_instance_fk

syst_instance_network_rules.instance_id

syst_instances.id

Cascade on delete

syst_identities_access_accounts_fk

syst_identities.access_account_id

syst_access_accounts.id

Cascade on delete

syst_identities_identity_types_fk

syst_identities.identity_type_id

syst_enum_items.id

Cascade on delete

syst_identities_validates_identities_fk

syst_identities.validates_identity_id

syst_identities.id

Cascade on delete

syst_credentials_credential_types_fk

syst_credentials.credential_type_id

syst_enum_items.id

Restrict delete

syst_credentials_access_accounts_fk

syst_credentials.access_account_id

syst_access_accounts.id

Cascade on delete

syst_credentials_for_identities_fk

syst_credentials.credential_for_identity_id

syst_identities.id

Cascade on delete

syst_enum_functional_types_enum_fk

syst_enum_functional_types.enum_id

Cascade on delete

syst_perms_perm_functional_type_fk

syst_perms.perm_functional_type_id

syst_perm_functional_types.id

Restrict delete

syst_instance_type_contexts_inst_type_app_fk

syst_instance_type_contexts.instance_type_application_id

syst_instance_type_applications.id

Cascade on delete

syst_instance_type_contexts_application_contexts_fk

syst_instance_type_contexts.application_context_id

syst_application_contexts.id

Cascade on delete

syst_access_account_instance_assocs_instances_fk

syst_access_account_instance_assocs.instance_id

syst_instances.id

Cascade on delete

syst_access_account_instance_assocs_access_accounts_fk

syst_access_account_instance_assocs.access_account_id

syst_access_accounts.id

Cascade on delete

syst_perm_role_grants_perm_role_fk

syst_perm_role_grants.perm_role_id

syst_perm_roles.id

Cascade on delete

syst_perm_role_grants_perm_fk

syst_perm_role_grants.perm_id

Cascade on delete

syst_perm_roles_perm_functional_type_fk

syst_perm_roles.perm_functional_type_id

syst_perm_functional_types.id

Restrict delete

syst_access_account_perm_role_assigns_access_account_fk

syst_access_account_perm_role_assigns.access_account_id

syst_access_accounts.id

Cascade on delete

syst_access_account_perm_role_assigns_perm_role_fk

syst_access_account_perm_role_assigns.perm_role_id

syst_perm_roles.id

Cascade on delete

syst_owner_network_rules_owner_fk

syst_owner_network_rules.owner_id

Cascade on delete

syst_owner_owner_states_fk

syst_owners.owner_state_id

syst_enum_items.id

Restrict delete

syst_password_history_access_account_fk

syst_password_history.access_account_id

syst_access_accounts.id

Cascade on delete

syst_application_contexts_applications_fk

syst_application_contexts.application_id

syst_applications.id

Cascade on delete

syst_instance_type_applications_applications_fk

syst_instance_type_applications.application_id

syst_applications.id

Cascade on delete

syst_instance_type_applications_instance_types_fk

syst_instance_type_applications.instance_type_id

syst_enum_items.id

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint
syst_instance_contexts	syst_instance_contexts_db_pool_size_chk	((db_pool_size >= 0))
syst_instances	syst_instances_self_ownership_chk	(((owning_instance_id IS NULL) OR (owning_instance_id <> id)))
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_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_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)))