BDNA Discover Publish version 7.7.2 with 201708
BDNA_HDDS - Hard Disk Drives

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
DEVICENAME varchar2 256  √  null Device Name
CONNECTIONTYPE varchar2 256  √  null Connection Type
MODEL varchar2 256  √  null Model
MANUFACTURER varchar2 256  √  null Manufacturer
CAPACITY varchar2 256  √  null Capacity
VOLUME_GROUP varchar2 256  √  null Volume Group
PHYSICALVOLUME_STATE varchar2 256  √  null Physical Volume State
SERIALNUMBER varchar2 256  √  null Serial Number
CONNECTIONLOCATION varchar2 256  √  null Connection Location
OPERATINGSYSTEM_ID number 22  √  null
BDNA_ALL_OS.OPERATINGSYSTEM_ID FKM0_BDNA_HDDS R
Operating Systems Id
HDD_ID number 22 Hard Disk Drive Id
INVENTORY_ID number 22 -1
BDNA_INVENTORY_INFO.INVENTORY_ID BDNA_HDDS0_INVENTORY_ID R
BDNA_ALL_OS.INVENTORY_ID FKM0_BDNA_HDDS R
Inventory Id

Analyzed at Wed Jul 12 12:54 CST 2017

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA