MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.AccountBid
Description: An AccountBid is an invitation to create a system 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.
account_identifier numeric (19) None Yes The account created as a consequence of this invitation.
recipient_identifier numeric (19) None Yes The object of the offer.

Index Clustered? Unique? Fields
PK__AccountB__D112ED49257E0B4E Yes Yes
UQ__AccountB__8C585C04285A77F9 No Yes

No check constraints
Internal Foreign Key Constraint Affected Field Source Table
FK_AccountBid_account account_identifier Actor
FK_AccountBid_recipient recipient_identifier Recipient

Primary Key as Foreign Key Constraint Affected Table Affected Field
FK_EmailVerifyBid_accountBid EmailVerificationBid invite_identifier
FK_Manifest_AccountBid_b Manifest_AccountBid accountBids_identifier

No triggers