BDNA Discover Publish version 7.7.0 with 201605 Sequence
BDNA_FLEXLM_LICENSES - All FlexLM Licenses

Legend:
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
OPERATINGSYSTEM_LABEL varchar2 256  √  null Hostname
OPERATINGSYSTEM_TYPE number 22  √  null
BDNA_TYPES.TYPE_ID BDNAFLEXLMLICEN_OST R
OS Type
LICENSESERVERNAME varchar2 4000  √  null License Server
LICENSEHOST varchar2 4000  √  null License Host
LICENSEUSAGE_TYPE number 22  √  null
BDNA_TYPES.TYPE_ID BDNAFLEXLMLICEN_LUT R
License Usage Information Type
MANUFACTURER varchar2 256  √  null Application Manufacturer
VERSION varchar2 256  √  null Application Version
LICENSEDPRODUCTNAME varchar2 4000  √  null Licensed Product Name
LICENSEDFEATURENAME varchar2 4000  √  null Licensed Feature Name
LICENSEUSAGE_LABEL varchar2 1024  √  null License Usage Information Label
LICENSESINUSE varchar2 4000  √  null Licenses In Use
TOTALLICENSESISSUED varchar2 4000  √  null Licenses Issued
OSCOMPUTERNAME varchar2 256  √  null OS Computer Name
NUMCPUS number 22  √  null Number of CPUs
LICENSEUSAGE_ID number 22 License Usage Information Id
FLEXLMLICENSESERVER_ID number 22 FlexLM License Servers Id
OPERATINGSYSTEM_ID number 22  √  null
BDNA_ALL_OS.OPERATINGSYSTEM_ID FKM0_BDNAFLEXLMLICEN R
Operating Systems Id
INVENTORY_ID number 22 -1
BDNA_INVENTORY_INFO.INVENTORY_ID BDNAFLEXLMLICENSE_INVENTORY_ID R
BDNA_ALL_OS.INVENTORY_ID FKM0_BDNAFLEXLMLICEN R
Inventory Id

Analyzed at Sat Mar 05 19:14 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
FLEXLMLICENSESERVER_ID + INVENTORY_ID + LICENSEUSAGE_ID Primary key Asc/Asc/Asc PK_BDNA_FLEXLM_LICENSES

Close relationships  within of separation:
Confidential and Proprietary to BDNA