dbo.DPRSystemObjectMatchSets
Internal structure and part of a workflow step. The table is handled by the SynchronizationEditor. Do not make any changes here.
TableType TUsage USERDATARows 59SizeMB 0.112
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DPRSystemObjectMatchSets | varchar(38) | no | System object matching sets | PKUID |
UID_DifferenceRightToLeftSet | varchar(38) | yes | Difference right to left set | FKUID |
UID_IntersectionDifferenceSet | varchar(38) | yes | Intersection difference set | FKUID |
UID_IntersectionEqualitySet | varchar(38) | yes | Intersection equality set | FKUID |
UID_DifferenceLeftToRightSet | varchar(38) | yes | Difference left to right set | FKUID |
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 | |
Description | nvarchar(2048) | yes | Description | |
DisplayName | nvarchar(512) | yes | Display name | |
Name | nvarchar(512) | no | Name | |
NameFormat | nvarchar(64) | yes | Name format | |
UID_QBMClrType | varchar(38) | no | CLR type | FKUID |
Relations
| FK | From | To |
|---|---|---|
| DPR_RFRL2451 | DPRSystemObjectMatchSets.UID_QBMClrType | QBMClrType.UID_QBMClrType |
Triggers
DPR_TDDPRSystemObjectMatchSets SQL_TRIGGER
GEN_T103A34E583B479BF6D9EDE78E SQL_TRIGGER
GEN_T2533961CE30C7800D5891E69C SQL_TRIGGER
GEN_T3B41E896F436A7D1E303F1081 SQL_TRIGGER
GEN_T45755DC1AF6B7F731130E0D14 SQL_TRIGGER
GEN_T527DB7DC515247A0C993B71B8 SQL_TRIGGER
GEN_T6A97483619AD5CAE25245680D 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_TDDPRProjectionConfigStep | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T13371B79AFC07E3D85A0E6931 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2ABAE3443DC53DD3EC1BBAC13 | SQL expression dependency | OBJECT_OR_COLUMN |
| QBMClrType | referenced by foreign key from table | DPR_RFRL2451: DPRSystemObjectMatchSets.UID_QBMClrType -> QBMClrType.UID_QBMClrType |
| dbo.DPR_TDDPRProjectionConfigStep | source text reference | has TRY/CATCH error handling |