dbo.DPRSystemMappingRule
Defines the relations between one target system property and one %Globals.QIM_ProductNameFull% property. The table is handled by the Synchronization Editor. Do not make any changes here.
TableType TUsage USERDATARows 803SizeMB 1
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DPRSystemMappingRule | varchar(38) | no | System mapping rule | PKUID |
UID_DPRSystemMap | varchar(38) | no | System map | 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 | |
DoNotOverrideLeft | bit(1) | yes | Do not override left value | |
DoNotOverrideRight | bit(1) | yes | Do not override right value | |
HandleAsSingleValueLeft | bit(1) | yes | Handle left side as single value | |
HandleAsSingleValueRight | bit(1) | yes | Handle right side as single value | |
IgnoreCase | bit(1) | yes | Ignore case | |
IsKeyRule | bit(1) | yes | Is object matching rule | |
MappingDirection | nvarchar(64) | yes | Allowed mapping direction | |
Name | nvarchar(512) | no | Name | |
NameFormat | nvarchar(64) | yes | Name format | |
PerformMappingContraProjection | bit(1) | yes | Perform mapping contra synchonization direction | |
PropertyLeft | nvarchar(512) | yes | Left schema property | |
PropertyRight | nvarchar(512) | yes | Right schema property | |
UID_QBMClrType | varchar(38) | no | CLR type | FKUID |
SerializationBag | nvarchar(-1) | yes | Serialization bag | |
SortOrder | float(8) | yes | Sort order | |
UID_MappingCondQBMClrType | varchar(38) | yes | Condition CLR type | FKUID |
MappingCondition | nvarchar(-1) | yes | Mapping condition | |
IsRogueCorrectionEnabled | bit(1) | yes | Rogue correction enabled | |
IsRogueDetectionEnabled | bit(1) | yes | Rogue detection enabled | |
IgnoreCaseDifferencesOnly | bit(1) | yes | Ignore case differences only | |
IgnoreMappingDirectionByCreate | bit(1) | yes | Ignore mapping direction for new objects | |
ConcurrenceBehavior | nvarchar(64) | yes | Data concurrence behavior | |
DisableMergeModeSupport | bit(1) | yes | Deactivate merge mode (support) | |
MvpOrderBehavior | nvarchar(64) | yes | Multi-value sort order behavior |
Relations
| FK | From | To |
|---|---|---|
| DPR_RFRL2428 | DPRSystemMappingRule.UID_QBMClrType | QBMClrType.UID_QBMClrType |
| DPR_RFRL2484 | DPRSystemMappingRule.UID_MappingCondQBMClrType | QBMClrType.UID_QBMClrType |
Triggers
GEN_T12365C8F4957769C76C2158B6 SQL_TRIGGER
GEN_T231AAFBC6AA878F2B62228262 SQL_TRIGGER
GEN_T389F0CAA3BA415B979AA45412 SQL_TRIGGER
GEN_T4C5420B9FC786DB0DFD98817E SQL_TRIGGER
GEN_T5EC5AD4EAF2C32063062B6DBA SQL_TRIGGER
GEN_T6A9691DE11E82E176011990DD 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_PAttachedDataStoreCleanUp | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DPR_FTSystemMappingRuleEffect | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.DPR_FTSystemMappingRuleEffect | SQL expression dependency | dbo · UID_DPRSystemMappingRule · OBJECT_OR_COLUMN |
| dbo.DPR_FTSystemMappingRuleEffect | SQL expression dependency | dbo · UID_DPRSystemMap · OBJECT_OR_COLUMN |
| dbo.DPR_FTSystemMappingRuleEffect | SQL expression dependency | dbo · Name · OBJECT_OR_COLUMN |
| dbo.GEN_T13371B79AFC07E3D85A0E6931 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2ABAE3443DC53DD3EC1BBAC13 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3D122D901FE2386C64D83FD24 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DPR_VWorkflowHandlesProperty | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DPR_VWorkflowReadsProperty | SQL expression dependency | OBJECT_OR_COLUMN |
| QBMClrType | referenced by foreign key from table | DPR_RFRL2428: DPRSystemMappingRule.UID_QBMClrType -> QBMClrType.UID_QBMClrType |
| QBMClrType | referenced by foreign key from table | DPR_RFRL2484: DPRSystemMappingRule.UID_MappingCondQBMClrType -> QBMClrType.UID_QBMClrType |
| dbo.DPR_PAttachedDataStoreCleanUp | source text reference | has TRY/CATCH error handling |
| dbo.DPR_FTSystemMappingRuleEffect | source text reference | SQL_TABLE_VALUED_FUNCTION |