Role table - SuperOffice

Role Table (191)

User roles for role-based security, names and tooltips are in LocaleText. For more information regarding role based security, see http;//techdoc.superoffice.com

Fields

Name	Description	Type	Nullable
Role_id	Primary key	PK	No
name	Visible role name	String(239)	Yes
rank	Sorting rank of this role in lists	UShort	No
tooltip	Visible tooltip	String(254)	Yes
deleted	1 if role has been deleted (we do not actually delete)	UShort	No
roleType	0 = employee, 1 = external user, 2 = anonymous	Enum RoleType	No
encryptedCheck	Encrypted data, to detect unwanted changes	String(254)	No
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No
use_categories	Override user categories with role categories	Bool	Yes

Role table relationship diagram

Indexes

Fields	Types	Description

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
DataRight	Data right definition
FunctionRightRoleLink	Functional right definition
role_category	Category membership associated with a role
role_element	Profiles associated with a role
role_workflow	Knowledge base workflow access rights associated with a role
text	Long text fields from all over the system
UserRoleLink	Link between user role and user

Replication Flags

Replicate changes DOWN from central to satellites and travellers.
Replicate changes UP from satellites and travellers back to central.
Copy to satellite and travel prototypes.

Security Flags

No access control via user’s Role.

Related topics

ej_role table StakeholderRole table role_category table role_element table role_member table role_workflow table

⌘I