BDNA Data Platform 5.4 July 2017 (Oracle)
MATCH_PRC_SETTINGS - 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
PROCESS_ID number 18  √  null
INVENTORY_ID number 18  √  null
PRC_TYPE varchar2 100  √  null
PRC_NAME varchar2 100  √  null
PRC_KEY varchar2 100  √  null
PRC_VALUE varchar2 1000  √  null

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
PROCESS_ID + INVENTORY_ID + PRC_TYPE + PRC_NAME + PRC_KEY Primary key Asc/Asc/Asc/Asc/Asc PRC_SETTINGS_PK These unique columns are also nullable
Confidential and Proprietary to BDNA