dbo.DPRSystemObjectMatchSet
Internal structure and part of a workflow step. The table is handled by the SynchronizationEditor. Do not make any changes here.
TableType TUsage USERDATARows 236SizeMB 0.2
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DPRSystemObjectMatchSet | varchar(38) | no | System object matching set | PKUID |
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 | |
SerializationBag | nvarchar(-1) | yes | Serialization bag | |
UID_QBMClrType | varchar(38) | no | CLR type | FKUID |
Relations
| FK | From | To |
|---|---|---|
| DPR_RFRL2422 | DPRSystemObjectMatchSetMAsgn.UID_DPRSystemObjectMatchSet | DPRSystemObjectMatchSet.UID_DPRSystemObjectMatchSet |
| DPR_RFRL2452 | DPRSystemObjectMatchSet.UID_QBMClrType | QBMClrType.UID_QBMClrType |
Triggers
GEN_T234B1C058F1CC27858AB74346 SQL_TRIGGER
GEN_T3ECF4B46B06BE16A1E40B8868 SQL_TRIGGER
GEN_T44CA107FE7820C3B15ADA02DF SQL_TRIGGER
GEN_T5B0B9A8B5C8BB7AF7C8665C98 SQL_TRIGGER
GEN_T6195200E2BA5167156CFC4B06 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_TDDPRSystemObjectMatchSets | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T103A34E583B479BF6D9EDE78E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T13371B79AFC07E3D85A0E6931 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2533961CE30C7800D5891E69C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2ABAE3443DC53DD3EC1BBAC13 | SQL expression dependency | OBJECT_OR_COLUMN |
| DPRSystemObjectMatchSetMAsgn | foreign key references table | DPR_RFRL2422: DPRSystemObjectMatchSetMAsgn.UID_DPRSystemObjectMatchSet -> DPRSystemObjectMatchSet.UID_DPRSystemObjectMatchSet |
| QBMClrType | referenced by foreign key from table | DPR_RFRL2452: DPRSystemObjectMatchSet.UID_QBMClrType -> QBMClrType.UID_QBMClrType |
| dbo.DPR_TDDPRSystemObjectMatchSets | source text reference | has TRY/CATCH error handling |