EmailProject
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ClientsID | int | yes | ||
| OwnerID | int | yes | ||
| Type | smallint | yes | ||
| Deleted | bit | Default = 0 | ||
| FolderID | int | yes | Default = 0 | |
| Guid | uniqueidentifier | yes | ||
| Description | nvarchar(256) | yes | ||
| Name | nvarchar(50) | yes |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ClientSitesID | int | yes | ClientSites.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_EmailProject_ClientSitesID_Name | ClientSitesID, Name | yes | ||
| PK_EmailProjects | ID | yes | yes | yes |
Referenced by
| Referenced by | Field |
|---|---|
| EmailProjectAppeal | EmailProjectID |