uid	title	description	so.generated	keywords	so.topic	so.envir
table-area	area table	Definition of an Area (database subset for satellite and travel)	true	database table area	reference	onsite, online

area Table (38)

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

[!includedetails]

Fields	Types	Description
area_id	PK	Clustered, Unique
parent_area_id	FK	Index

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