dbo.JobChain
Processes
TableType TUsage CONFIGURATIONRows 341SizeMB 1.184
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_JobChain | varchar(38) | no | Process | PKUID |
UID_JobChainCopiedFrom | varchar(38) | yes | Copy template | FKUID |
UID_Job | varchar(38) | yes | Process step | FKUID |
Name | nvarchar(510) | no | Name | |
NoGenerate | bit(1) | yes | Do not generate | |
GenCondition | nvarchar(-1) | yes | Generating condition | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
ProcessTracking | int(4) | yes | Process information | limited |
ProcessDisplay | nvarchar(-1) | yes | Process information term | |
CustomRemarks | nvarchar(510) | yes | Remarks | |
Description | nvarchar(2046) | yes | Description | |
LayoutPositions | nvarchar(-1) | yes | Window positions | |
XTouched | nchar(2) | yes | Processing status | |
PreProcessorCondition | nvarchar(510) | yes | Preprocessor condition | |
LimitationCount | int(4) | yes | Threshold value (disable) | |
PreCode | nvarchar(-1) | yes | Pre-script for generating | |
XObjectKey | varchar(138) | no | Object key | |
LimitationWarning | int(4) | yes | Threshold value (warning) | |
IsDeactivatedByPreProcessor | bit(1) | yes | Deactivated by preprocessor | |
UID_DialogTable | varchar(38) | no | Table | FKUID |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
Relations
| FK | From | To |
|---|---|---|
| QBM_RFRL16 | JobEventGen.UID_JobChain | JobChain.UID_JobChain |
| QBM_RFRL167 | Job.UID_JobChain | JobChain.UID_JobChain |
| QBM_RFRL59 | JobChain.UID_DialogTable | DialogTable.UID_DialogTable |
Triggers
GEN_T15E4B8709219A3DA06BC3C657 SQL_TRIGGER
GEN_T2587AF58190E7B24F5F73E4D6 SQL_TRIGGER
GEN_T388DF4E72DF35F2D6E4A245C4 SQL_TRIGGER
GEN_T57C5852ECD733EFED139B5E91 SQL_TRIGGER
QBM_TDAssembly_Jobchain SQL_TRIGGER
QBM_TIAssembly_JobChain SQL_TRIGGER
QBM_TIJobChain SQL_TRIGGER
QBM_TUAssembly_JobChain SQL_TRIGGER
QBM_TUJobChain 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_PMNTableInsert | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PMNTableInsertOwnPK | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZPrePropJob | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZPrePropJobChain | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZPrePropTable | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T15E4B8709219A3DA06BC3C657 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2587AF58190E7B24F5F73E4D6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T388DF4E72DF35F2D6E4A245C4 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3E9FF91784D40BB4CAFAE33D8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T57C5852ECD733EFED139B5E91 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TDAssembly_Job | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TDAssembly_JobRunparameter | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TIAssembly_Job | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TIAssembly_JobRunparameter | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TIJobqueue | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TUAssembly_Job | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TUAssembly_JobChain | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TUAssembly_JobRunparameter | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBMVCustomInfo | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBMVSystemInfo | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBMVTableEventChain | SQL expression dependency | OBJECT_OR_COLUMN |
| JobEventGen | foreign key references table | QBM_RFRL16: JobEventGen.UID_JobChain -> JobChain.UID_JobChain |
| Job | foreign key references table | QBM_RFRL167: Job.UID_JobChain -> JobChain.UID_JobChain |
| DialogTable | referenced by foreign key from table | QBM_RFRL59: JobChain.UID_DialogTable -> DialogTable.UID_DialogTable |
| dbo.QBM_PMNTableInsert | 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_PMNTableInsertOwnPK | 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_ZPrePropJob | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZPrePropJobChain | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZPrePropTable | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TDAssembly_Job | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TDAssembly_JobRunparameter | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TIAssembly_Job | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TIAssembly_JobRunparameter | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TIJobqueue | 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_TUAssembly_Job | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TUAssembly_JobChain | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TUAssembly_JobRunparameter | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-common-customizer-vi-common-customizer-jobeventgen.cs | decompiled C# reference | classes JobEventGen; methods MoveNext, SetStateMachine, GetParameterCollection, GetParameterCollectionAsync, _GetParameterCollectionAsync, _CollectParamsAsync; references DialogTable, JobChain, JobEventGen, JobRunParameter, QBMEvent; markers reads entity values, references DB/Dialog objects, Job/process related markers |
| cs-common-customizer-vi-common-customizer-jobqueue.cs | decompiled C# reference | classes JobQueue, _003C_003Ec__DisplayClass4_0, _003C_003Ec__DisplayClass5_0; methods _003C_DeleteTree_003Eb__0, _003C_DeleteTrees_003Eb__0, MoveNext, SetStateMachine, _ResetFrozen, _RepairUidSameServer; references ESet, JobChain, JobQueue; markers reads entity values, references DB/Dialog objects, Job/process related markers |
| cs-designer-editors-designer-jobchaineditor-jobchainedit.cs | decompiled C# reference | classes JobChainEdit; methods OnDisposeOrPrepareForCaching, InitializeComponent, _InitializeComponent, SetValidity, LoadChain, SaveChain; references ESet, JobChain, JobEventGen, JobRunParameter; markers reads entity values, writes entity values, references DB/Dialog objects, Job/process related markers |
| cs-jobqueueinfo-vi-tools-jobqueueinfo-dcbase.cs | decompiled C# reference | classes DCBase, Ready2Exe; methods SelectJob, GetNodeState, IsAnySelectedJob, ProcessSelectedJobs, ConfigureToolTip, GetJobState; references ESet, JobChain, JobQueue; markers reads entity values, references DB/Dialog objects, Job/process related markers |
| cs-jobqueueinfo-vi-tools-jobqueueinfo-dcjobchains.cs | decompiled C# reference | classes DCJobChains; methods ToolTipError_Popup, RefreshData, OnHandleDestroyed, _LoadFormSettings, _SaveFormSettings, _ClearTree; references ESet, JobChain, JobParameter, JobQueue, JobTreeParamColl; markers reads entity values, writes entity values, references DB/Dialog objects, Job/process related markers |
| cs-jobqueueinfo-vi-tools-jobqueueinfo-dcjoberrors.cs | decompiled C# reference | classes DCJobErrors; methods SelectJob, RefreshData, Dispose, OnHandleDestroyed, InitializeComponent, _LoadFormSettings; references ESet, JobChain, JobHistory, JobQueue; markers reads entity values, writes entity values, references DB/Dialog objects, Job/process related markers |
| cs-vi-db-compile-vi-db-compile-dialogjobgenassemblybuilder.cs | decompiled C# reference | classes DialogJobGenAssemblyBuilder, _ValueReplacer, _003C_003Ec__DisplayClass21_0, _003C_003Ec__DisplayClass23_0; methods Replace, _ReplaceMatch, _003C_GenerateEventsAsync_003Eb__0, _003C_GenerateJobAsync_003Eb__0, MoveNext, SetStateMachine; references DialogTable, JobChain, JobComponent, JobEventGen, JobParameter, JobRunParameter; markers reads entity values, references DB/Dialog objects, Job/process related markers |
| cs-vi-db-compile-vi-db-compile-sourcegenerators-jobssourcegenerator.cs | decompiled C# reference | classes JobsSourceGenerator, JobsAssemblyGenerator, _PreloadTable, _ValueReplacer; methods _003C_ReplaceMatchAsync_003Eb__0, MoveNext, SetStateMachine, _CreateRegPattern, _CreateRegVersion, ReplaceAsync; references DialogTable, JobChain, JobComponent, JobEventGen, JobParameter, JobRunParameter; markers reads entity values, references DB/Dialog objects, Job/process related markers |
| cs-vi-projector-database-vi-projector-database-outstanding-outstandinghandler.cs | decompiled C# reference | classes OutstandingHandler; methods ExecuteAction, GetDependencies, _Translate, _ExecuteAction, _ExecuteOperationByCustomizers, Reset; references DialogTable, ESet, JobChain, JobEventGen, QBMClrType, QBMEvent; markers references DB/Dialog objects, Job/process related markers |