dbo.DPRRevisionStore

Stores the revisions of all schema types of the latest synchronizations. The revision are used to optimize the synchronization by skipping all objects which were not changed since the last synchronization.

TableType TUsage WORKRows 40SizeMB 0.056

Table relation graph

Loading table relation graph…

Columns

Name	Type	Nullable	OIM caption/commentary	Flags
`UID_DPRRevisionStore`	varchar(38)	no	Synchronization revision	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
`SchemaTypeKey`	nvarchar(1024)	no	Schema type key
`UID_ValueQBMClrType`	varchar(38)	no	CLR type of revision value	FKUID
`Value`	nvarchar(512)	yes	Value
`RevisionDate`	datetime(8)	no	Revision date
`UID_DPRSystemVariableSet`	varchar(38)	yes	Based on variable set	FKUID
`UID_DPRProjectionConfig`	varchar(38)	no	Synchronization workflow	FKUID
`ValueType`	int(4)	yes	Value type
`IsFiltered`	bit(1)	yes	Filtered

Relations

FK	From	To
DPR_RFRL2456	DPRRevisionStore.`UID_ValueQBMClrType`	QBMClrType.`UID_QBMClrType`

Triggers

GEN_T129AA6B1C7A2D7ED36935DB4D SQL_TRIGGER

GEN_T2AC60E557639AF2EA936D1437 SQL_TRIGGER

GEN_T383B4581C0E57CECEA0EC0A80 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_T39F1E8AA12558B27224F1C08D	SQL expression dependency	OBJECT_OR_COLUMN
dbo.GEN_T3C525F2AB326629B21A033B17	SQL expression dependency	OBJECT_OR_COLUMN
QBMClrType	referenced by foreign key from table	DPR_RFRL2456: DPRRevisionStore.UID_ValueQBMClrType -> QBMClrType.UID_QBMClrType