Information for the AttributeValueHistorical

Columns

• Id (datatype: int) Required Primary Key
• AttributeValueId (datatype: int) Required Primary Key
• Value (datatype: nvarchar(max)) Required Primary Key
• ValueFormatted (datatype: nvarchar(max)) Required Primary Key
• ValueAsNumeric (datatype: decimal(18, 2)) Required Primary Key
• ValueAsDateTime (datatype: datetime) Required Primary Key
• ValueAsBoolean (datatype: bit) Required Primary Key
• ValueAsPersonId (datatype: int) Required Primary Key
• EffectiveDateTime (datatype: datetime) Required Primary Key
• ExpireDateTime (datatype: datetime) Required Primary Key
• CurrentRowIndicator (datatype: bit) 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
• Guid (datatype: uniqueidentifier) Required Primary Key
• ForeignId (datatype: int) Required Primary Key
• ForeignGuid (datatype: uniqueidentifier) Required Primary Key
• ForeignKey (datatype: nvarchar(100)) Required Primary Key