MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.Actor
Description: All user accounts in the system.
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.
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.
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.
lockoutAge datetime None Yes The time of account lockout else null.
passwordAge datetime None No The date/time of current password creation.
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.
termsOfServiceAgreement tinyint None No Whether user has agreed to a Terms of Service agreement.
uploadCapable tinyint None No If the user can send files.
username nvarchar (256) None No The user's username.
expirable tinyint None No Whether actor can expire or not. This applies to internal and external users.

Index Clustered? Unique? Fields
PK__Actor__D112ED492C2B08DD Yes Yes
UQ__Actor__EC3F9A4E2F077588 No Yes

No check constraints
No internal foreign key constraints
Primary Key as Foreign Key Constraint Affected Table Affected Field
FK_AccountBid_account AccountBid account_identifier
FK_Actor_FailedLoginHistory Actor_FailedLoginHistory Actor_identifier
FK_Actor_passwordHistory Actor_passwordHistory Actor_identifier
FK_AuditEvent_actor AuditEvent actor_identifier
FK_Auditor_actor Auditor actor_identifier
FK_Client_actor Client actor_identifier
FK_Email_actor Email sender_identifier
FK_Package_actor Package actor_identifier
FK_ResetPasswordBid_account ResetPasswordBid account_identifier

No triggers