| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | Id | id | int | 11 | 0 | | | | Allow NULL? |
| 2 | TimeZone | time zone | nvarchar | 100 | 0 | | 1 | 10=(GMT-07:00) Arizona, 11=(GMT-06:00) Saskatchewan, 12=(GMT-06:00) Guadalajara, Mexico City, Monterrey - Old, 13=(GMT-06:00) Guadalajara, Mexico City, Monterrey - New, 14=(GMT-06:00) Central Time (US & Canada), 15=(GMT-06:00) Central America, 16=(GMT-05:00) Indiana (East), 17=(GMT-05:00) Eastern Time (US & Canada), 18=(GMT-05:00) Bogota, | Allow NULL? |
| 3 | Offset | offset from GMT/UTC time | int | 11 | 0 | | 1 | 10=-420, 11=-360, 12=-360, 13=-360, 14=-360, 15=-360, 16=-300, 17=-300, 18=-300, 19=-270, 1=-720, 20=-240, 21=-240, 22=-240, 23=-240, 24=-210, 25=-180, 26=-180, 27=-180, 28=-180, 29=-180, 2=-660, 30=-120, 31=-60, 32=-60, 33=0, 34=0, 35=0, 36=60, 37=60, 38=60, 39=60, 3=-600, 40=60, 41=120, 42=120, 43=120, 44=120, 45=120, 46=120, 47=120, 48= | Allow NULL? |
