BDNA Data Platform 5.4 July 2017 (Oracle)
MATCH_INVENTORY - Inventory metadata information matched

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
INVENTORY_ID number 18  √  null
DISC_ALL_OS.INVENTORY_ID FK1_DISC_ALL_OS R
DISC_COMPUTERSYSTEM.INVENTORY_ID FK1_DISC_COMPUTERSYSTEM R
DISC_CS_CAT_MAP.INVENTORY_ID FK2_DISC_CS_CAT_MAP R
DISC_DEDUPING_STATS.INVENTORY_ID FK0_DISC_DEDUP_STATS R
DISC_EXTRACTED_RECORDS_STATS.INVENTORY_ID FK0_DISC_EXT_REC_STATS R
DISC_HOSTS.INVENTORY_ID FK1_DISC_HOSTS R
DISC_MISSING_HOSTS.INVENTORY_ID FK0_DISC_MISS_HOSTS R
DISC_OS_CAT_MAP.INVENTORY_ID FK1_DISC_OS_CAT_MAP R
DISC_PUBLISHED_RECORDS_STATS.INVENTORY_ID FK0_DISC_PUB_REC_STATS R
MATCH_ADDREMOVE_MANF_KWD.INVENTORY_ID FK0_MATCH_ALL_ADDRM_KW R
MATCH_ADDREMOVE_MANF_STAT_DET.INVENTORY_ID FK0_MATCH_ADDRM_STATS_DET R
MATCH_ADDREMOVE_MANF_STAT_SUMM.INVENTORY_ID FK0_MATCH_ADDRM_STATS_SUM R
MATCH_ADDREMOVE_TIER_STAT_SUMM.INVENTORY_ID FK0_MATCH_ADDRM_TSTATS_SUM R
MATCH_ALL_ADDREMOVE.INVENTORY_ID FK0_MATCH_ALL_ADDREMOVE R
MATCH_ALL_EXE.INVENTORY_ID FK0_MATCH_ALL_EXE R
MATCH_EXE_MANF_KWD.INVENTORY_ID FK0_MATCH_EXE_KW R
MATCH_EXE_MANF_STAT_DET.INVENTORY_ID FK0_MATCH_EXE_ST_DET R
MATCH_EXE_MANF_STAT_SUMM.INVENTORY_ID FK0_MATCH_EXE_ST_SUM R
MATCH_EXE_TIER_STAT_SUMM.INVENTORY_ID FK0_MATCH_EXE_TST_SUM R
MATCH_HOST_HW_PROD_MODEL.INVENTORY_ID FK0_MATCH_HOST_HW_PROD_MODEL R
MATCH_SOFTWARE_METERING.INVENTORY_ID FK5_MATCH_SOFTWARE_METERING R
MATCH_STATS_DETAIL.INVENTORY_ID FK0_MATCH_STATS_DETAIL R
Inventory ID
PROCESS_ID number 18  √  null Process Id
INVENTORY_START_DATE date 7  √  null Inventory start date
INVENTORY_END_DATE date 7  √  null Inventory end date
INVENTORY_NAME varchar2 256  √  null Inventory name
COMPANY_ID number 0  √  null Inventory company ID
COMPANY_NAME varchar2 256  √  null Inventory company name
ORIG_PROCESS_ID number 18  √  null Original process Id in case of combined task

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
INVENTORY_ID Primary key Asc PK_MATCH_INVENTORY This unique column is also nullable

Close relationships  within of separation:
Confidential and Proprietary to BDNA