MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.Docket_Dispatch
Description: The list of Dispatches corresponding to the Docket. (e.g. the records of download).
Primary Keys: Docket_identifier
dispatches_identifier
Field Type Defaults Nulls? Comments
Docket_identifier numeric (19) None No ID to map back to the 'Docket' table.
dispatches_identifier numeric (19) None No An entry in the collection.

Index Clustered? Unique? Fields
PK__Docket_D__3AE922696B1C5F8F Yes Yes
UQ__Docket_D__8F6E6FCC6DF8CC3A No Yes

No check constraints
Internal Foreign Key Constraint Affected Field Source Table
FK_Docket_Dispatch_a Docket_identifier Docket
FK_Docket_Dispatch_b dispatches_identifier Dispatch

No primary keys as foreign key constraints
No triggers