Table Schema: mf

This topic describes the columns in the mf_emails table.

Column Name: The name of the column.
Data Type: The data type of the column.
Primary Key: The value is 1 if the column is part of the primary key; 0 if not.
Is Nullable: The value is 1 if the column can have a NULL value; 0 if not.
Column ID: The ID number of the column.
Comment: Text describing the column data (if available).
Reference Count: The number of other columns that have a foreign key pointing to this column. Only tables that exist in the reporting database are considered.
Reference To: The parent table and column (if there is an upward constraint). Only tables that exist in the reporting database are considered.

Column Name	Data Type	Primary Key	Is Nullable	Column ID	Reference Count	Reference To
email_guid	uniqueidentifier	1	0	1	1
company_guid	uniqueidentifier	0	0	2	0	mf_companies.company_guid
site_guid	uniqueidentifier	0	1	3	0
customer_guid	uniqueidentifier	0	1	4	0	mf_customers.customer_guid
user_guid	uniqueidentifier	0	1	5	0
attachment_guid	uniqueidentifier	0	1	6	0
email_date	datetime	0	0	7	0
email_to	varchar (256)	0	1	8	0
email_from	varchar (256)	0	1	9	0
email_cc	varchar (256)	0	1	10	0
email_bcc	varchar (256)	0	1	11	0
email_replyto	varchar (256)	0	1	12	0
email_subject	varchar (256)	0	1	13	0
email_body	varchar (max)	0	1	14	0
email_html	tinyint	0	0	15	0
email_inbound	tinyint	0	0	16	0
email_read	tinyint	0	0	17	0
email_draft	tinyint	0	0	18	0
email_sent	tinyint	0	0	19	0
email_alert	tinyint	0	0	20	0
email_flag	tinyint	0	0	21	0
email_new	tinyint	0	0	22	0
email_stock	tinyint	0	0	23	0
email_approved	tinyint	0	0	24	0
email_visible	tinyint	0	0	25	0
email_locked	tinyint	0	0	26	0
email_closed	tinyint	0	0	27	0
email_purged	tinyint	0	0	28	0
lu_dt	datetime	0	0	29	0
cr_dt	datetime	0	0	30	0
lu_guid	uniqueidentifier	0	1	31	0
cr_guid	uniqueidentifier	0	1	32	0
lu_user	varchar (50)	0	1	33	0
cr_user	varchar (50)	0	1	34	0
email_data	text	0	1	35	0

Table Schema: mf_emails