BDNA Discover Publish version 7.7.2 with 201708
BDNA_CAT_TAXCATSOURCE - Taxonomy to Catalog Source Mapping

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
ID number 22 id
SOURCE_CAT varchar2 256  √  null source_cat
TAX2012_ID number 22  √  null
BDNA_CAT_TAXONOMY2012.ID FKM1_BDNACATTAXCATSO R
tax2012_id
CATSOURCE_ID number 22  √  null
BDNA_CAT_CATEGORYSOURCE.ID FKM0_BDNACATTAXCATSO R
catsource_id
INVENTORY_ID number 22 -1
BDNA_INVENTORY_INFO.INVENTORY_ID BDNACATTAXCATSOUR_INVENTORY_ID R
BDNA_CAT_TAXONOMY2012.INVENTORY_ID FKM1_BDNACATTAXCATSO R
BDNA_CAT_CATEGORYSOURCE.INVENTORY_ID FKM0_BDNACATTAXCATSO R
Inventory Id

Analyzed at Wed Jul 12 12:54 CST 2017

Indexes:
Column(s) Type Sort Constraint Name
ID + INVENTORY_ID Primary key Asc/Asc PK_BDNA_CAT_TAXCATSOURCE

Close relationships  within of separation:
Confidential and Proprietary to BDNA