MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.EmailVerificationBid
Description: An EmailVerificationBid is a request to prove control of an email address before activating an account.
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.
expiration datetime None Yes The expiration date/time for the request. Once bid is used, this shows the activation date.
crux nvarchar (24) None No Random seed data.
displayName nvarchar (256) None Yes The pending-user's display name.
emailAddress nvarchar (256) None No The pending-user's email address.
locale nvarchar (256) None Yes The pending-user's selected locale.
passwordHash nvarchar (88) None No The hashed form of the pending-user's password.
invite_identifier numeric (19) None Yes The AccountBid for the pending account.
pickup_identifier numeric (19) None Yes The PickupBid for the pending account.
reply_identifier numeric (19) None Yes The ReplyBid for the pending account.

Index Clustered? Unique? Fields
PK__EmailVer__D112ED4920844C07 Yes Yes
UQ__EmailVer__8C585C042360B8B2 No Yes
FK_EmailVerifyBid_replyBid No No

No check constraints
Internal Foreign Key Constraint Affected Field Source Table
FK_EmailVerifyBid_accountBid invite_identifier AccountBid
FK_EmailVerifyBid_docket pickup_identifier Docket
FK_EmailVerifyBid_replyBid reply_identifier ReplyBid

No primary keys as foreign key constraints
No triggers