Table BDNA_PUBLISH.dbo.DISC_COMPUTERSYSTEM
Has Discovered Computer Systems 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
COMPUTERSYSTEM_ID float 8
DISC_CS_CAT_MAP.COMPUTERSYSTEM_ID FK0_DISC_CS_CAT_MAP R
DISC_HOSTS.HOST_ID FK2_DISC_COMPUTERSYSTEM R
Unique Computer System Id
INVENTORY_ID float 8
DISC_CS_CAT_MAP.INVENTORY_ID FK0_DISC_CS_CAT_MAP R
DISC_HOSTS.INVENTORY_ID FK2_DISC_COMPUTERSYSTEM R
MATCH_INVENTORY.INVENTORY_ID FK1_DISC_COMPUTERSYSTEM R
Inventory Id for this row
TASK_ID float 8
DISC_CS_CAT_MAP.TASK_ID FK0_DISC_CS_CAT_MAP R
DISC_HOSTS.TASK_ID FK2_DISC_COMPUTERSYSTEM R
MATCH_TASK_DET.TASK_ID FK0_DISC_COMPUTERSYSTEM R
Task Id for this row
DOMAIN varchar 1024  √  null Domain for this Compueter System
MANUFACTURER varchar 1024  √  null Manufacturer eg:Dell Inc., Compaq
MODEL varchar 1024  √  null Manufuacturer eg: Latitude D620,ProLiant BL465c G5
HOSTNAME varchar 1024  √  null Host name for this system
DATASRC varchar 100  √  null Data Source for this row eg: SCCM, ADDM

Analyzed at Thu Oct 04 14:29 PDT 2012

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

Close relationships  within of separation: