dbo.DPRSystemVariableSet
Variables sets are used by synchronization projects to deal with different target systems. The table is handled by the SynchronizationEditor. Do not make any changes here.
TableType TUsage USERDATARows 3SizeMB 0.048
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DPRSystemVariableSet | varchar(38) | no | Variable set | PKUID |
Name | nvarchar(512) | yes | Name | |
DisplayName | nvarchar(512) | yes | Display name | |
NameFormat | nvarchar(64) | yes | Name format | |
Description | nvarchar(2048) | yes | Description | |
UID_DPRShell | varchar(38) | yes | Synchronization project | FKUID |
UID_DPRSystemVariableSetParent | varchar(38) | yes | Parent 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 | |
UID_QBMClrType | varchar(38) | no | CLR type | FKUID |
Relations
| FK | From | To |
|---|---|---|
| DPR_RFRL2464 | DPRSystemVariableSet.UID_DPRShell | DPRShell.UID_DPRShell |
| DPR_RFRL2477 | DPRSystemVariableSet.UID_QBMClrType | QBMClrType.UID_QBMClrType |
Triggers
GEN_T13D691E9E3E822851C6F694DC SQL_TRIGGER
GEN_T2C8F854A5060C23B91EFA9FC2 SQL_TRIGGER
GEN_T39F1E8AA12558B27224F1C08D SQL_TRIGGER
GEN_T410A90FDAF707BDFB80CD34A4 SQL_TRIGGER
GEN_T5E12C60F09D459794CA9177FA SQL_TRIGGER
GEN_T6383056463D3BC7CE31E6E5AB 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_T1091A5091811C57949DC3E9F0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T129AA6B1C7A2D7ED36935DB4D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T12CE1957372DF9066AA75DC63 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T13371B79AFC07E3D85A0E6931 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T13D691E9E3E822851C6F694DC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T14A1FC6C6D44496A242344432 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T159CDDF6B74BAE39740E29C01 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1AB495C5FC912D3023F536908 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1E477E9748D94AC57F6A1C193 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T201000728C967B79DFD85AD21 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T20C9B1FFAD454B1F0285E93CD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T263485ABAD5B92BDCB9AC2E46 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2635D2E7C173FD59B07D4B0F7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2ABAE3443DC53DD3EC1BBAC13 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2AC60E557639AF2EA936D1437 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2C8F854A5060C23B91EFA9FC2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2D23028ED6A3F647D1612DD0C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2F3AB1B0FE854E66AC63B6CB4 | SQL expression dependency | OBJECT_OR_COLUMN |
| DPRShell | referenced by foreign key from table | DPR_RFRL2464: DPRSystemVariableSet.UID_DPRShell -> DPRShell.UID_DPRShell |
| QBMClrType | referenced by foreign key from table | DPR_RFRL2477: DPRSystemVariableSet.UID_QBMClrType -> QBMClrType.UID_QBMClrType |