View netapp_model_view.ldap_client_full Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
objid bigint 19 Locally unique object identifier.
uuid varchar 255 Globally unique ID
resourceKey varchar 512
clusterId bigint 19
vserverId bigint 19
ldapClientConfig varchar 255 The name of the LDAP client configuration.
ldapServers text 65535  √  null List of LDAP Servers to use for this configuration.
servers text 65535  √  null (DEPRECATED)-List of LDAP Server IP addresses to use for this configuration.
ldapSchema varchar 255  √  null LDAP schema to use for this configuration.
ldapPort bigint 19  √  null The TCP port on the LDAP server to use for this configuration.
ldapQueryTimeout int 10  √  null Maximum time in seconds to wait for a query response from the LDAP server.
ldapMinBindLevel enum 10  √  null The minimum authentication level that can be used to authenticate with the LDAP server.
ldapMinBindLevelRaw varchar 255  √  null
ldapBindDN varchar 512  √  null The Bind Distinguished Name (DN) is the LDAP identity used during the authentication process by the clients.
ldapBaseDN varchar 512  √  null Indicates the starting point for searches within the LDAP directory tree.
ldapUserDN varchar 512  √  null The User Distinguished Name (DN), if specified, is used as the starting point in the LDAP directory tree for user lookups.
ldapGroupDN varchar 512  √  null The Group Distinguished Name (DN), if specified, is used as the starting point in the LDAP directory tree for group lookups. If not specified, group lookups will start at the base-dn.
ldapNetGroupDN varchar 512  √  null The Netgroup Distinguished Name (DN), if specified, is used as the starting point in the LDAP directory tree for netgroup lookups. If not specified, netgroup lookups will start at the base-dn.
isldapUseStartTLS bit 0  √  null This indicates if start_tls will be used over LDAP connections.
createTime bigint 19
updateTime bigint 19
objState enum 5 LIVE Internal object state

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`ldap_client`.`objid` AS `objid`,`netapp_model`.`ldap_client`.`uuid` AS `uuid`,`netapp_model`.`ldap_client`.`resourceKey` AS `resourceKey`,`netapp_model`.`ldap_client`.`clusterId` AS `clusterId`,`netapp_model`.`ldap_client`.`vserverId` AS `vserverId`,`netapp_model`.`ldap_client`.`ldapClientConfig` AS `ldapClientConfig`,`netapp_model`.`ldap_client`.`ldapServers` AS `ldapServers`,`netapp_model`.`ldap_client`.`servers` AS `servers`,`netapp_model`.`ldap_client`.`ldapSchema` AS `ldapSchema`,`netapp_model`.`ldap_client`.`ldapPort` AS `ldapPort`,`netapp_model`.`ldap_client`.`ldapQueryTimeout` AS `ldapQueryTimeout`,`netapp_model`.`ldap_client`.`ldapMinBindLevel` AS `ldapMinBindLevel`,`netapp_model`.`ldap_client`.`ldapMinBindLevelRaw` AS `ldapMinBindLevelRaw`,`netapp_model`.`ldap_client`.`ldapBindDN` AS `ldapBindDN`,`netapp_model`.`ldap_client`.`ldapBaseDN` AS `ldapBaseDN`,`netapp_model`.`ldap_client`.`ldapUserDN` AS `ldapUserDN`,`netapp_model`.`ldap_client`.`ldapGroupDN` AS `ldapGroupDN`,`netapp_model`.`ldap_client`.`ldapNetGroupDN` AS `ldapNetGroupDN`,`netapp_model`.`ldap_client`.`isldapUseStartTLS` AS `isldapUseStartTLS`,`netapp_model`.`ldap_client`.`createTime` AS `createTime`,`netapp_model`.`ldap_client`.`updateTime` AS `updateTime`,`netapp_model`.`ldap_client`.`objState` AS `objState` from `netapp_model`.`ldap_client`