rbac_role_permissions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
role_id uuid 2147483647 null
rbac_roles.id rbac_role_permissions_role_id_fkey C
feature_key text 2147483647 null
rbac_feature_catalog.feature_key rbac_role_permissions_feature_key_fkey R
action text 2147483647 null
created_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
rbac_role_permissions_pkey Primary key Asc/Asc/Asc role_id + feature_key + action
rbac_role_permissions_feature_idx Performance Asc/Asc feature_key + action

Check Constraints

Constraint Name Constraint
rbac_role_permissions_action_check ((action = ANY (ARRAY['view'::text, 'create'::text, 'edit'::text, 'delete'::text, 'export'::text, 'manage'::text, 'assign'::text, 'refund'::text])))

Relationships

Close relationships within degrees of separation