area Table (38)
•
Environment: onsite, online
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 |
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.