Table BDNA_PUBLISH.dbo.DISC_WINDOWS_MONITORS
Has Discovered Windows Monitors 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
MONITOR_ID float 8 Unique monitor Id
MODEL_NAME nvarchar 512  √  null Monitor name
MANUFACTURER nvarchar 512  √  null Monitor manufacturer
MANUF_DATE nvarchar 512  √  null Monitor manufacture date
MONITOR_TYPE nvarchar 512  √  null Monitor type eg: Default Monitor, Generic PnP Monitor
PRODUCT_ID nvarchar 512  √  null Monitor product Id
HARDWARE_NUMBER nvarchar 512  √  null Monitor hardware number
EDID_VERSION nvarchar 512  √  null Monitor EDID(Extended Display Identification Data) version
PIXELS_PER_XINCH float 8  √  null Monitor PIXELS per inch X co-ordinate
PIXELS_PER_YINCH float 8  √  null Monitor PIXELS per inch Y co-ordinate
SCREEN_WIDTH float 8  √  null Monitor screen width
SCREEN_HEIGHT float 8  √  null Monitor screen height
GAMMA_VALUE nvarchar 512  √  null Monitor Gamma value
INPUT_SIGNAL nvarchar 512  √  null Monitor input signal
POWERSAVING_MGMT nvarchar 512  √  null Monitor power saving management
AVAILABILITY nvarchar 512  √  null Monitor availability
DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
OPERATINGSYSTEM_ID float 8  √  null
DISC_ALL_OS.OPERATINGSYSTEM_ID FK0_DISC_WINDOWS_MONITORS R
Operating System Id for this monitor
TASK_ID float 8
DISC_ALL_OS.TASK_ID FK0_DISC_WINDOWS_MONITORS R
Task Id for this row
INVENTORY_ID float 8
DISC_ALL_OS.INVENTORY_ID FK0_DISC_WINDOWS_MONITORS R
Inventory Id for this row

Analyzed at Thu Oct 04 14:29 PDT 2012

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

Close relationships  within of separation: