EmailList_UserDefined

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
EmailListID	int
EmailDisplayName	nvarchar(128)	yes
EmailAddress	nvarchar(128)	yes
Enabled	bit		Default = 1
GlobalOptOut	bit		Default = 0
UpdateDate	datetime	yes
GUID	uniqueidentifier		Default = (newid())

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_EmailList_UserDefined_EmailListID	EmailListID
IX_EmailList_UserDefined_EmailAddress_EmailListID	EmailAddress, EmailListID	yes
PK_EmailList_UserDefined	ID	yes	yes	yes

Referenced by

Referenced by	Field
CONDITIONALCONTENTRECIPIENT	EMAILLIST_USERDEFINEDID