BDNA Data Platform 5.4 July 2017 (Oracle)
MATCH_ALL_EXE - Exe information matched

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_MATCH_ALL_EXE R
Inventory ID for this row
TASK_ID number 18  √  null
MATCH_TASK_DET.TASK_ID FK1_MATCH_ALL_EXE R
Task ID for this row
CATEGORY nvarchar2 10  √  null Category (e.g., Mapped, Irrelevant, Unknown)
FILE_ID number 0  √  null File ID
FILE_NAME nvarchar2 1024  √  null Filename (e.g., AvDSGlobalCatalog.exe)
FILE_DESCRIPTION nvarchar2 2000  √  null File description (e.g., AvExtractSvr Module)
FILE_VERSION nvarchar2 512  √  null File version (e.g., 4, 0, 5, 80)
FILE_SIZE nvarchar2 64  √  null File size
COMPANY_NAME nvarchar2 1024  √  null Company name (e.g., Cisco Systems, Inc.)
PRODUCT_NAME nvarchar2 1024  √  null Product name (e.g., AvNotifier Executable, AvPostProcSvr Module)
PRODUCT_VERSION nvarchar2 512  √  null Product version (e.g., 4.0-5)
PRODUCT_LANGUAGE nvarchar2 256  √  null Product Language
REASONS nvarchar2 1024  √  null Reasons
NUM_OF_INSTANCES number 0  √  null Number of EXE instances

Analyzed at Thu Jul 20 12:13 PDT 2017

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA