ARCHIVEDAPPEALMAILINGCONTENT
This table retains archived appeal mailing mail content from version 2.9 and earlier which is no longer supported. This content can be is to be downloaded and converted into HTML content for the new Altru mailing paradigm.
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| DOCUMENTFILENAME |
nvarchar(255) |
|
Default = '' |
Filename of the document associated with this package. |
| DOCUMENTFILE |
varbinary |
yes |
|
The document associated with this package. |
| DATEADDED |
datetime |
|
Default = getdate() |
Indicates the date this record was added. |
| DATECHANGED |
datetime |
|
Default = getdate() |
Indicates the date this record was last changed. |
| TS |
timestamp |
|
|
Timestamp. |
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
Foreign Keys
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_ARCHIVEDAPPEALMAILINGCONTENT_DATEADDED |
DATEADDED |
|
|
yes |
| IX_ARCHIVEDAPPEALMAILINGCONTENT_DATECHANGED |
DATECHANGED |
|
|
|
| PK_ARCHIVEDAPPEALMAILINGCONTENT |
ID |
yes |
yes |
|
Triggers