BDNA Discover Publish version 7.7.0 with 201605 Sequence
BDNA_CITRIXLICENSEINV - Citrix License Inventory

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_ID number 22  √  null
BDNA_ALL_OS.OPERATINGSYSTEM_ID FKM0_BDNACITRIXLICEN R
Operating Systems Id
APPLICATION_ID number 22  √  null
BDNA_FP_APPS.APPLICATION_ID FKM1_BDNACITRIXLICEN R
Application Id
PRODUCT varchar2 256  √  null Licensed Product
MODEL varchar2 256  √  null Model
LICENSETYPE varchar2 256  √  null License Type
NUMOFLICENSE varchar2 256  √  null Number of Licenses
ISSUEDDATE varchar2 256  √  null Issued Date
STARTDATE varchar2 256  √  null Start Date
EXPIRATIONDATE varchar2 256  √  null Expiration Date
LICENSEFILEDIR varchar2 4000  √  null License File Directory
LICENSEINVENTORY_ID number 22 License Inventory Id
INVENTORY_ID number 22 -1
BDNA_INVENTORY_INFO.INVENTORY_ID BDNACITRIXLICENSE_INVENTORY_ID R
BDNA_FP_APPS.INVENTORY_ID FKM1_BDNACITRIXLICEN R
BDNA_ALL_OS.INVENTORY_ID FKM0_BDNACITRIXLICEN R
Inventory Id

Analyzed at Sat Mar 05 19:14 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
INVENTORY_ID + LICENSEINVENTORY_ID Primary key Asc/Asc PK_BDNA_CITRIXLICENSEINV

Close relationships  within of separation:
Confidential and Proprietary to BDNA