dbo.DialogCountry
Countries
TableType TUsage CONFIGURATIONRows 251SizeMB 0.296
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DialogCountry | varchar(38) | no | Country | PKUID |
NumericCode | nvarchar(6) | yes | ISO ID numeric | |
Iso3166_2 | nvarchar(4) | yes | ISO ID (2-letter) | |
Iso3166_3 | nvarchar(6) | yes | ISO ID (3-letter) | |
CountryName | nvarchar(128) | yes | Country name | |
Description | nvarchar(128) | yes | Description | |
LDAPObjectClass | nvarchar(512) | yes | Object class | |
LDAPSearchGuide | nvarchar(512) | yes | Search form | |
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 | |
IsInUse | bit(1) | yes | Enabled | |
Car | nvarchar(32) | yes | International vehicle reg. ID | |
Telephone | nvarchar(32) | yes | Country code | |
AVGUTCOffset | int(4) | yes | UTC offset (average) | |
DefaultWorkingHours | varchar(168) | yes | Hours (default) | |
IsDayLightSaving | bit(1) | yes | Daylight saving time | |
NationalCountryName | nvarchar(128) | yes | Country name (national language) | |
CapitalName | nvarchar(128) | yes | Capital | |
NationalCapitalName | nvarchar(128) | yes | Capital city (national language) | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
IsHistorical | bit(1) | yes | Historic |
Relations
| FK | From | To |
|---|---|---|
| ADS_RFRL2360 | ADSAccount.UID_ADSCountryCode | DialogCountry.UID_DialogCountry |
| ADS_RFRL2560 | ADSContact.UID_ADSCountryCode | DialogCountry.UID_DialogCountry |
| ADS_RFRL4359 | ADSContainer.UID_ADSCountryCode | DialogCountry.UID_DialogCountry |
| LDP_RFRL4362 | LDAPAccount.UID_LDAPCountryCode | DialogCountry.UID_DialogCountry |
| QBM_RFRL273 | DialogCountryHasTimeZone.UID_DialogCountry | DialogCountry.UID_DialogCountry |
| QBM_RFRL293 | DialogCountryHoliday.UID_DialogCountry | DialogCountry.UID_DialogCountry |
| QBM_RFRL294 | DialogState.UID_DialogCountry | DialogCountry.UID_DialogCountry |
| QBM_RFRL299 | DialogCountryHasCulture.UID_DialogCountry | DialogCountry.UID_DialogCountry |
| QBM_RFRL500 | DialogDatabase.UID_DialogCountryDefault | DialogCountry.UID_DialogCountry |
| QER_RFRL1987 | Person.UID_DialogCountry | DialogCountry.UID_DialogCountry |
| QER_RFRL1989 | BaseTree.UID_DialogCountry | DialogCountry.UID_DialogCountry |
| QER_RFRL1996 | FirmPartner.UID_DialogCountry | DialogCountry.UID_DialogCountry |
| QER_RFRL4361 | Hardware.UID_ADSCountryCode | DialogCountry.UID_DialogCountry |
Triggers
GEN_T2F653F8043391C3ABD8437DF6 SQL_TRIGGER
GEN_T3E02A0A59746B9D470F6EA6A6 SQL_TRIGGER
GEN_T43B4948EB3FB7AC1300AE8D4F SQL_TRIGGER
GEN_T5276DF6B0D13B4EEBDF8AD143 SQL_TRIGGER
GEN_T6D5B80B2FE67FE603C2023030 SQL_TRIGGER
QBM_TUDialogCountry 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_FCVDatetimeToNextWork | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_FGIHolidayInAdminUnit | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_FGIAdminUnitForPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FGITimeZoneForPerson | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_FGITimeZoneForPerson | SQL expression dependency | dbo · UID_DialogCountry · OBJECT_OR_COLUMN |
| dbo.QBM_ZCountryUTCOffset | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZStateUTCOffset2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1603BDFF9396E4E301A6A5255 | 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_T5276DF6B0D13B4EEBDF8AD143 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TUDialogCountry | SQL expression dependency | OBJECT_OR_COLUMN |
| ADSAccount | foreign key references table | ADS_RFRL2360: ADSAccount.UID_ADSCountryCode -> DialogCountry.UID_DialogCountry |
| ADSContact | foreign key references table | ADS_RFRL2560: ADSContact.UID_ADSCountryCode -> DialogCountry.UID_DialogCountry |
| ADSContainer | foreign key references table | ADS_RFRL4359: ADSContainer.UID_ADSCountryCode -> DialogCountry.UID_DialogCountry |
| LDAPAccount | foreign key references table | LDP_RFRL4362: LDAPAccount.UID_LDAPCountryCode -> DialogCountry.UID_DialogCountry |
| DialogCountryHasTimeZone | foreign key references table | QBM_RFRL273: DialogCountryHasTimeZone.UID_DialogCountry -> DialogCountry.UID_DialogCountry |
| DialogCountryHoliday | foreign key references table | QBM_RFRL293: DialogCountryHoliday.UID_DialogCountry -> DialogCountry.UID_DialogCountry |
| DialogState | foreign key references table | QBM_RFRL294: DialogState.UID_DialogCountry -> DialogCountry.UID_DialogCountry |
| DialogCountryHasCulture | foreign key references table | QBM_RFRL299: DialogCountryHasCulture.UID_DialogCountry -> DialogCountry.UID_DialogCountry |
| DialogDatabase | foreign key references table | QBM_RFRL500: DialogDatabase.UID_DialogCountryDefault -> DialogCountry.UID_DialogCountry |
| Person | foreign key references table | QER_RFRL1987: Person.UID_DialogCountry -> DialogCountry.UID_DialogCountry |
| BaseTree | foreign key references table | QER_RFRL1989: BaseTree.UID_DialogCountry -> DialogCountry.UID_DialogCountry |
| FirmPartner | foreign key references table | QER_RFRL1996: FirmPartner.UID_DialogCountry -> DialogCountry.UID_DialogCountry |
| Hardware | foreign key references table | QER_RFRL4361: Hardware.UID_ADSCountryCode -> DialogCountry.UID_DialogCountry |
| dbo.QBM_FCVDatetimeToNextWork | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_FGIHolidayInAdminUnit | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QER_FGIAdminUnitForPerson | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QER_FGITimeZoneForPerson | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_ZCountryUTCOffset | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZStateUTCOffset2 | source text reference | has TRY/CATCH error handling |
| dbo.QBM_TUDialogCountry | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-qbm-forms-vi-common-forms-frmdialogrichmailstammdaten.cs | decompiled C# reference | classes FrmDialogRichMailStammdaten; methods OnInit, OnDispose, OnDesignChanged, InitializeComponent, OnFormLoad, OnFormSizeChanged; references DialogCountry, DialogCountryHasCulture, DialogParameter, DialogParameterSet, DialogReport, DialogRichMail; markers reads entity values, references DB/Dialog objects |