MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.Docket
Description: A Docket is a line item on a manifest. A Docket is generated for each recipient of a Document. (e.g. For a Package this Document goes to this 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.
alias nvarchar (40) None No An alias for the item suitable for use when referenced externally.
document_identifier numeric (19) None Yes The document to deliver. Can be null when tracking Package-level access.
recipient_identifier numeric (19) None Yes The object of the offer.

Index Clustered? Unique? Fields
PK__Docket__D112ED49646F6200 Yes Yes
UQ__Docket__8C585C04674BCEAB No Yes

No check constraints
Internal Foreign Key Constraint Affected Field Source Table
FK_Docket_document document_identifier Document
FK_Docket_recipient recipient_identifier Recipient

Primary Key as Foreign Key Constraint Affected Table Affected Field
FK_Docket_Dispatch_a Docket_Dispatch Docket_identifier
FK_EftMessage_docket EftMessage docket_identifier
FK_EmailVerifyBid_docket EmailVerificationBid pickup_identifier
FK_Manifest_Docket_b Manifest_Docket dockets_identifier

No triggers