dbo.DPRSystemSyncDependency
Existing logical dependencies between tables (e.g. from triggers), which must be taken into account when automatically determining the processing sequence of synchronization steps.
TableType TUsage CONFIGURATIONRows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DPRSystemSyncDependency | varchar(38) | no | Dependency if database synchronized automatically | PKUID |
UID_DialogTablePrior | varchar(38) | no | Prior table | FKUID |
UID_DialogTable | varchar(38) | no | Table | FKUID |
DependencyType | int(4) | yes | Dependency type | |
Name | nvarchar(512) | no | Name | |
Description | nvarchar(2048) | yes | Description | |
XObjectKey | varchar(138) | no | Object key | |
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 |
Relations
| FK | From | To |
|---|---|---|
| DPR_RFRL2551 | DPRSystemSyncDependency.UID_DialogTable | DialogTable.UID_DialogTable |
Triggers
DPR_TDDPRSystemSyncDependency SQL_TRIGGER
DPR_TIDPRSystemSyncDependency SQL_TRIGGER
DPR_TUDPRSystemSyncDependency SQL_TRIGGER
GEN_T16CC8EDC40A7C21086FD0B451 SQL_TRIGGER
GEN_T26B2D6147665D366EEE5ADE90 SQL_TRIGGER
GEN_T3BC7222BC3627F9FF0828694A 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.DPR_TUDPRSystemSyncDependency | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T34E19FED13BBF3D09D6B42A59 | SQL expression dependency | OBJECT_OR_COLUMN |
| DialogTable | referenced by foreign key from table | DPR_RFRL2551: DPRSystemSyncDependency.UID_DialogTable -> DialogTable.UID_DialogTable |
| dbo.DPR_TUDPRSystemSyncDependency | 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 |