{$page} 



Updated: 2009-09-21



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table is split table with the [[sql_structure_-_journal_tablejournal_table|Journal Table]] and is used for ...



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 20060 - Email Activity
    * 20061 - Email Activity Template



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| EmailActivity.Attachments || text ||  ||   ||
|| EmailActivity.BCC || text ||  ||   ||
|| EmailActivity.Body || text ||  ||   ||
|| EmailActivity.CC || text ||  ||   ||
|| EmailActivity.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| EmailActivity.ID || int || Primary Key for the Table ||   ||
|| EmailActivity.IsActive || bit || Not Used for This Table ||   ||
|| EmailActivity.IsSystem || bit || Used to Mark Required Records ||   ||
|| EmailActivity.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| EmailActivity.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| EmailActivity.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| EmailActivity.Recipients || text ||  ||   ||
|| EmailActivity.Sender || nvarchar(50) ||  ||   ||
|| EmailActivity.SeqID || int ||  ||   ||
|| EmailActivity.StoreID || int || Not Used. ||   ||
|| EmailActivity.Subject || nvarchar(50) ||  ||   ||
Related Tables 



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]