| Primary Key | Field Type | 
|---|---|
|  ID | int | 
| Field | Field Type | Null | Notes | Description | 
|---|---|---|---|---|
|  RealmID | int | |||
|  Type | int | Default = 0 | ||
|  Subject | nvarchar(255) |  | ||
|  Message | ntext |  | ||
|  Closing | nvarchar(1000) |  | ||
|  CreateDate | datetime | Default = getutcdate() | 
| Foreign Key | Field Type | Null | Notes | Description | 
|---|---|---|---|---|
|  RealmTypeID | int | Realm.TypeID | ||
|  EmailID | int | Email.ID | 
| Index Name | Field(s) | Unique | Primary | Clustered | 
|---|---|---|---|---|
|  PK_RealmEmail | ID |  |  |  | 
