dbo.DialogDatabase
Databases
TableType TUsage CONFIGURATIONRows 1SizeMB 0.048
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_Database | varchar(38) | no | Database | PKUID |
LastMigrationDate | datetime(8) | yes | Last compiler relevant configuration date | |
CustomerPrefix | nvarchar(12) | yes | Customer prefix | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
IsDBSchedulerDisabled | bit(1) | yes | Stop DBQueue Processor | |
IsJobServiceDisabled | bit(1) | yes | Stop %Globals.QIM_ProductNameShort% Service | |
DataOrigin | int(4) | yes | Database ID | |
FESimulationStarted | datetime(8) | yes | Simulation started | |
Description | nvarchar(510) | no | Description | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
IsMainDatabase | bit(1) | yes | Main database | |
UID_DialogAuthentifier | varchar(38) | yes | Authentication module | FKUID |
PublicKey | varchar(671) | yes | Public key for encryption | |
ConnectionProvider | nvarchar(510) | yes | Provider | |
CustomerName | nvarchar(512) | yes | Customer | |
XUserInserted | nvarchar(128) | yes | Created by | |
ConnectionString | nvarchar(-1) | yes | Connection parameter | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
UID_DialogCultureDefault | varchar(38) | yes | Language culture (default) | FKUID |
ModuleOwner | varchar(3) | yes | Module owner | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
ElementColor | nvarchar(32) | yes | Status bar color | |
ProductionLevel | int(4) | yes | Staging level | limited |
SingleUserProcess | int(4) | yes | Single-user mode required | |
SingleUserStart | datetime(8) | yes | Single-user mode start time | |
EditionName | varchar(3) | yes | Edition | |
EditionVersion | nvarchar(128) | yes | Edition version | |
EditionDescription | nvarchar(-1) | yes | Edition description | |
ProductionLevelAddOn | varchar(16) | yes | Custom staging level | |
LicenceID | varchar(16) | yes | Customer ID | |
UpdatePhase | int(4) | yes | Migration preparation phase | limited |
UID_DialogCountryDefault | varchar(38) | yes | Country (default) | FKUID |
UID_CutOffTask | varchar(38) | yes | DBQueue Processor task | UID |
UID_SingleUserSession | varchar(38) | yes | Single-user session | UID |
Relations
| FK | From | To |
|---|---|---|
| QBM_RFRL168 | DialogDatabase.UID_DialogAuthentifier | DialogAuthentifier.UID_DialogAuthentifier |
| QBM_RFRL342 | DialogDatabase.UID_DialogCultureDefault | QBMCulture.UID_DialogCulture |
| QBM_RFRL500 | DialogDatabase.UID_DialogCountryDefault | DialogCountry.UID_DialogCountry |
Triggers
GEN_T24D342ABDFAB55D3F78A630CB SQL_TRIGGER
GEN_T42AFB8F3F173113E2863AC894 SQL_TRIGGER
GEN_T56AB24A1A231874C43527FD35 SQL_TRIGGER
GEN_T604CCAFDF4769AAF98BD7F97C SQL_TRIGGER
QBM_TUDialogDatabase SQL_TRIGGER
QBM_TUIndicator474488 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_FTJobCreateDBParameter | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_FTJobCreateDBParameter | SQL expression dependency | dbo · IsMainDatabase · OBJECT_OR_COLUMN |
| dbo.QBM_FTJobCreateDBParameter | SQL expression dependency | dbo · ConnectionProvider · OBJECT_OR_COLUMN |
| dbo.QBM_FTJobCreateDBParameter | SQL expression dependency | dbo · ConnectionString · OBJECT_OR_COLUMN |
| dbo.QBM_FCVDatetimeToNextWork | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_FGICutOffTaskExists | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_FGIDBOwner | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_FGIDBQueueActivityDisabled | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_FGIDBQueueActivityDisabled | SQL expression dependency | dbo · IsDBSchedulerDisabled · OBJECT_OR_COLUMN |
| dbo.QBM_FGIDBQueueActivityDisabled | SQL expression dependency | dbo · IsMainDatabase · OBJECT_OR_COLUMN |
| dbo.QBM_FGIDBQueueActivityDisabled | SQL expression dependency | dbo · SingleUserProcess · OBJECT_OR_COLUMN |
| dbo.QBM_FGIDBQueueSlotsCurrent | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_FGIDBSimulationAllowed | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_FGIMaintenanceRunning | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_FGIMaintenanceRunning_M | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_FGIModuleIsToUpdate | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_FGISingleUserRunning | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_FSQBufferConfigSaveOrigin | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_FSQColumnList | SQL expression dependency | 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 · IsMainDatabase · OBJECT_OR_COLUMN |
| dbo.QER_FGITimeZoneForPerson | SQL expression dependency | dbo · UID_DialogCountryDefault · OBJECT_OR_COLUMN |
| dbo.QBM_PColumnCustomRemove | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PConstraintDisable | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PConstraintEnable | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PConstraintFKDrop | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PDatabasePrepare | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PDatabaseTriggerDisable | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PDatabaseTriggerDrop | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PDatabaseTriggerEnable | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PDBQCS_CurrentRestore | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PDBQCS_SlotExec | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PDBQueueActivityDisable | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PDBQueueActivityEnable | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PDBQueueCurrentResetNGen | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PDBQueueExternalTaskFire | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PDBQueueInsert_Int | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PDBQueueInsert_WaitForComp | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PDBQueuePrepareForCompiler | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PDialogDatabaseInitialInfo | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PFESimulationEnd | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PFESimulationStart | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PGUIDReplaceInsertPair | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobQueueInit_i | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobQueueLoad | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobQueueStatsShrink | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PMigrationNotReadyForComp | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PMultilanguageFill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PMultilanguageFillSQL | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PScheduleCheck | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PSingleUserAlive | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PSingleUserBreak | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PSingleUserRelease | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PSingleUserRequest | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PTableCustomRemove_RU | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PTableReload | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PTriggerDisable | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PTriggerDrop | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PTriggerEnable | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PWatchDogPrepare | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PWorkSchedule | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZAuthentifierInitial | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZConnectionClearUnused | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZGUIDReplaceReady | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_FTDBQCSOverviewLoad | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTLicenseOverview | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1AF9738269E36D4BD687D6339 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T25023756BABB2911A175F2728 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T56AB24A1A231874C43527FD35 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TIQBMGuidReplace | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TUDialogDatabase | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBMSystemMetering | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBMVSystemOverview | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBMVSystemState | SQL expression dependency | OBJECT_OR_COLUMN |
| DialogAuthentifier | referenced by foreign key from table | QBM_RFRL168: DialogDatabase.UID_DialogAuthentifier -> DialogAuthentifier.UID_DialogAuthentifier |
| QBMCulture | referenced by foreign key from table | QBM_RFRL342: DialogDatabase.UID_DialogCultureDefault -> QBMCulture.UID_DialogCulture |
| DialogCountry | referenced by foreign key from table | QBM_RFRL500: DialogDatabase.UID_DialogCountryDefault -> DialogCountry.UID_DialogCountry |
| dbo.QBM_FTJobCreateDBParameter | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QBM_FCVDatetimeToNextWork | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_FGICutOffTaskExists | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_FGIDBOwner | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_FGIDBQueueActivityDisabled | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_FGIDBQueueSlotsCurrent | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_FGIDBSimulationAllowed | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_FGIMaintenanceRunning | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_FGIMaintenanceRunning_M | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_FGIModuleIsToUpdate | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_FGISingleUserRunning | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_FSQBufferConfigSaveOrigin | source text reference | uses session context values |
| dbo.QBM_FSQColumnList | 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_PColumnCustomRemove | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PConstraintDisable | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PConstraintEnable | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PConstraintFKDrop | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PDatabasePrepare | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PDatabaseTriggerDisable | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PDatabaseTriggerDrop | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PDatabaseTriggerEnable | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PDBQCS_CurrentRestore | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PDBQCS_SlotExec | source text reference | uses ChangeLimit/session/config throttling, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PDBQueueActivityDisable | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PDBQueueActivityEnable | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PDBQueueCurrentResetNGen | source text reference | SQL_STORED_PROCEDURE |
| dbo.QBM_PDBQueueExternalTaskFire | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PDBQueueInsert_Int | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PDBQueueInsert_WaitForComp | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QBM_PDBQueuePrepareForCompiler | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PDialogDatabaseInitialInfo | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PFESimulationEnd | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PFESimulationStart | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PGUIDReplaceInsertPair | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PJobQueueInit_i | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PJobQueueLoad | source text reference | creates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PJobQueueStatsShrink | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PMigrationNotReadyForComp | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PMultilanguageFill | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PMultilanguageFillSQL | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PScheduleCheck | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PSingleUserAlive | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PSingleUserBreak | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PSingleUserRelease | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PSingleUserRequest | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PTableCustomRemove_RU | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PTableReload | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QBM_PTrafficLight | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PTriggerDisable | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PTriggerDrop | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PTriggerEnable | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PWatchDogPrepare | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PWorkSchedule | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZAuthentifierInitial | source text reference | has TRY/CATCH error handling |
| dbo.QBM_ZConnectionClearUnused | source text reference | has TRY/CATCH error handling |
| dbo.QBM_ZGUIDReplaceReady | source text reference | has TRY/CATCH error handling |
| dbo.QBM_FTDBQCSOverviewLoad | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.QER_FTLicenseOverview | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.QBM_TIQBMGuidReplace | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TUDialogDatabase | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-common-customizer-vi-common-customizer-dialogdatabase.cs | decompiled C# reference | classes DialogDatabase, _003C_003Ec__DisplayClass7_0; methods _003C_CheckDialogCultureDefault_003Eb__0, MoveNext, SetStateMachine, OnSavingAsync, _CheckAuthentifierAsync, _CheckConnectionStringAsync; references DialogAuthentifier, DialogDatabase, QBMCulture; markers reads entity values, references DB/Dialog objects |