ECard

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
ViewKey	uniqueidentifier
EmailSubject	nvarchar(4000)	yes
Html	ntext
DateCreated	datetime		Default = getutcdate()
DateAccessed	datetime	yes

Foreign Keys

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

Indexes

Index Name	Fields	Unique	Primary	Clustered
IUX_ECard_ViewKey	ViewKey	yes
PK_ECard	ID	yes	yes	yes