UserRoleLink table - SuperOffice

UserRoleLink Table (192)

Link between user role and user

Fields

Name	Description	Type	Nullable
UserRoleLink_id	Primary key	PK	No
associate_id	Link to associate	FK associate	No
role_id	Link to Role	FK Role	No
linkType	Reserved for future extension, not used	UInt	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

UserRoleLink table relationship diagram

Indexes

Fields	Types	Description

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
Role	User roles for role-based security, names and tooltips are in LocaleText. For more information regarding role based security, see http://techdoc.superoffice.com

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

Sentry controls access to items in this table using user’s Role and data rights matrix on the table’s parent.

Related topics

StakeholderRoleGroupLink table FunctionRightRoleLink table StakeholderRoleHeadingLink table UserGroupLink table Role table Protected tables

⌘I