BDNA Data Platform 5.4 July 2017 (SQL Server)
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 numeric 20
INVENTORY_ID numeric 20
TASK_ID numeric 20
SRC_TABLE_NAME varchar 30
SRC_TABLE_DEFAULT varchar 30  √  null
SRC_COLUMN_NAME varchar 30
SRC_COLUMN_LABEL varchar 30
SRC_TABLE_LABEL varchar 30
TABLE_NAME varchar 30  √  null
TABLE_LABEL varchar 30  √  null
DYNAMIC_TYPE varchar 30
DYNAMIC_SUBTYPE varchar 30
COLUMN_NAME varchar 30  √  null
COLUMN_LABEL varchar 30  √  null
DATA_TYPE varchar 30
DATA_LENGTH numeric 20  √  null
DATA_PRECISION numeric 20  √  null
NULLABLE varchar 30
DATA_DEFAULT varchar 30  √  null
COLUMN_ORDER numeric 20
KEY_FIELD numeric 20  √  null
CREATED_BY numeric 20  √  null
CREATED_DATE date 20  √  null

Analyzed at Thu Jul 20 12:14 PDT 2017

Confidential and Proprietary to BDNA