Time Zone
FILEPATH: /d:/Projects/1bytesoftware/sql/table-scripts/JFW.TimeZone.Table.sql
Description:
This script creates a table named `[JFW]`.[TimeZone] in the `[JFW_live]` database. The table stores information about time zones, including the country code, name, value, description, identifier, and audit fields.
Table Structure:
- `[ID]`: bigint (Primary Key, Auto-increment)
- `[Country_Code]`: varchar(2)
- `[Name]`: nvarchar(250)
- `[Value]`: nvarchar(250)
- `[Description]`: nvarchar(500)
- `[Identifier]`: varchar(50)
- `[Modified_By]`: bigint
- `[Modified_Date]`: datetime
- `[Created_By]`: bigint
- `[Created_Date]`: datetime
Usage:
- This table can be used to store and retrieve information about time zones.
Dependencies:
- Database: `[JFW_live]`
Last updated
Was this helpful?