mscmp_syst_perms.ms_syst

Search:

Constraint Name

Child Column

Parent Column

Delete Rule

syst_perm_role_grants_perm_fk

Cascade on delete

syst_perm_role_grants_perm_role_fk

Cascade on delete

syst_perm_roles_perm_functional_type_fk

syst_perm_roles.perm_functional_type_id

Restrict delete

syst_perms_perm_functional_type_fk

syst_perms.perm_functional_type_id

Restrict delete

Showing 1 to 4 of 4 entries

Search:

Table	Constraint Name	Constraint
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])))

Showing 1 to 4 of 4 entries