MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.Dispatch
Description: Dispatches are records of delivery. A record is generated whenever a recipient accesses a file or package for download. Specifically, it tracks when a Docket is accessed by a recipient.
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.
sentNotification tinyint None No Whether or not the dispatch resulted in a download notification being sent to the sender.
localAddress nvarchar (256) None Yes The IP address of the local socket endpoint.
localPort int None Yes The port number of the local socket endpoint.
remoteAddress nvarchar (256) None Yes The IP address of the remote socket endpoint.
remotePort int None Yes The port number of the remote socket endpoint.
throughDmz tinyint None No Whether the creation of this dispatch was proxied through the DMZ gateway.
userAgent nvarchar (4000) None Yes The browser user-agent string of the client the triggered the dispatch.

Index Clustered? Unique? Fields
PK__Dispatch__D112ED49609ED11C Yes Yes

No check constraints
No internal foreign key constraints
Primary Key as Foreign Key Constraint Affected Table Affected Field
FK_Docket_Dispatch_b Docket_Dispatch dispatches_identifier
FK_EftMessage_dispatch EftMessage dispatch_identifier

No triggers