BDNA Discover Publish version 7.7.2 with 201708
BDNA_UNIX_PKGS - UNIX Packages and RPMs

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
NAME varchar2 256  √  null Name
PKGNAME varchar2 256  √  null Package Name
VENDOR varchar2 256  √  null Vendor
VERSION varchar2 256  √  null Package Version
INSTALLDATE varchar2 256  √  null Install Date
INSTALLDIRECTORY varchar2 256  √  null Install Directory
OPERATINGSYSTEM_ID number 22  √  null
BDNA_UNIX_OS.OPERATINGSYSTEM_ID FKM0_BDNA_UNIX_PKGS R
Operating Systems Id
INSTALLEDSOFTWARE_ID number 22 Installed Software Id
INVENTORY_ID number 22 -1
BDNA_INVENTORY_INFO.INVENTORY_ID BDNA_UNIX_PKGS0_INVENTORY_ID R
BDNA_UNIX_OS.INVENTORY_ID FKM0_BDNA_UNIX_PKGS R
Inventory Id

Analyzed at Wed Jul 12 12:54 CST 2017

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA