privilege


Description

Task or functions that can be performed on the system by users with the appropriated role

Columns

Column Type Size Nulls Auto Default Children Parents Comments
idprivilege int4 10 null
client_extra_privilege.idprivilege fk_client_extra_privilege_idprivilege R
privilege_privilegegroup.idprivilege fk_privilege_privilegegroup_idprivilege R
role_privilege.idprivilege FK_role_privilege_privilege R
vw_privilegroup.idprivilege Implied Constraint R
name varchar 25 null
description varchar 200 null
enabled bool 1 true
screen_action varchar 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_idprivilege Primary key Asc idprivilege
UQ_privilege_idprivilege Must be unique Asc idprivilege

Relationships

Close relationships within degrees of separation