BDNA Data Platform 5.4 July 2017 (Oracle)
DISC_MONITORS - Windows Monitors 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
MONITOR_ID number 0  √  null Unique monitor ID
MODEL_NAME nvarchar2 256  √  null Monitor name
MANUFACTURER nvarchar2 256  √  null Monitor manufacturer
MANUF_DATE nvarchar2 256  √  null Monitor manufacture date
MONITOR_TYPE nvarchar2 256  √  null Monitor type (e.g., Default Monitor, Generic PnP Monitor)
PRODUCT_ID nvarchar2 256  √  null Monitor product ID
HARDWARE_NUMBER nvarchar2 256  √  null Monitor hardware number
EDID_VERSION nvarchar2 256  √  null Monitor EDID (Extended Display Identification Data) version
PIXELS_PER_XINCH float 126  √  null Monitor PIXELS per inch X co-ordinate
PIXELS_PER_YINCH float 126  √  null Monitor PIXELS per inch Y co-ordinate
SCREEN_WIDTH float 126  √  null Monitor screen width
SCREEN_HEIGHT float 126  √  null Monitor screen height
GAMMA_VALUE nvarchar2 256  √  null Monitor Gamma value
INPUT_SIGNAL nvarchar2 256  √  null Monitor input signal
POWERSAVING_MGMT nvarchar2 256  √  null Monitor power saving management
AVAILABILITY nvarchar2 256  √  null Monitor availability
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_MONITORS R
Operating System ID for this monitor
TASK_ID number 18  √  null
DISC_ALL_OS.TASK_ID FK0_DISC_MONITORS R
Task ID for this row
INVENTORY_ID number 18  √  null
DISC_ALL_OS.INVENTORY_ID FK0_DISC_MONITORS 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 + MONITOR_ID Primary key Asc/Asc/Asc PK_DISC_MONITORS These unique columns are also nullable

Close relationships  within of separation:
Confidential and Proprietary to BDNA