BDNA Data Platform 5.4 July 2017 (Oracle)
DISC_HDDS - Hard Disc information discovered

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
HDD_ID number 0  √  null Hard disk ID
DEVICENAME nvarchar2 256  √  null Device Name (e.g., Disk drive \\. \PHYSICALDRIVE8)
CONNECTIONTYPE nvarchar2 256  √  null Connection type (e.g., SCSI, IDE)
MODEL nvarchar2 1024  √  null Model (e.g., SCSI\DISK VEN_EMC PROD_POWER \EMCP 0001 0002 000019010173171F, SCSI\DISK VEN_EMC PROD_POWER \EMCP 0001 0001 2_0_0_0)
MANUFACTURER nvarchar2 256  √  null Disk Manufcaturer
CAPACITY nvarchar2 256  √  null Disk capacity
NUMPARTITIONS float 126  √  null Number of partitions on the disk
PNPDEVICEID nvarchar2 1024  √  null PNP device ID
VOLUME_GROUP nvarchar2 256  √  null Disk volume group
PHYSICALVOLUME_STATE nvarchar2 256  √  null Disk physical volume
SERIALNUMBER nvarchar2 256  √  null Disk serial number
CONNECTIONLOCATION nvarchar2 256  √  null Disk connection location
DATASRC nvarchar2 25  √  null Data Source for this row (e.g., SCCM, ADDM)
OPERATINGSYSTEM_ID number 0  √  null
DISC_ALL_OS.OPERATINGSYSTEM_ID FK0_DISC_HDDS R
Operating System ID for this disk
TASK_ID number 18  √  null
DISC_ALL_OS.TASK_ID FK0_DISC_HDDS R
Task ID for this row
INVENTORY_ID number 18  √  null
DISC_ALL_OS.INVENTORY_ID FK0_DISC_HDDS R
Inventory ID for this row

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
INVENTORY_ID + TASK_ID + HDD_ID Primary key Asc/Asc/Asc PK_DISC_HDDS These unique columns are also nullable

Close relationships  within of separation:
Confidential and Proprietary to BDNA