dbo.DPRSystemScope
Defines scopes a kind of a system view. The table is handled by the SynchronizationEditor. Do not make any changes here.
TableType TUsage USERDATARows 4SizeMB 0.056
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DPRSystemScope | varchar(38) | no | System scope | PKUID |
UID_DPRShell | varchar(38) | no | Synchronization project | 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 | |
CheckUpdates | bit(1) | yes | Prohibit scope transition | |
Description | nvarchar(2048) | yes | Description | |
DisplayName | nvarchar(512) | yes | Display name | |
HashThreshold | int(4) | yes | Hash threshold | |
Name | nvarchar(512) | no | Name | |
NameFormat | nvarchar(64) | yes | Name format | |
SerializationBag | nvarchar(-1) | yes | Serialization bag | |
UID_DPRSchema | varchar(38) | no | Schema | FKUID |
UID_QBMClrType | varchar(38) | no | CLR type | FKUID |
UID_HierarchyFilterQBMClrType | varchar(38) | yes | Hierarchy filter CLR type | FKUID |
HierarchyFilter | varchar(-1) | yes | Hierarchy filter |
Relations
| FK | From | To |
|---|---|---|
| DPR_RFRL2429 | DPRSystemScope.UID_QBMClrType | QBMClrType.UID_QBMClrType |
| DPR_RFRL2461 | DPRSystemScope.UID_HierarchyFilterQBMClrType | QBMClrType.UID_QBMClrType |
| DPR_RFRL2491 | DPRSystemScope.UID_DPRShell | DPRShell.UID_DPRShell |
| DPR_RFRL2495 | DPRSystemConnection.UID_DPRSystemScope | DPRSystemScope.UID_DPRSystemScope |
| DPR_RFRL2496 | DPRSystemConnection.UID_DPRSystemScopeForRefer | DPRSystemScope.UID_DPRSystemScope |
Triggers
GEN_T1EA6175C95DA6E878F66BC881 SQL_TRIGGER
GEN_T24B4CD9133296C1A1E89E1234 SQL_TRIGGER
GEN_T3644939CA64BF049520D143EF SQL_TRIGGER
GEN_T413523CE24B5B2A724BBDB6F7 SQL_TRIGGER
GEN_T50B9FF68F621A32D3F20AB28E SQL_TRIGGER
GEN_T6A1AFED1BF4B32B276ABBB743 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_T123C0AE0A54037E8FE746ECE5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T13371B79AFC07E3D85A0E6931 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T241051F8E636D139C8011CB6B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2ABAE3443DC53DD3EC1BBAC13 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3D466D5C4953840BA3CFC4FBA | SQL expression dependency | OBJECT_OR_COLUMN |
| QBMClrType | referenced by foreign key from table | DPR_RFRL2429: DPRSystemScope.UID_QBMClrType -> QBMClrType.UID_QBMClrType |
| QBMClrType | referenced by foreign key from table | DPR_RFRL2461: DPRSystemScope.UID_HierarchyFilterQBMClrType -> QBMClrType.UID_QBMClrType |
| DPRShell | referenced by foreign key from table | DPR_RFRL2491: DPRSystemScope.UID_DPRShell -> DPRShell.UID_DPRShell |
| DPRSystemConnection | foreign key references table | DPR_RFRL2495: DPRSystemConnection.UID_DPRSystemScope -> DPRSystemScope.UID_DPRSystemScope |
| DPRSystemConnection | foreign key references table | DPR_RFRL2496: DPRSystemConnection.UID_DPRSystemScopeForRefer -> DPRSystemScope.UID_DPRSystemScope |