UserGroupLink table - SuperOffice

UserGroupLink Table (60)

Link table between associate and usergroup, specifies secondary group membership. From SIX an associate may belong to more than one usergroup. Http;//techdoc.superoffice.com has more information about how roles are implemented.

Fields

Name	Description	Type	Nullable
UserGroupLink_id	Primary key	PK	No
assoc_id	Link to associate	FK associate	No
UserGroup_id	Link to group	FK UserGroup	No
remark	Comment on why the assoc is linked to the group	String(254)	Yes
validFrom	When the membership becomes valid	DateTime	Yes
validTo	Last datetime this membership is valid	DateTime	Yes
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
encryptedCheck	Encrypted data, to detect unwanted changes	String(254)	Yes

UserGroupLink table relationship diagram

Indexes

Fields	Types	Description
assoc_id	FK	Index
UserGroup_id	FK	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
UserGroup	Secondary user groups

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

Lists UserGroup table UDListGroupLink table CategoryGroupLink table BusinessGroupLink table CurrencyGroupLink table

⌘I