role


Description

They way we group access to tasks whithin the system to users

Columns

Column Type Size Nulls Auto Default Children Parents Comments
idrole int4 10 null
mayauser.idrole FK_mayauser_role R
role_privilege.idrole FK_role_privilege_role R
vw_user.idrole Implied Constraint R
idclient int4 10 null
client.idclient FK_role_client R
name varchar 50 null
description varchar 100 √ null
createbyuser int4 10 null
creationdate timestamp 29,6 null
lastmodifiedbyuser int4 10 null
lastmodificationdate timestamp 29,6 null
originatingsystem varchar 50 null
enabled bool 1 true

Indexes

Constraint Name Type Sort Column(s)
PK_idrole Primary key Asc idrole
UQ_role_idrole Must be unique Asc idrole

Relationships

Close relationships within degrees of separation