MAILEXPRESS
| 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__D112ED4919817D66 | Yes | Yes | identifier |
| UQ__Docket__8C585C041C5DEA11 | No | Yes | alias |
| 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 |