uid

title

description

so.generated

keywords

so.date

so.topic

so.envir

table-areauserassignment

areauserassignment table

Link table indicating which users actually reside in this area.

true

database

areauserassignment

11.04.2021

reference

onsite

online

areauserassignment Table (40)

Fields

Name	Description	Type	Null
areauserassignment_id	Primary key	PK
area_id	Parent area id	FK area
associate_id	Id of associate assigned to this area	FK associate
registered	Registered when	UtcDateTime
registered_associate_id	Registered by whom	FK associate
updated	Last updated when	UtcDateTime
updated_associate_id	Last updated by whom	FK associate
updatedCount	Number of updates made to this record	UShort

[!includedetails]

Indexes

Fields	Types	Description
areauserassignment_id	PK	Unique
area_id	FK	Index
associate_id	FK	Clustered

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.