MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.Document
Description: The actual email attachments being sent.
Primary Keys: identifier
Field Type Defaults Nulls? Comments
identifier numeric - Identity None No Unique ID for an entry.
createdDate datetime None No The original creation data/time for the entry.
modifiedDate datetime None No The last modified date/time for the entry.
version numeric (19) None No The version number for the entry.
alias nvarchar (40) None No An alias for the item suitable for use when referenced externally.
purged datetime None Yes The date/time at which the item was purged.
digest nvarchar (128) None Yes The hash digest of the document.
fileChunks varbinary (MAX) None No The bit-field used to record which file-chunks have been uploaded.
fileSize numeric (38) None Yes The size of the document in bytes.
path nvarchar (256) None Yes The storage path of the document in the attachment store.
title nvarchar (256) None Yes The name of the document.
validated tinyint None Yes Whether or not a hash digest validation has been performed on the document to ensure accurate upload.

Index Clustered? Unique? Fields
PK__Document__D112ED4926DB7884 Yes Yes identifier
UQ__Document__8C585C0429B7E52F No Yes alias

No check constraints
No internal foreign key constraints
Primary Key as Foreign Key Constraint Affected Table Affected Field
FK_Docket_document Docket document_identifier
FK_EftMessage_document EftMessage document_identifier
FK_Package_Document_b Package_Document documents_identifier

No triggers

For more information, review the topics in the Contents to the left. If the Contents pane is hidden, click <--Show.

You can also search the Knowledgebase for help, or pose your question in the Globalscape User Forum. Visit the Mail Express Support Center for the most up-to-date information, to view version history, updates, and activation instructions, or to download a PDF of this user guide. For information about Globalscape, visit www.globalscape.com or follow us on Twitter.

Last modified: 07 October 2013 at 9:14:20