BDNA Data Platform 5.4 July 2017 (Oracle)
DISC_GUID - GUID 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
INVENTORY_ID number 18  √  null Inventory ID for this row
TASK_ID number 18  √  null Task ID for this row
HOST_ID number 0  √  null Host ID
GUID varchar2 1024  √  null GUID for the host

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
TASK_ID + INVENTORY_ID + HOST_ID Primary key Asc/Asc/Asc PK_DISC_GUID These unique columns are also nullable
GUID + TASK_ID Performance Asc/Asc DISC_GUID_GID  
HOST_ID + TASK_ID Performance Asc/Asc DISC_GUID_HOST_ID  
Confidential and Proprietary to BDNA