BDNA Data Platform 5.4 July 2017 (SQL Server)
TECHNOPEDIA_KEYWORDS - BDNA internal log 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
TECHNOPEDIA_KEYWORDS_ID numeric 20
CAT_TIER numeric 20  √  null
CAT_MANUFACTURER_ID numeric 20  √  null
CAT_KEYWORD varchar 255  √  null
CAT_PUBKEYWORDNOTLIKE varchar 255  √  null
CAT_DISPLAYNAMEKEYWORD varchar 255  √  null
CAT_DISPLAYNAMEKEYWORDNOTLIKE varchar 255  √  null
CREATE_DATE datetime 16,3  √  null
LAST_MODIFIED_DATE datetime 16,3  √  null
TO_BE_DELETED varchar 1  √  null
TO_BE_DELETED_ON datetime 16,3  √  null

Analyzed at Thu Jul 20 12:14 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
TECHNOPEDIA_KEYWORDS_ID Primary key Asc PK_TECHNOPEDIA_KEYWORDS
TECHNOPEDIA_KEYWORDS_ID + CAT_TIER + CAT_MANUFACTURER_ID + CAT_KEYWORD Must be unique Asc/Asc/Asc/Asc TECH_KEYWORDS_UNQ_IDX
Confidential and Proprietary to BDNA