Table BDNA_PUBLISH.dbo.DISC_HDDS
Has Discovered Hard Disc 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
HDD_ID float 8 Hard disk Id
DEVICENAME nvarchar 512  √  null Device Name eg: Disk drive \\.\PHYSICALDRIVE8
CONNECTIONTYPE nvarchar 512  √  null Connection type eg: SCSI, IDE
MODEL nvarchar 2048  √  null Model eg: SCSI\DISK VEN_EMC PROD_POWER \EMCP 0001 0002 000019010173171F, SCSI\DISK VEN_EMC PROD_POWER \EMCP 0001 0001 2_0_0_0
MANUFACTURER nvarchar 512  √  null Disk Manufcaturer
CAPACITY nvarchar 512  √  null Disk capacity
NUMPARTITIONS float 8  √  null Number of partitions on the disk
PNPDEVICEID nvarchar 2048  √  null PNP device Id
VOLUME_GROUP nvarchar 512  √  null Disk volume group
PHYSICALVOLUME_STATE nvarchar 512  √  null Disk physical volume
SERIALNUMBER nvarchar 512  √  null Disk serial number
CONNECTIONLOCATION nvarchar 512  √  null Disk connection location
DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
OPERATINGSYSTEM_ID float 8  √  null
DISC_ALL_OS.OPERATINGSYSTEM_ID FK0_DISC_HDDS R
Operating System Id for this disk
TASK_ID float 8
DISC_ALL_OS.TASK_ID FK0_DISC_HDDS R
Task Id for this row
INVENTORY_ID float 8
DISC_ALL_OS.INVENTORY_ID FK0_DISC_HDDS R
Inventory Id for this row

Analyzed at Thu Oct 04 14:29 PDT 2012

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

Close relationships  within of separation: