Updated: 2009-09-21

Version: Control 4.4

Table Purpose, Usage, and Notes

This table is split table with the sql_structure_-_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

You could leave a comment if you were logged in.