| 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. |
| accountInviteCapable |
tinyint |
None |
No |
If the user can send account invitations. This applies only to internal users. |
| activeToken |
nvarchar (276) |
None |
No |
Token used to ensure the uniqueness of usernames across undeleted accounts. |
| crux |
nvarchar (24) |
None |
No |
Random seed data. |
| deleted |
tinyint |
None |
No |
If the user account has been deleted. |
| displayName |
nvarchar (256) |
None |
Yes |
The user's display name. |
| dropoffCapable |
tinyint |
None |
No |
If the user can use the Drop-off Portal. This applies only to internal users. |
| emailAddress |
nvarchar (256) |
None |
No |
The user's email address. |
| enabled |
tinyint |
None |
No |
If the user account is enabled. |
| expirable |
tinyint |
None |
No |
Whether actor can expire or not. This applies only to external users. |
| forcePasswordChange |
tinyint |
None |
No |
If the user must change their password at next login. |
| kind |
nvarchar (255) |
None |
No |
The type of user account. One of Administrator, InternalAutomatic, InternalManaged, External. |
| locale |
nvarchar (256) |
None |
Yes |
The user's selected locale. |
| passwordHash |
nvarchar (88) |
None |
No |
The hashed form of the user's password. |
| replyInviteCapable |
tinyint |
None |
No |
If the user can send Reply Invite links. This applies only to internal users. |
| uploadCapable |
tinyint |
None |
No |
If the user can send files. |
| username |
nvarchar (256) |
None |
No |
The user's username. |