MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.UserConfigLog
Description: Auditing table for changes to corresponding with table UserConfig.
Primary Keys: identifier
logNumber
Field Type Defaults Nulls? Comments
identifier numeric (19) None No Unique ID for an entry.
logNumber numeric (19) None No Audit log identifier.
accountLockoutEnabled tinyint None Yes 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 Yes 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 Yes Whether locked accounts can programmatically re-activate.
disallowUsernameCharEnabled tinyint None Yes Whether to limit the number of characters that are also in your username.
disallowUsernameCharLimit smallint None Yes The limit of characters from your username allowed.
forcePasswordChange tinyint None Yes Whether new actors will default to force password change.
minimumLength smallint None Yes Minimum length of password.
minimumLengthEnabled tinyint None Yes 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 Yes Whether passwords can expire.
passwordHistoryLength smallint None Yes The number of old passwords to check against.
preventOldPasswords tinyint None Yes Whether to prevent old password reuse.
repeatCharLimit smallint None Yes The limit of times a character can be repeated.
repeatCharLimitEnabled tinyint None Yes Whether to limit the number of times a character can be repeated.
requireLowerCase tinyint None Yes Whether lower case characters are required.
requireNumeric tinyint None Yes Whether numeric characters are required.
requireSpecial tinyint None Yes Whether special characters are required.
requireUpperCase tinyint None Yes Whether upper case characters are required.
passwordPolicyEnabled tinyint None Yes Whether the password policy is enabled.
requireTermsOfService tinyint None Yes Whether new external users must agree to Terms of Service as part of account creation.
internalAcctExpirEnabled tinyint None Yes Whether internal user account expiration is enabled.
internalAcctExpirType nvarchar (255) None Yes 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 Yes Whether external user account expiration is enabled.
externalAcctExpirType nvarchar (255) None Yes 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__B55535B743987E1A Yes Yes

No check constraints
Internal Foreign Key Constraint Affected Field Source Table
FK74BC40F7D247948F identifier AbstractSingletonLog
FK74BC40F7D247948F logNumber AbstractSingletonLog

No primary keys as foreign key constraints
No triggers