Helix ALM License Server 2017.1 ERD
List of tables
Table details

NameComment
EMAILContains email addresses for license server users
EVENTContains information about events that affect the number of licenses available to users, such as adding or removing licenses from the server and users logging in and out of Perforce products
EVENTDETAILSContains information about the number of licenses in each license pool when an event occurred
EVENTTYPEContains descriptions of events in the EVENT table
EVENTUSERContains the users associated with each license event
EXTERNALAUTHContains external authentication permission descriptions
LDAPFIELDContains information about LDAP or Active Directory user fields mapped to Helix ALM License Server user fields
LICENSEContains information about licenses managed on the license server
LICENSETYPEContains license types available in the license server
LSLDAPSERVERContains information about LDAP and Active Directory servers configured on the license server
LSUSERContains information about users added to the license server
LSUSERAVATARContains user photos
MAILMSGReserved for future use
MAILRECPReserved for future use
MSGLOGContains server log data
OLDPASSWORDContains previously used passwords for a user. Used when license server options are set to prevent users from reusing passwords.
OLDUSERNAMEContains previous usernames for a user. Usernames cannot be reused.
OWNERLCKContains the current version of the license server database. Used to determine if an upgrade is required.
PHONEEMAILTYPEReserved for future use
PHONENUMContains user phone numbers
POOLContains license pool information
POOLLICENSEContains information about how many users are associated with license pools. Links the POOL and LICENSE tables.
PRODUCTNAMELists the Perforce products the license server supports
RDBMSOPTNSContains RDBMS connection information
SERVERIDContains information about the license server installation
SERVOPTNContains information about license server options
USERFIELDContains the license server user fields that LDAP or Active Directory server fields can be mapped to
USERLICENSELinks user records with assigned licenses