4 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| syst_perms_perm_functional_type_fk |
|
|
Restrict 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 |
Check Constraints
| 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]))) |