TZLocation Table (245)
Time zone locationFields
| Name | Description | Type | Nullable |
|---|---|---|---|
| TZLocation_id | Primary key | PK | No |
| countryId | Country that this timezone location is defined for | FK country | No |
| locationCode | Code, such as CA-NT, identifying the timezone location in the imported data. Unique, NOT equal to the culture codes of Windows | String(29) | No |
| groupName | Group (heading) name for timezone locations that do not have a country (such as the EU zones) | String(254) | Yes |
| regionName | Name of region, such as Northwest Territories. Future localization via localeText resource type 31 | String(254) | No |
| cities | Cities, comma-separated list. Future localization via localeText resource type 32 | String(2047) | No |
| shortName | Short name, such as CET (Central European Time); future localization via localeText resource type 33 | String(254) | No |
| description | Dcescription, only visible in Admin contexts | String(254) | Yes |
| isBuiltIn | Is this row part of SuperOffice priming data | Bool | Yes |
| isActive | Is this field visible in the standard drop-down list in the GUI? If no, it can still be used and searched for, but won’t be visible directly in the dropdown list. | Bool | Yes |
| isDeleted | Is this row ‘deleted’ (invisible in lists) | Bool | 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 |
Indexes
| Fields | Types | Description |
|---|---|---|
| locationCode | String(29) | Unique |
Relationships
| Table | Description |
|---|---|
| appointment | Tasks, appointments, followups, phone calls; and documents (document_id != 0). An appointment always has a corresponding record in VisibleFor specifying who may see this. |
| associate | Employees, resources and other users - except for External persons |
| BaseTZLocation | Time zone location for the database (how tz-related datetimes should be stored in the database) |
| chat_topic | This table contains chat topics. |
| contact | Companies and Organizations. |
| country | Country information |
| DiaryView | Configuration of a multi-user diary view |
| person | Persons |
| project | Projects |
| TZDstRule | Time zone rule for daylight saving time |
| TZStdRule | Time zone rule for standard time |
| workflow | SuperOffice specific info about a workflow |
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.