BDNA Discover Publish version 7.7.2 with 201708
BDNA_CAT_TAXONOMY2012 - New Product Categories

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
BDNA_CAT_TAXCATSOURCE.TAX2012_ID FKM1_BDNACATTAXCATSO R
Id
LABEL varchar2 256 Name
CAT2012_LABEL1 varchar2 256  √  null Category 1
CAT2012_LABEL2 varchar2 256  √  null Category 2
SOFTWARE_HARDWARE varchar2 256  √  null Software Or Hardware
DESCRIPTION varchar2 256  √  null Description
INVENTORY_ID number 22 -1
BDNA_CAT_TAXCATSOURCE.INVENTORY_ID FKM1_BDNACATTAXCATSO R
BDNA_INVENTORY_INFO.INVENTORY_ID BDNACATTAXONOMY20_INVENTORY_ID 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_TAXONOMY2012

Close relationships  within of separation:
Confidential and Proprietary to BDNA