> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# BaseTZLocation table

> Time zone location for the database (how tz-related datetimes should be stored in the database)

## BaseTZLocation Table (248)

Time zone location for the database (how tz-related datetimes should be stored in the database)

## Fields

| Name                      | Description                                                                                       | Type                              | Nullable |
| ------------------------- | ------------------------------------------------------------------------------------------------- | --------------------------------- | :------: |
| BaseTZLocation\_id        | Primary key                                                                                       | PK                                |    No    |
| TZLocation\_id            | Country that this timezone location is defined for                                                | FK [TZLocation](./tzlocation.mdx) |    No    |
| validFrom                 | When is this tzLocation valid from, as THE database timezonelocation                              | DateTime                          |    No    |
| databaseId                | Actually travelcurrent.current\_id, the id of the database this basetimezonelocation is meant for | Id                                |    No    |
| description               | Descriptive text                                                                                  | String(254)                       |    No    |
| registered                | Registered when                                                                                   | UtcDateTime                       |    No    |
| registered\_associate\_id | Registered by whom                                                                                | FK [associate](./associate.mdx)   |    No    |
| updated                   | Last updated when                                                                                 | UtcDateTime                       |    No    |
| updated\_associate\_id    | Last updated by whom                                                                              | FK [associate](./associate.mdx)   |    No    |
| updatedCount              | Number of updates made to this record                                                             | UShort                            |    No    |

<img src="https://mintcdn.com/superofficeas/-KbDeS3ObOMH8eFq/media/loc/en/database/tables/BaseTZLocation.png?fit=max&auto=format&n=-KbDeS3ObOMH8eFq&q=85&s=680553bf9344f81ec08e7e0c3621ea04" alt="BaseTZLocation table relationship diagram" width="698" height="59" data-path="media/loc/en/database/tables/BaseTZLocation.png" />

## Indexes

| Fields | Types | Description |
| ------ | ----- | ----------- |

## Relationships

| Table                      | Description                                                        |
| -------------------------- | ------------------------------------------------------------------ |
| [associate](./associate)   | Employees, resources and other users - except for External persons |
| [TZLocation](./tzlocation) | Time zone location                                                 |

## 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.


## Related topics

- [TZLocation table](/en/database/tables/tzlocation.md)
- [chat_topic table](/en/database/tables/chat-topic.md)
- [attachment_location table](/en/database/tables/attachment-location.md)
- [Attachment location](/en/onsite/config/service/attachment-location.md)
- [location](/en/api/mdo-providers/reference/location.md)
- [Get Base Time Zone](/en/api/reference/restful/rest/timezone/get-base-time-zone.md)