dbo.DPRSystemMap
Mapping tables are required to connect target system data with the %Globals.QIM_ProductNameFull% data. The table is handled by the Synchronization Editor. Do not make any changes here.
TableType TUsage USERDATARows 32SizeMB 0.08
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DPRSystemMap | varchar(38) | no | Mapping | PKUID |
UID_LeftDPRSchemaClass | varchar(38) | no | Left schema class | 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 | |
MappingDirection | nvarchar(64) | yes | Allowed mapping direction | |
Name | nvarchar(512) | no | Name | |
NameFormat | nvarchar(64) | yes | Name format | |
IsTemplate | bit(1) | yes | §§DPR template | |
SerializationBag | nvarchar(-1) | yes | Serialization bag | |
UID_QBMClrType | varchar(38) | no | CLR type | FKUID |
UID_RightDPRSchemaClass | varchar(38) | no | Right schema class | FKUID |
UID_BaseDPRSystemMap | varchar(38) | yes | Base system map | FKUID |
UID_DPRShell | varchar(38) | no | Synchronization project | FKUID |
Capabilities | nvarchar(128) | yes | Capabilities | |
IsHierarchyProjection | bit(1) | yes | Is hierarchy synchronization |
Relations
| FK | From | To |
|---|---|---|
| DPR_RFRL2424 | DPRSystemMap.UID_QBMClrType | QBMClrType.UID_QBMClrType |
| DPR_RFRL2490 | DPRSystemMap.UID_DPRShell | DPRShell.UID_DPRShell |
Triggers
GEN_T1BD7E5BA9BA10D30762D10F23 SQL_TRIGGER
GEN_T29E7426D1239182D68F53BD1B SQL_TRIGGER
GEN_T3D122D901FE2386C64D83FD24 SQL_TRIGGER
GEN_T4A27B4AA12DE41713293CD4E2 SQL_TRIGGER
GEN_T5C815E825CA75440538BA3B70 SQL_TRIGGER
GEN_T6D6E118E2352117EE00B6D11E 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_FTSystemMapChildren | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.DPR_FTSystemMapChildren | SQL expression dependency | dbo · UID_DPRSystemMap · OBJECT_OR_COLUMN |
| dbo.DPR_FTSystemMapChildren | SQL expression dependency | dbo · MappingDirection · OBJECT_OR_COLUMN |
| dbo.DPR_FTSystemMapChildren | SQL expression dependency | dbo · UID_BaseDPRSystemMap · OBJECT_OR_COLUMN |
| dbo.DPR_FTSystemMappingRuleEffect | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.DPR_FTSystemMappingRuleEffect | SQL expression dependency | dbo · UID_DPRSystemMap · OBJECT_OR_COLUMN |
| dbo.DPR_FTSystemMappingRuleEffect | SQL expression dependency | dbo · UID_BaseDPRSystemMap · OBJECT_OR_COLUMN |
| dbo.GEN_T12365C8F4957769C76C2158B6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T13371B79AFC07E3D85A0E6931 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1BD7E5BA9BA10D30762D10F23 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1CA0C8442B8F03A860242E9BE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T231AAFBC6AA878F2B62228262 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T29E7426D1239182D68F53BD1B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2ABAE3443DC53DD3EC1BBAC13 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2C0E22894CCB9523215FF2E10 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DPR_VSystemMapCollection | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.DPR_VSystemMapCollection | SQL expression dependency | dbo · UID_DPRSystemMap · OBJECT_OR_COLUMN |
| dbo.DPR_VSystemMapCollection | SQL expression dependency | dbo · UID_BaseDPRSystemMap · OBJECT_OR_COLUMN |
| QBMClrType | referenced by foreign key from table | DPR_RFRL2424: DPRSystemMap.UID_QBMClrType -> QBMClrType.UID_QBMClrType |
| DPRShell | referenced by foreign key from table | DPR_RFRL2490: DPRSystemMap.UID_DPRShell -> DPRShell.UID_DPRShell |
| dbo.DPR_FTSystemMapChildren | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.DPR_FTSystemMappingRuleEffect | source text reference | SQL_TABLE_VALUED_FUNCTION |