MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.Package
Description: The root container for one or more deliverable files (Documents).
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.
accountInvite tinyint None No Whether or not this package includes account invitations.
chunkSize numeric (19) None No The number of bytes sent at a time.
documentCount int None No The number of Documents for the package.
expiration datetime None Yes The expiration date/time for the package, if applicable.
expiryNumber int None Yes The numerical component of the period at which package pickup will expire.
expiryTimeUnit nvarchar (255) None Yes The time unit component of the period at which package pickup will expire. Values values: MINUTES, HOURS, DAYS, WEEKS, MONTHS, YEARS.
replyInvite tinyint None No Whether or not this package includes reply invitations.
upload nvarchar (255) None No The upload state of the package. One of Initializing, InProgress, Complete, Aborted, Abandoned.
actor_identifier numeric (19) None Yes The originating user account.
client_identifier numeric (19) None Yes The originating client.
manifest_identifier numeric (19) None Yes The Manifest for the package.

Index Clustered? Unique? Fields
PK__Package__D112ED492C5F47B0 Yes Yes identifier
UQ__Package__8C585C042F3BB45B No Yes alias

No check constraints
Internal Foreign Key Constraint Affected Field Source Table
FK_Package_actor actor_identifier Actor
FK_Package_client client_identifier Client
FK_Package_manifest manifest_identifier Manifest

Primary Key as Foreign Key Constraint Affected Table Affected Field
FK_EftMessage_package EftMessage package_identifier
FK_Package_Document_a Package_Document Package_identifier
FK_ReplyBid_Package_b ReplyBid_Package uploads_identifier

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