BDNA Data Platform 5.4 July 2017 (Oracle)
MATCH_EXE_MANF_KWD - Internal Technopedia table

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_EXE_KW R
Inventory ID for this row
TASK_ID number 18  √  null
MATCH_TASK_DET.TASK_ID FK1_MATCH_EXE_KW 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
FILE_DESCRIPTION nvarchar2 2000  √  null File Description
FILE_VERSION nvarchar2 512  √  null File Version
FILE_SIZE nvarchar2 64  √  null File Size
COMPANY_NAME nvarchar2 1024  √  null Manufacturer Name
PRODUCT_NAME nvarchar2 1024  √  null Product Name for this file
PRODUCT_VERSION nvarchar2 512  √  null Product Version for this file
PRODUCT_LANGUAGE nvarchar2 256  √  null Product Language for this file
CAT_KEYWORD_ID number 38  √  null Unique Keyword ID from Catalog
CAT_KEYWORD_TIER number 38  √  null Tier from Catalog
CAT_MANUFACTURER_ID number 18  √  null Manufactuer from Catalog
CAT_KEYWORD varchar2 255  √  null Keyword that matched the manufacturer from Catalog

Analyzed at Thu Jul 20 12:13 PDT 2017


Close relationships  within of separation:
Confidential and Proprietary to BDNA