areauserassignment table - SuperOffice

areauserassignment Table (40)

Link table indicating which users actually reside in this area.

Fields

Name	Description	Type	Nullable
areauserassignment_id	Primary key	PK	No
area_id	Parent area id	FK area	No
associate_id	Id of associate assigned to this area	FK associate	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

Indexes

Fields	Types	Description
area_id	FK	Index
associate_id	FK	Clustered

Relationships

Table	Description
area	Definition of an Area (database subset for satellite and travel)
associate	Employees, resources and other users - except for External persons

Replication Flags

Replicate changes DOWN from central to satellites and travellers.
Copy to satellite and travel prototypes.
Cache table during filtering.

Security Flags

No access control via user’s Role.

Related topics

area table Blocked tables list associate table extra_tables table ext_table table Database table listing

⌘I