| Primary Key | Field Type |
|---|---|
 ID |
int |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 DisplayName |
nvarchar(255) | |||
| EmailAddress |
nvarchar(255) | |||
| CreateDate |
datetime | Default = getutcdate() | ||
| UpdateDate |
datetime | Default = getutcdate() | ||
| LockedOut |
bit |  |
Default = 0 | |
| LockedDate |
datetime | |
||
| Deleted |
bit | Default = 0 | ||
| DeletedDate |
datetime | |
||
| EmailForwardingEnabled |
bit | Default = 1 | ||
| UserPageURL |
nvarchar(255) | |
||
| OnlineStatus |
int | Default = 0 | ||
| OnlineStatusPreferenceType |
int | Default = 0 | ||
| OnlineStatusUpdateDate |
datetime | |
||
| ProfileImageID |
int | Default = 0 |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 ClientUsersID |
int | |
ClientUsers.ID | |
| LockedUserID |
int | |
ClientUsers.ID | |
| DeletedUserID |
int | |
ClientUsers.ID |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_NetAccount_1 |
Deleted, LockedOut, ID, ClientUsersID, DisplayName, EmailAddress | |||
| IX_NetAccount_ID_DisplayName_Deleted |
ID, DisplayName, Deleted | |||
| IX_NetAccount_ID_DisplayName_Deleted_ClientUsersID |
ID, DisplayName, Deleted, ClientUsersID | |||
| IX_NetAccount_ID_DisplayName_LockedOut |
ID, DisplayName, LockedOut | |||
| IX_NetAccount_ID_DisplayName_OnlineStatus_Deleted |
ID, DisplayName, OnlineStatus, Deleted | |||
| IX_NetAccount_ID_DisplayName_UpdateDate_Deleted |
ID, DisplayName, UpdateDate, Deleted | |||
| PK_NetAccount |
ID | |
|
| Referenced by | Field |
|---|---|
 Message |
OwnerID |
| Message |
SenderID |
| Message |
RecipientID |
| MessageFolder |
NetAccountID |
| NetAccountRelation |
NetAccountID |
| NetAccountRelation |
RelationAccountID |
| NetAccountRelation |
BlockedID |
| NetGroup |
NetAccountID |
| NetGroupRelation |
NetAccountID |
| NetGroupRelation |
BlockedID |