MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.LdapConfigLog
Description: Auditing table for changes to corresponding with table LdapConfig.
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.
CACertificateBytes varbinary (MAX) None Yes The binary form of the trusted CA certificate.
SSLEnabled tinyint None Yes Whether or not SSL should use when communicating with the LDAP server.
authenticationMode int None Yes The type of authentication to perform when communicating with the LDAP server. One of SIMPLE_LOGIN or ANONYMOUS_LOGIN.
encPreauthUserPassword nvarchar (4000) None Yes The encrypted pre-auth account password.
ldapHost nvarchar (256) None Yes The LDAP server host.
ldapPort int None Yes The LDAP server port.
preauthUserDN nvarchar (4000) None Yes The pre-auth account username.
searchBase nvarchar (4000) None Yes The search base to use when performing a search on the LDAP server.
searchFilter nvarchar (4000) None Yes The search filter definition to use when performing a search on the LDAP server.
serviceEnabled tinyint None Yes Whether or not the LDAP functionality is enabled.

Index Clustered? Unique? Fields
PK__LdapConf__B55535B754F81446 Yes Yes

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

No primary keys as foreign key constraints
No triggers