Table BDNA_PUBLISH.dbo.DISC_VIDEO_CONTROLLERS
Has Discovered Video Controllers 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
VIDEOCONTROLLER_ID float 8 Video controller Id
NAME nvarchar 1024  √  null Video controller name
ADAPTERCOMPATIBILITY nvarchar 512  √  null Adapter compatibility eg:Microsoft,NVIDIA,ATI Technologies Inc.
ADAPTERDACTYPE nvarchar 512  √  null Adapter DAC Type eg:Integrated RAMDAC,Internal DAC(400MHz)
ADAPTERRAM float 8  √  null Adapter RAM
CURRENTREFRESHRATE float 8  √  null Video controller current refresh rate
CURRENTVERTICALRESOLUTION float 8  √  null Video controller current vertical resolution
DESCRIPTION nvarchar 2048  √  null Video controller description
DEVICEID nvarchar 2048  √  null Video controller device Id
DRIVERDATE datetime 16,3  √  null Video controller driver date
DRIVERVERSION nvarchar 512  √  null Video controller driver version
INSTALLEDDISPLAYDRIVERS nvarchar 2048  √  null Video controller installed display dirvers eg:nv4_disp.dll,igdumdx32.dll,igd10umd32.dll etc
VIDEOMODEDESCRIPTION nvarchar 1024  √  null Video controller video mode description eg:1440 x 900 x 4294967296 colors etc
VIDEOPROCESSOR nvarchar 1024  √  null Video controller video processor egGeForce Go 7300, MOBILITY RADEON X300 (0x5460)
DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
OPERATINGSYSTEM_ID float 8  √  null
DISC_ALL_OS.OPERATINGSYSTEM_ID FK0_DISC_VIDEO_CONTROLLERSS R
Operating System Id for this video controller
TASK_ID float 8
DISC_ALL_OS.TASK_ID FK0_DISC_VIDEO_CONTROLLERSS R
Task Id for this row
INVENTORY_ID float 8
DISC_ALL_OS.INVENTORY_ID FK0_DISC_VIDEO_CONTROLLERSS R
Inventory Id for this row

Analyzed at Thu Oct 04 14:29 PDT 2012

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

Close relationships  within of separation: