BDNA Data Platform 5.4 July 2017 (Oracle)
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 number 18 NULL
CREATE_DATE date 7  √  NULL
LAST_MODIFIED_DATE date 7  √  NULL
CAT_TIER number 22  √  NULL
CAT_MANUFACTURER_ID number 18  √  NULL
CAT_KEYWORD varchar2 255  √  NULL
CAT_PUBKEYWORDNOTLIKE varchar2 255  √  NULL
CAT_DISPLAYNAMEKEYWORD varchar2 255  √  NULL
CAT_DISPLAYNAMEKEYWORDNOTLIKE varchar2 255  √  NULL
TO_BE_DELETED varchar2 1  √  NULL
TO_BE_DELETED_ON date 7  √  NULL

Analyzed at Thu Jul 20 12:13 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