Tables
Constraints
Columns
BDNA Data Platform 5.4 July 2017 (SQL Server)
DISC_CDROMS - CD ROMs information discovered
Related columns
Constraints
Comments
Legend
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
CDROM_ID
numeric
20
Unique CDROM ID
NAME
nvarchar
512
√
null
CDROM Name
MODEL
nvarchar
2048
√
null
CDROM Model
MANUFACTURER
nvarchar
512
√
null
CDROM Manufacturer
DRIVE
nvarchar
512
√
null
CDROM drive (e.g., E:, D:)
SERIALNUMBER
nvarchar
512
√
null
CDROM Serial Number
DATASRC
nvarchar
50
√
null
Data Source for this row (e.g., SCCM, ADDM)
OPERATINGSYSTEM_ID
numeric
20
√
null
Operating System ID
TASK_ID
numeric
20
Task ID for this row
INVENTORY_ID
numeric
20
Inventory ID for this row
Analyzed at Thu Jul 20 12:14 PDT 2017
Confidential and Proprietary to BDNA