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.
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.
locale nvarchar (256) None Yes The pending-user's selected locale.

Index Clustered? Unique? Fields
PK__EmailVer__D112ED495596676D Yes Yes identifier
UQ__EmailVer__8C585C045872D418 No Yes alias

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

No primary keys as foreign key constraints
No triggers

For more information, review the topics in the Contents to the left. If the Contents pane is hidden, click <--Show.

You can also search the Knowledgebase for help, or pose your question in the Globalscape User Forum. Visit the Mail Express Support Center for the most up-to-date information, to view version history, updates, and activation instructions, or to download a PDF of this user guide. For information about Globalscape, visit www.globalscape.com or follow us on Twitter.

Last modified: 07 October 2013 at 9:14:20