area table - SuperOffice

area Table (38)

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

Fields

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

area table relationship diagram

Indexes

Fields	Types	Description
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.

Related topics

area areauserinclusion table areauserassignment table satellite table help table Area Management

⌘I