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.
guid nvarchar (256) None Yes The path to the ZIP file.
zipFile 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.
document_identifier numeric (19) None Yes The document 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.

Index Clustered? Unique? Fields
PK__EftMessa__D112ED4918E32A3F Yes Yes

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