BDNA Data Platform 5.4 July 2017 (Oracle)
MATCH_PRC_DYNAMIC_METADATA - 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
TASK_ID number 18  √  null
SRC_TABLE_NAME varchar2 30  √  null
SRC_TABLE_DEFAULT varchar2 30  √  null
SRC_COLUMN_NAME varchar2 30  √  null
SRC_COLUMN_LABEL varchar2 30  √  null
SRC_TABLE_LABEL varchar2 30  √  null
TABLE_NAME varchar2 30  √  null
TABLE_LABEL varchar2 30  √  null
DYNAMIC_TYPE varchar2 30  √  null
DYNAMIC_SUBTYPE varchar2 30  √  null
COLUMN_NAME varchar2 30  √  null
COLUMN_LABEL varchar2 30  √  null
DATA_TYPE varchar2 30  √  null
DATA_LENGTH number 18  √  null
DATA_PRECISION number 18  √  null
NULLABLE varchar2 30  √  null
DATA_DEFAULT varchar2 30  √  null
COLUMN_ORDER number 18  √  null
KEY_FIELD number 18  √  null
CREATED_BY number 18  √  null
CREATED_DATE date 7  √  null

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
PROCESS_ID + INVENTORY_ID + TASK_ID + DYNAMIC_TYPE + DYNAMIC_SUBTYPE + SRC_TABLE_NAME + SRC_COLUMN_NAME Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc PDMD_PK These unique columns are also nullable
Confidential and Proprietary to BDNA