BDNA Data Platform 5.4 July 2017 (Oracle)
DISC_MISSING_HOSTS - Information about hosts that were not normalized

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
MATCH_INVENTORY.INVENTORY_ID FK0_DISC_MISS_HOSTS R
Inventory ID for this row
TASK_ID number 18  √  null
MATCH_TASK_DET.TASK_ID FK1_DISC_MISS_HOSTS R
Task ID for this row
HOST_ID number 0  √  null Host ID that is not normalized
AD_SITE nvarchar2 1024  √  null AD_SITE for the host ID
USER_DOMAIN nvarchar2 1024  √  null USER_DOMAIN for the host ID
USER_NAME nvarchar2 1024  √  null USER_NAME for the host ID
NAME nvarchar2 1024  √  null NAME of the host ID
DOMAIN nvarchar2 1024  √  null DOMAIN for the host ID
ACTIVE nvarchar2 1024  √  null Is the host ID active? (e.g., 1=yes, 0=no)
OBSOLETE nvarchar2 1024  √  null Is the host ID OBSOLETE? (e.g., 1=yes, 0=no)
REASON nvarchar2 1024  √  null Reason why this host is not normalized

Analyzed at Thu Jul 20 12:13 PDT 2017

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA