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

area Table (38)

Some tooltip text!
• 2 minutes to read
 • 2 minutes to read

Definition of an Area (database subset for satellite and travel)

Fields

Name Description Type Null
area_id Primary key PK
name Area name String(49) ●
parent_area_id Reserved/not implemented: for subareas, travel from satellite, maybe future multi-level satellites FK area ●
allData if set to 1, means 'no filtering' UShort ●
dbType 0 = as in preferences, 1 = Sybase Anywhere, 2 = Ctree; used when generating prototypes UShort ●
filterType Area filtering algorithm - reserved for future use UShort ●
encryptedComm Use encryption for this Area? UShort ●
maxDataAge Max age of data when generating db's based on this area UShort ●
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

area table relationship diagram

Indexes

Fields Types Description
area_id PK Clustered, Unique
parent_area_id FK Index

Relationships

Table Description
area Definition of an Area (database subset for satellite and travel)
areauserassignment Link table indicating which users actually reside in this area.
areauserinclusion Link table incidated whose data should be included in this area. If Include all data in Area (no filtering) is ticket then there will be no rows for this area in this table.
associate Employees, resources and other users - except for External persons
satellite Definition of Satellites

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