MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.Manifest
Description: The shipping label for a Package that tracks the sender, receivers, subject, etc.
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.
crux nvarchar (24) None No Random seed data.
locale nvarchar (256) None Yes The package-level locale.
notifyOnAccess tinyint None No Whether or not the sender should be notified of downloads.
origin nvarchar (255) None No The module used to create the package; one of Internal, External, or Client.
passwordHash nvarchar (88) None Yes The hashed form of the password, if applicable.
requirePickupAuth tinyint None No Whether or not a recipient has to authenticate to download a file.
senderAddress nvarchar (256) None No The RFC822 address of the sender.
senderPersonal nvarchar (256) None Yes The RFC822 personal name of 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.
subject nvarchar (256) None No The email subject.
throughDmz tinyint None No Whether the creation of this manifest was proxied through the DMZ gateway.

Index Clustered? Unique? Fields
PK__Manifest__D112ED4968FF0CF3 Yes Yes

No check constraints
No internal foreign key constraints
Primary Key as Foreign Key Constraint Affected Table Affected Field
FK_Manifest_AccountBid_a Manifest_AccountBid Manifest_identifier
FK_Manifest_Docket_a Manifest_Docket Manifest_identifier
FK_Manifest_Recipient_a Manifest_Recipient Manifest_identifier
FK_Manifest_ReplyBid_a Manifest_ReplyBid Manifest_identifier
FK_Package_manifest Package manifest_identifier

No triggers