Information for the History

Columns

• Id (datatype: int) Required Primary Key
• IsSystem (datatype: bit) Required Primary Key
• CategoryId (datatype: int) Required Primary Key
• EntityTypeId (datatype: int) Required Primary Key
• EntityId (datatype: int) Required Primary Key
• Caption (datatype: nvarchar(200)) Required Primary Key
• RelatedEntityTypeId (datatype: int) Required Primary Key
• RelatedEntityId (datatype: int) Required Primary Key
• Guid (datatype: uniqueidentifier) Required Primary Key
• CreatedDateTime (datatype: datetime) Required Primary Key
• ModifiedDateTime (datatype: datetime) Required Primary Key
• CreatedByPersonAliasId (datatype: int) Required Primary Key
• ModifiedByPersonAliasId (datatype: int) Required Primary Key
• ForeignKey (datatype: nvarchar(100)) Required Primary Key
• ForeignGuid (datatype: uniqueidentifier) Required Primary Key
• ForeignId (datatype: int) Required Primary Key
• Verb (datatype: nvarchar(50)) Required Primary Key
• RelatedData (datatype: nvarchar(max)) Required Primary Key
• ChangeType (datatype: nvarchar(20)) Required Primary Key
• ValueName (datatype: nvarchar(250)) Required Primary Key
• NewValue (datatype: nvarchar(max)) Required Primary Key
• OldValue (datatype: nvarchar(max)) Required Primary Key
• IsSensitive (datatype: bit) Required Primary Key
• SourceOfChange (datatype: nvarchar(max)) Required Primary Key
• NewRawValue (datatype: nvarchar(250)) Required Primary Key
• OldRawValue (datatype: nvarchar(250)) Required Primary Key