EmailList (Table)

Primary Key	Field Type
ID	int

Foreign Key	Field Type	Null	Notes	Description
ClientSitesID	int		ClientSites.ID

Trigger Name	Description
TR_EmailList_CASCDE_DEL_1

Referenced by	Field
Chapters	MemberEmailListID
CONDITIONALCONTENTRECIPIENT	EMAILLISTID
ConditionList	EmailListID
Email_EmailList	EmailListID
EmailList_Subscription	EmailListID
EmailProjectAppeal_Duplicates	EmailListID
EMAILSCHEDULE_EMAILLIST	EMAILLISTID
EmailTemplate_EmailList	EmailListID
FAFEVENTEMAIL	EMAILLISTID

Field	Field Type	Notes
ClientsID	int
OwnerID	int
Deleted	bit	Default = 0
Name	nvarchar(256)
Description	nvarchar(256)
Guid	uniqueidentifier
Subscription	bit	Default = 0
Type	int	Default = 0
DataSourceID	int	Default = 1
Options	ntext
AcquiredStatus	int	Default = 0
AcquiredDate	datetime	Default = getutcdate()
AcquiredStartDate	datetime	Default = getutcdate()
AcquiredRecordCount	int
ListDataSchema	ntext
EmailDisplayNameFieldName	nvarchar(128)
EmailAddressFieldName	nvarchar(128)
UniqueKeyFieldName	nvarchar(128)
FileContents	image
UploadfileName	nvarchar(256)
UploadFileSize	int
AcquiredMsg	ntext
UploadedDataSourceID	int
Origin	tinyint
UserImportID	int
BBDMListID	nvarchar(255)
SystemList	bit	Default = 0
SITEFOLDERSID	int	Default = 0

Index Name	Field(s)	Unique	Primary	Clustered
IX_EmailList_BBDMListID	BBDMListID
IX_EmailList_GUID_OwnerID_Deleted	Guid, OwnerID, Deleted
IX_EmailList_ClientSitesID_Name	ClientSitesID, Name
PK_EmailList	ID