Feedback Edit

DiaryView Table (214)

Configuration of a multi-user diary view

Fields

Name	Description	Type	Null
DiaryView_id	Primary key	PK
assoc_id	Owning associate	FK associate
name	The name of the view (defined by the user during saving)	String(254)
rank	Sorting rank	UShort
tooltip	Tooltip shown in dropdown list	String(254)	●
visibleColumns	The number of columns to actually show in this view (as opposed to the number of columns defined)	UShort
extraInfo	Extra information, whatever it might be	String(254)
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
tzLocationId	Default timezone location for this view	FK TZLocation	●

DiaryView table relationship diagram

Indexes

Fields	Types	Description
DiaryView_id	PK	Clustered, Unique
assoc_id	FK	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
DiaryViewRow	Configuration of a multi-user diary view
TZLocation	Time zone location

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.