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.
type nvarchar (255) None Yes None
DTYPE nvarchar (31) None No The type of the document.

Index Clustered? Unique? Fields
PK__Document__D112ED4971C95D1E Yes Yes
UQ__Document__8C585C0474A5C9C9 No Yes

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