MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.UserConfig
Description: User configuration settings.
Primary Keys: identifier
Field Type Defaults Nulls? Comments
accountLockoutEnabled tinyint None No Whether the account lockout policy is enabled.
attemptExpirationTimeNumber int None Yes The numerical component of the period at which attempts will expire.
attemptExpirationTimeUnit nvarchar (255) None Yes The time unit component of the period at which attempts will expire. Values values: MINUTES, HOURS, DAYS, WEEKS, MONTHS, YEARS.
attemptsAllowed int None No The number of failed login attempts allowed before account lockout.
lockoutExpirationTimeNumber int None Yes The numerical component of the period at which account lockout will expire.
lockoutExpirationTimeUnit nvarchar (255) None Yes The time unit component of the period at which account lockout will expire. Values values: MINUTES, HOURS, DAYS, WEEKS, MONTHS, YEARS.
lockoutExpirationEnabled tinyint None No Whether locked accounts can programmatically re-activate.
disallowUsernameCharEnabled tinyint None No Whether to limit the number of characters that are also in your username.
disallowUsernameCharLimit smallint None No The limit of characters from your username allowed.
forcePasswordChange tinyint None No Whether new actors will default to force password change.
minimumLength smallint None No Minimum length of password.
minimumLengthEnabled tinyint None No Whether passwords have a minimum lenght.
passwordExpirationTimeNumber int None Yes The numerical component of the period at which the password will expire.
passwordExpirationTimeUnit nvarchar (255) None Yes The time unit component of the period at which the password will expire. Values values: MINUTES, HOURS, DAYS, WEEKS, MONTHS, YEARS.
passwordExpirationEnabled tinyint None No Whether passwords can expire.
passwordHistoryLength smallint None No The number of old passwords to check against.
preventOldPasswords tinyint None No Whether to prevent old password reuse.
repeatCharLimit smallint None No The limit of times a character can be repeated.
repeatCharLimitEnabled tinyint None No Whether to limit the number of times a character can be repeated.
requireLowerCase tinyint None No Whether lower case characters are required.
requireNumeric tinyint None No Whether numeric characters are required.
requireSpecial tinyint None No Whether special characters are required.
requireUpperCase tinyint None No Whether upper case characters are required.
passwordPolicyEnabled tinyint None No Whether the password policy is enabled.
requireTermsOfService tinyint None No Whether new external users must agree to Terms of Service as part of account creation.
identifier numeric (19) None No Unique ID for an entry.
internalAcctExpirEnabled tinyint None No Whether internal user account expiration is enabled.
internalAcctExpirType nvarchar (255) None No Determines how internal accounts expire.
internalAcctExpirTimeNumber int None Yes The numerical component of the period at which internal accounts will expire.
internalAcctExpirTimeUnit nvarchar (255) None Yes The time unit component of the period at which internal accounts will expire. Values values: MINUTES, HOURS, DAYS, WEEKS, MONTHS, YEARS.
externalAcctExpirEnabled tinyint None No Whether external user account expiration is enabled.
externalAcctExpirType nvarchar (255) None No Determines how external accounts expire.
externalAcctExpirTimeNumber int None Yes The numerical component of the period at which external accounts will expire.
externalAcctExpirTimeUnit nvarchar (255) None Yes The time unit component of the period at which external accounts will expire. Values values: MINUTES, HOURS, DAYS, WEEKS, MONTHS, YEARS.

Index Clustered? Unique? Fields
PK__UserConf__D112ED493FC7ED36 Yes Yes

No check constraints
Internal Foreign Key Constraint Affected Field Source Table
FKBA21F30D32C87F94 identifier AbstractSingleton

No primary keys as foreign key constraints
No triggers