dbo.DialogTimeZone
Time zones
TableType TUsage CONFIGURATIONRows 655SizeMB 0.544
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DialogTimeZone | varchar(38) | no | Time zone | PKUID |
Ident_DialogTimeZone | nvarchar(128) | yes | Time zone | |
Commentary | nvarchar(128) | yes | Comment | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
UTCOffset | int(4) | yes | UTC offset | |
ShortName | nvarchar(16) | yes | Short name | |
IsDayLightSaving | bit(1) | yes | Daylight saving time | |
CurrentUTCOffset | int(4) | yes | UTC offset (current) | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
UID_TimeZoneMS | varchar(38) | yes | Time zone (MS) | FKUID |
Relations
| FK | From | To |
|---|---|---|
| QBM_RFRL274 | DialogCountryHasTimeZone.UID_DialogTimeZone | DialogTimeZone.UID_DialogTimeZone |
| QBM_RFRL296 | DialogStateHasTimeZone.UID_DialogTimeZone | DialogTimeZone.UID_DialogTimeZone |
| QBM_RFRL316 | DialogSchedule.UID_DialogTimeZone | DialogTimeZone.UID_DialogTimeZone |
Triggers
GEN_T1A4D01EF9FFC711286C936EE4 SQL_TRIGGER
GEN_T2FE27891B7AC34E0E0A68EF54 SQL_TRIGGER
GEN_T3D625EB238F772F152EAEFCB4 SQL_TRIGGER
GEN_T4D887AB9622B499E5367F82CF SQL_TRIGGER
GEN_T69DB1179743A4B604D92EC157 SQL_TRIGGER
QBM_TUDialogTimeZone SQL_TRIGGER
Referenced by / reverse relations
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
| Referencing object | Relation | Evidence |
|---|---|---|
| dbo.QBM_FGITimeZoneIdentifier | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_PScheduleCheck | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZCountryUTCOffset | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZStateUTCOffset | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1603BDFF9396E4E301A6A5255 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1A4D01EF9FFC711286C936EE4 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1E6D3A01CEB12EADF4972D884 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T20C3366B9D322CD1C80FCEDAF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T236F0F75AB9F7309F1342269A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2FE27891B7AC34E0E0A68EF54 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3D625EB238F772F152EAEFCB4 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TIDialogSchedule | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TUDialogSchedule | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TUDialogTimeZone | SQL expression dependency | OBJECT_OR_COLUMN |
| DialogCountryHasTimeZone | foreign key references table | QBM_RFRL274: DialogCountryHasTimeZone.UID_DialogTimeZone -> DialogTimeZone.UID_DialogTimeZone |
| DialogStateHasTimeZone | foreign key references table | QBM_RFRL296: DialogStateHasTimeZone.UID_DialogTimeZone -> DialogTimeZone.UID_DialogTimeZone |
| DialogSchedule | foreign key references table | QBM_RFRL316: DialogSchedule.UID_DialogTimeZone -> DialogTimeZone.UID_DialogTimeZone |
| dbo.QBM_FGITimeZoneIdentifier | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_PScheduleCheck | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZCountryUTCOffset | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZStateUTCOffset | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QBM_TIDialogSchedule | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TUDialogSchedule | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TUDialogTimeZone | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |