BDNA Data Platform 5.4 July 2017 (Oracle)
DISC_COMPUTERSYSTEM - Computer Systems 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
COMPUTERSYSTEM_ID number 0  √  null
DISC_CS_CAT_MAP.COMPUTERSYSTEM_ID FK0_DISC_CS_CAT_MAP R
DISC_ALL_OS.OPERATINGSYSTEM_ID FK2_DISC_COMPUTERSYSTEM R
Unique Computer System ID
INVENTORY_ID number 18  √  null
DISC_CS_CAT_MAP.INVENTORY_ID FK0_DISC_CS_CAT_MAP R
MATCH_INVENTORY.INVENTORY_ID FK1_DISC_COMPUTERSYSTEM R
DISC_ALL_OS.INVENTORY_ID FK2_DISC_COMPUTERSYSTEM R
Inventory ID for this row
TASK_ID number 18  √  null
DISC_CS_CAT_MAP.TASK_ID FK0_DISC_CS_CAT_MAP R
MATCH_TASK_DET.TASK_ID FK0_DISC_COMPUTERSYSTEM R
DISC_ALL_OS.TASK_ID FK2_DISC_COMPUTERSYSTEM R
Task ID for this row
DOMAIN nvarchar2 1024  √  null Domain for this Computer System
MANUFACTURER nvarchar2 1024  √  null Manufacturer (e.g., Dell Inc., Compaq)
MODEL nvarchar2 1024  √  null Manufuacturer (e.g., Latitude D620, ProLiant BL465c G5)
HOSTNAME nvarchar2 1024  √  null Hostname for this system
DATASRC nvarchar2 100  √  null Data Source for this row (e.g., SCCM, ADDM)

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
INVENTORY_ID + TASK_ID + COMPUTERSYSTEM_ID Primary key Asc/Asc/Asc PK_DISC_COMPUTERSYSTEM These unique columns are also nullable

Close relationships  within of separation:
Confidential and Proprietary to BDNA