dbo.DPRJournal
Main table of all tables which are part of synchronization journal. The table stores one entry for each synchronization run.
TableType TUsage HISTORYRows 93SizeMB 0.104
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DPRJournal | varchar(38) | no | Synchronization journal | PKUID |
CreationTime | datetime(8) | yes | Start time | |
UID_DPRProjectionConfig | varchar(38) | yes | Synchronization workflow | FKUID |
ProjectionContext | nvarchar(64) | yes | Synchronization context | |
ProjectionConfigDisplay | nvarchar(512) | yes | Synchronization workflow | |
ProjectionState | varchar(64) | yes | Projection state | |
UID_DPRSystemVariableSet | varchar(38) | yes | System variable set | FKUID |
SystemVariableSetDisplay | nvarchar(512) | yes | System variable set | |
UID_DPRProjectionStartInfo | varchar(38) | yes | Projection Startinfo | FKUID |
ProjectionStartInfoDisplay | nvarchar(512) | yes | Start configuration | |
CompletionTime | datetime(8) | yes | End time | |
CausingEntityKey | varchar(138) | yes | Object key | |
CausingEntityDisplay | nvarchar(512) | yes | Object display | |
JobId | varchar(40) | yes | Process step |
Relations
| FK | From | To |
|---|---|---|
| No FK rows in snapshot. | ||
Triggers
GEN_T12CE1957372DF9066AA75DC63 SQL_TRIGGER
GEN_T2D23028ED6A3F647D1612DD0C SQL_TRIGGER
GEN_T3CCB5FD7F8FFB1E8B6E2D3AA0 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_T1075D5062A3ACBA4E2A9D3930 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T14AEBC1170E7DFA1D8E59E034 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1716F29E0F79A90C5558E3C35 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T194D764DD05D04ABD6B610B68 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T22E3C1C02475758AB2A26E6B9 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T28C53981C6637F9091BF38DD5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2B660BFA06530D666B65386F8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2FF5E6E3C5A402E3C7B879AE5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T39F1E8AA12558B27224F1C08D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3C525F2AB326629B21A033B17 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3E2DAC7D025EBC4A821E1A46C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DPR_VJournalObjectLastEntry | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.DPR_VJournalObjectLastEntry | SQL expression dependency | dbo · UID_DPRJournal · OBJECT_OR_COLUMN |
| dbo.DPR_VJournalObjectLastEntry | SQL expression dependency | dbo · CreationTime · OBJECT_OR_COLUMN |
| dbo.DPRVSyncRunMessages | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DPRVSyncRunOverview | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_VProvBaseView | SQL expression dependency | OBJECT_OR_COLUMN |