• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

DiaryView Table (214)

Some tooltip text!
• 1 minute to read
 • 1 minute to read

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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top