MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.EftMessage
Description: EFT message for file transfers that originally failed to send and have been rescheduled for a later delivery.
Primary Keys: identifier
Field Type Defaults Nulls? Comments
messageType nvarchar (256) None No Discriminator type for EFT message.
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.
retries int None No The number of times this message has been tried to be sent.
transferSize numeric (38) None Yes The size of the transfer in bytes.
zipFile nvarchar (256) None Yes The path to the ZIP file.
guid nvarchar (256) None Yes The path to the ZIP file.
package_identifier numeric (19) None Yes The package which is the subject of the transfer.
dispatch_identifier numeric (19) None Yes The dispatch which is the subject of the transfer.
docket_identifier numeric (19) None Yes The docket which is the subject of the transfer.
document_identifier numeric (19) None Yes The document which is the subject of the transfer.

Index Clustered? Unique? Fields
PK__EftMessa__D112ED494DF545A5 Yes Yes identifier

No check constraints
Internal Foreign Key Constraint Affected Field Source Table
FK_EftMessage_dispatch dispatch_identifier Dispatch
FK_EftMessage_docket docket_identifier Docket
FK_EftMessage_document document_identifier Document
FK_EftMessage_package package_identifier Package

No primary keys as foreign key constraints
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