BDNA Data Platform 5.4 July 2017 (Oracle)
DISC_VIDEO_CONTROLLERS - Video Controllers 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
VIDEOCONTROLLER_ID number 0  √  null Video controller ID
NAME nvarchar2 512  √  null Video controller name
ADAPTERCOMPATIBILITY nvarchar2 256  √  null Adapter compatibility (e.g., Microsoft, NVIDIA, ATI Technologies Inc.)
ADAPTERDACTYPE nvarchar2 256  √  null Adapter DAC Type (e.g., Integrated RAMDAC, Internal DAC-400 MHz)
ADAPTERRAM float 126  √  null Adapter RAM
CURRENTREFRESHRATE float 126  √  null Video controller current refresh rate
CURRENTVERTICALRESOLUTION float 126  √  null Video controller current vertical resolution
DESCRIPTION nvarchar2 1024  √  null Video controller description
DEVICEID nvarchar2 1024  √  null Video controller device ID
DRIVERDATE date 7  √  null Video controller driver date
DRIVERVERSION nvarchar2 256  √  null Video controller driver version
INSTALLEDDISPLAYDRIVERS nvarchar2 1024  √  null Video controller installed display dirvers (e.g., nv4_disp.dll, igdumdx32.dll, igd10umd32.dll, etc.)
VIDEOMODEDESCRIPTION nvarchar2 512  √  null Video controller video mode description (e.g., 1440 x 900 x 4294967296 colors, etc.)
VIDEOPROCESSOR nvarchar2 512  √  null Video controller video processor (e.g., GeForce Go 7300, MOBILITY RADEON X300-0x5460)
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_VIDEO_CONTROLLERSS R
Operating System ID for this video controller
TASK_ID number 18  √  null
DISC_ALL_OS.TASK_ID FK0_DISC_VIDEO_CONTROLLERSS R
Task ID for this row
INVENTORY_ID number 18  √  null
DISC_ALL_OS.INVENTORY_ID FK0_DISC_VIDEO_CONTROLLERSS 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 + VIDEOCONTROLLER_ID Primary key Asc/Asc/Asc PK_DISC_VIDEO_CONTROLLERS These unique columns are also nullable

Close relationships  within of separation:
Confidential and Proprietary to BDNA