Information for the Interaction

Columns

• Id (datatype: int) Required Primary Key
• InteractionDateTime (datatype: datetime) Required Primary Key
• Operation (datatype: nvarchar(25)) Required Primary Key
• InteractionComponentId (datatype: int) Required Primary Key
• EntityId (datatype: int) Required Primary Key
• PersonAliasId (datatype: int) Required Primary Key
• InteractionSessionId (datatype: int) Required Primary Key
• InteractionSummary (datatype: nvarchar(500)) Required Primary Key
• InteractionData (datatype: nvarchar(max)) 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
• PersonalDeviceId (datatype: int) Required Primary Key
• RelatedEntityTypeId (datatype: int) Required Primary Key
• RelatedEntityId (datatype: int) Required Primary Key
• Source (datatype: nvarchar(25)) Required Primary Key
• Medium (datatype: nvarchar(25)) Required Primary Key
• Campaign (datatype: nvarchar(50)) Required Primary Key
• Content (datatype: nvarchar(50)) Required Primary Key
• InteractionEndDateTime (datatype: datetime) Required Primary Key
• Term (datatype: nvarchar(50)) Required Primary Key
• ChannelCustom1 (datatype: nvarchar(500)) Required Primary Key
• ChannelCustom2 (datatype: nvarchar(2000)) Required Primary Key
• ChannelCustomIndexed1 (datatype: nvarchar(500)) Required Primary Key
• InteractionLength (datatype: float) Required Primary Key
• InteractionTimeToServe (datatype: float) Required Primary Key
• InteractionDateKey (datatype: int) Required Primary Key