dbo.DPRSystemObjectMatchSetMAsgn
Internal structure and part of a workflow step. The table is handled by the SynchronizationEditor. Do not make any changes here.
TableType TUsage USERDATARows 209SizeMB 0.328
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DPRSystemObjectMatchSetMA | varchar(38) | no | System object matching set method assignment | 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 | |
ConditionData | nvarchar(-1) | yes | Condition data | |
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 | |
TargetProjectionDirection | nvarchar(64) | yes | Target projection direction | |
UID_DPRSchemaMethod | varchar(38) | no | Schema method | FKUID |
UID_QBMClrType | varchar(38) | no | CLR type | FKUID |
UID_DPRSystemObjectMatchSet | varchar(38) | no | System object matching set | FKUID |
Side | nvarchar(32) | no | Side | |
UID_ConditionQBMClrType | varchar(38) | yes | Condition type | FKUID |
Sequence | int(4) | yes | Sequence |
Relations
| FK | From | To |
|---|---|---|
| DPR_RFRL2422 | DPRSystemObjectMatchSetMAsgn.UID_DPRSystemObjectMatchSet | DPRSystemObjectMatchSet.UID_DPRSystemObjectMatchSet |
| DPR_RFRL2423 | DPRSystemObjectMatchSetMAsgn.UID_DPRSchemaMethod | DPRSchemaMethod.UID_DPRSchemaMethod |
| DPR_RFRL2453 | DPRSystemObjectMatchSetMAsgn.UID_QBMClrType | QBMClrType.UID_QBMClrType |
| DPR_RFRL2454 | DPRSystemObjectMatchSetMAsgn.UID_ConditionQBMClrType | QBMClrType.UID_QBMClrType |
Triggers
GEN_T23E7FFC23A9D314CE30415972 SQL_TRIGGER
GEN_T317539A5BBFDDA23B513F61D0 SQL_TRIGGER
GEN_T48250F5A9771B048E612DCC7C SQL_TRIGGER
GEN_T54AA39C8399366B195AEABAA2 SQL_TRIGGER
GEN_T657D6F7ACF8285655024B9425 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.GEN_T13371B79AFC07E3D85A0E6931 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2ABAE3443DC53DD3EC1BBAC13 | SQL expression dependency | OBJECT_OR_COLUMN |
| DPRSystemObjectMatchSet | referenced by foreign key from table | DPR_RFRL2422: DPRSystemObjectMatchSetMAsgn.UID_DPRSystemObjectMatchSet -> DPRSystemObjectMatchSet.UID_DPRSystemObjectMatchSet |
| DPRSchemaMethod | referenced by foreign key from table | DPR_RFRL2423: DPRSystemObjectMatchSetMAsgn.UID_DPRSchemaMethod -> DPRSchemaMethod.UID_DPRSchemaMethod |
| QBMClrType | referenced by foreign key from table | DPR_RFRL2453: DPRSystemObjectMatchSetMAsgn.UID_QBMClrType -> QBMClrType.UID_QBMClrType |
| QBMClrType | referenced by foreign key from table | DPR_RFRL2454: DPRSystemObjectMatchSetMAsgn.UID_ConditionQBMClrType -> QBMClrType.UID_QBMClrType |