BDNA Data Platform 5.4 July 2017 (Oracle)
DISC_DISK_PARTITIONS - Disk Partitions 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
DISKPARTITION_ID number 0  √  null Disk partition ID
NAME nvarchar2 256  √  null Disk partition Name (e.g., Disk #0, Partition #0)
DESCRIPTION nvarchar2 1024  √  null Disk partition description (e.g., Installable File System, Installable File System)
BOOTPARTITION float 126  √  null Boot partition (e.g., 1, 0)
DEVICEID nvarchar2 1024  √  null Divice ID (e.g., Disk #0, Partition #0, Disk #13, Partition #0, etc.)
PRIMARYPARTITION float 126  √  null Primary partition? (e.g., 1=yes, 0=no)
CAPACITY float 126  √  null Disk capacity
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_DISK_PARTITIONS R
Operating System ID for this disk
TASK_ID number 18  √  null
DISC_ALL_OS.TASK_ID FK0_DISC_DISK_PARTITIONS R
Task ID for this row
INVENTORY_ID number 18  √  null
DISC_ALL_OS.INVENTORY_ID FK0_DISC_DISK_PARTITIONS 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 + DISKPARTITION_ID Primary key Asc/Asc/Asc PK_DISC_DISK_PARTITIONS These unique columns are also nullable

Close relationships  within of separation:
Confidential and Proprietary to BDNA