RealmEmail

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
RealmID	int
Type	int		Default = 0
Subject	nvarchar(255)	yes
Message	ntext	yes
Closing	nvarchar(1000)	yes
CreateDate	datetime		Default = getutcdate()

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
RealmTypeID	int		Realm.TypeID
EmailID	int		Email.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_RealmEmail	ID	yes	yes	yes