dbo.DPRJournalProperty
Stores the changed values of the object properties which were processed by the synchronization which has created the journal. The reporting of property changes have to be enabled in the synchronization project.
TableType TUsage HISTORYRows 2880SizeMB 1.256
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DPRJournalProperty | varchar(38) | no | Synchronization property change | PKUID |
UID_DPRJournalObject | varchar(38) | no | Synchronization change action | FKUID |
PropertyName | nvarchar(512) | no | Schema property | |
NewValueShort | nvarchar(800) | yes | Value new (short) | |
IsNewValueFull | bit(1) | yes | Large content (new) | |
NewValueFull | nvarchar(-1) | yes | Value new (full) | |
OldValueShort | nvarchar(800) | yes | Value old (short) | |
IsOldValueFull | bit(1) | yes | Large content (old) | |
OldValueFull | nvarchar(-1) | yes | Value old (full) |
Relations
| FK | From | To |
|---|---|---|
| No FK rows in snapshot. | ||
Triggers
GEN_T1825F11F08670F9849C858B3C SQL_TRIGGER
GEN_T26AC87F15A39BF5212A7E9BD6 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.DPR_FTJournalPropertySplit | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T367737095F50171BFC6A4A668 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DPR_FTJournalPropertySplit | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |