dbo.DPRShell
Synchronization projects store all information required for synchronization. The table is handled by the SynchronizationEditor. Do not make any changes here.
TableType TUsage USERDATARows 3SizeMB 12.864
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DPRShell | varchar(38) | no | Synchronization project | 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 |
ScriptLanguage | nvarchar(32) | yes | Script language | limited |
UID_DPRSystemVariableSetDef | varchar(38) | yes | Default variable set | FKUID |
IsFinalized | int(4) | yes | Activated | bitmask |
OriginInfo | nvarchar(-1) | yes | Template (origin) | |
MigrationState | nvarchar(-1) | yes | Migration state | |
EditedBy | nvarchar(128) | yes | Edited by | |
EditedSince | datetime(8) | yes | Edited since | |
ShadowCopyMode | nvarchar(64) | yes | Copy mode | limited |
ShadowCopy | nvarchar(-1) | yes | Shadow copy | |
SupportedFeatureSet | int(4) | yes | Supported feature set | |
Tags | nvarchar(-1) | yes | Tags | |
LastMigrationError | nvarchar(-1) | yes | Error message of last migration | |
IsAutomaticallyManaged | bit(1) | yes | Automatically managed | |
UID_AERoleShellOwner | varchar(38) | yes | Owner (Application Role) | FKUID |
Relations
| FK | From | To |
|---|---|---|
| DPR_RFRL2310 | DPRScript.UID_DPRShell | DPRShell.UID_DPRShell |
| DPR_RFRL2446 | DPRShell.UID_QBMClrType | QBMClrType.UID_QBMClrType |
| DPR_RFRL2464 | DPRSystemVariableSet.UID_DPRShell | DPRShell.UID_DPRShell |
| DPR_RFRL2474 | DPRProjectionStartInfo.UID_DPRShell | DPRShell.UID_DPRShell |
| DPR_RFRL2486 | DPRProjectionConfig.UID_DPRShell | DPRShell.UID_DPRShell |
| DPR_RFRL2487 | DPRSchema.UID_DPRShell | DPRShell.UID_DPRShell |
| DPR_RFRL2489 | DPRSystemConnection.UID_DPRShell | DPRShell.UID_DPRShell |
| DPR_RFRL2490 | DPRSystemMap.UID_DPRShell | DPRShell.UID_DPRShell |
| DPR_RFRL2491 | DPRSystemScope.UID_DPRShell | DPRShell.UID_DPRShell |
| DPR_RFRL2552 | DPRProjectionDependency.UID_DPRShell | DPRShell.UID_DPRShell |
| QER_RFRL4400 | DPRShell.UID_AERoleShellOwner | BaseTree.UID_Org |
Triggers
GEN_T1091A5091811C57949DC3E9F0 SQL_TRIGGER
GEN_T201000728C967B79DFD85AD21 SQL_TRIGGER
GEN_T3E5DE14F2D6D9DAAE60D6AF5E SQL_TRIGGER
GEN_T4A6132F14467214E9C27DE933 SQL_TRIGGER
GEN_T511BA0FBFBB36F0DDE0D9B914 SQL_TRIGGER
GEN_T6DF41B790CB8AA4E0015FBFB8 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 |
| dbo.DPRVSyncRunMessages | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DPRVSyncRunOverview | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVShellOwnerUsage | SQL expression dependency | OBJECT_OR_COLUMN |
| DPRScript | foreign key references table | DPR_RFRL2310: DPRScript.UID_DPRShell -> DPRShell.UID_DPRShell |
| QBMClrType | referenced by foreign key from table | DPR_RFRL2446: DPRShell.UID_QBMClrType -> QBMClrType.UID_QBMClrType |
| DPRSystemVariableSet | foreign key references table | DPR_RFRL2464: DPRSystemVariableSet.UID_DPRShell -> DPRShell.UID_DPRShell |
| DPRProjectionStartInfo | foreign key references table | DPR_RFRL2474: DPRProjectionStartInfo.UID_DPRShell -> DPRShell.UID_DPRShell |
| DPRProjectionConfig | foreign key references table | DPR_RFRL2486: DPRProjectionConfig.UID_DPRShell -> DPRShell.UID_DPRShell |
| DPRSchema | foreign key references table | DPR_RFRL2487: DPRSchema.UID_DPRShell -> DPRShell.UID_DPRShell |
| DPRSystemConnection | foreign key references table | DPR_RFRL2489: DPRSystemConnection.UID_DPRShell -> DPRShell.UID_DPRShell |
| DPRSystemMap | foreign key references table | DPR_RFRL2490: DPRSystemMap.UID_DPRShell -> DPRShell.UID_DPRShell |
| DPRSystemScope | foreign key references table | DPR_RFRL2491: DPRSystemScope.UID_DPRShell -> DPRShell.UID_DPRShell |
| DPRProjectionDependency | foreign key references table | DPR_RFRL2552: DPRProjectionDependency.UID_DPRShell -> DPRShell.UID_DPRShell |
| BaseTree | referenced by foreign key from table | QER_RFRL4400: DPRShell.UID_AERoleShellOwner -> BaseTree.UID_Org |
| cs-qer-customizer-qer-customizer-dprshell.cs | decompiled C# reference | classes DPRShell, _003C_003Ec__DisplayClass3_0, _003C_003Ec__DisplayClass5_0; methods _003C_CreateShellOwnerRole_OnSaving_003Eb__0, _003C_CheckAERoleShellOwner_003Eb__0, MoveNext, SetStateMachine, CreateShellOwnerRole, _CreateShellOwnerRole_OnSaving; references AERole, DPRShell; markers reads entity values, writes entity values, references DB/Dialog objects |
| cs-vi-projector-editor-vi-projector-editor-managestartsequencesdialog.cs | decompiled C# reference | classes ManageStartSequencesDialog; methods OnTranslateDialog, OnSave, OnShown, _SetupLogic, _FilterStartInfos, _Move; references DialogSchedule, DialogTable, DPRProjectionStartInfo, DPRShell, DPRStartSequence, ESet; markers reads entity values, references DB/Dialog objects |