MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.ReplyBid
Description: A ReplyBid is an invitation to upload files.
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.
forAll tinyint None No Whether this is a reply to all recipients offer, or just a reply to sender offer.
recipient_identifier numeric (19) None Yes The object of the offer.

Index Clustered? Unique? Fields
PK__ReplyBid__D112ED4915D1B36A Yes Yes
UQ__ReplyBid__8C585C0418AE2015 No Yes

No check constraints
Internal Foreign Key Constraint Affected Field Source Table
FK_ReplyBid_recipient recipient_identifier Recipient

Primary Key as Foreign Key Constraint Affected Table Affected Field
FK_EmailVerifyBid_replyBid EmailVerificationBid reply_identifier
FK_Manifest_ReplyBid_b Manifest_ReplyBid replyBids_identifier
FK_ReplyBid_Package_a ReplyBid_Package ReplyBid_identifier

No triggers