MAILEXPRESS
| 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__D112ED495F54DBD1 | Yes | Yes | identifier |
| UQ__AccountB__8C585C046231487C | No | Yes | alias |
| 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 |