Table BDNA_PUBLISH.dbo.DISC_DISK_PARTITIONS
Has Discovered Disk Partiions information

 Generated by
SchemaSpy
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 float 8 Disk partition Id
NAME nvarchar 512  √  null Disk partition Name eg: Disk #0, Partition #0
DESCRIPTION nvarchar 2048  √  null Disk partition description eg: Installable File System, Installable File System
BOOTPARTITION float 8  √  null Boot partition eg: 1, 0
DEVICEID nvarchar 2048  √  null Divice Id eg:Disk #0, Partition #0, Disk #13, Partition #0 etc
PRIMARYPARTITION float 8  √  null Primary partition ? eg 1 = yes, 0 = no
CAPACITY float 8  √  null Disk capacity
DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
OPERATINGSYSTEM_ID float 8  √  null
DISC_ALL_OS.OPERATINGSYSTEM_ID FK0_DISC_DISK_PARTITIONS R
Operating System Id for this disk
TASK_ID float 8
DISC_ALL_OS.TASK_ID FK0_DISC_DISK_PARTITIONS R
Task Id for this row
INVENTORY_ID float 8
DISC_ALL_OS.INVENTORY_ID FK0_DISC_DISK_PARTITIONS R
Inventory Id for this row

Analyzed at Thu Oct 04 14:29 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
DISKPARTITION_ID + TASK_ID + INVENTORY_ID Primary key Asc/Asc/Asc PK_DISC_DISK_PARTITIONS

Close relationships  within of separation: