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.