Table BDNA_PUBLISH.dbo.MATCH_INVENTORY
Has Inventory information

 Generated by
SchemaSpy
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 float 8
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_HOSTS.INVENTORY_ID FK1_DISC_HOSTS R
DISC_OS_CAT_MAP.INVENTORY_ID FK1_DISC_OS_CAT_MAP R
MATCH_ALL_ADDREMOVE.INVENTORY_ID FK0_MATCH_ALL_ADDREMOVE R
MATCH_ALL_EXE.INVENTORY_ID FK0_MATCH_ALL_EXE R
MATCH_HOST_HW_PROD_MODEL.INVENTORY_ID FK0_MATCH_HOST_HW_PROD_MODEL R
MATCH_HOST_SW_PROD.INVENTORY_ID FK7_MATCH_HOST_SW_PROD R
MATCH_HOST_SW_PROD_DET.INVENTORY_ID FK7_MATCH_HOST_SW_PROD_DET R
MATCH_SOFTWARE_METERING.INVENTORY_ID FK5_MATCH_SOFTWARE_METERING R
MATCH_TASK_DET.INVENTORY_ID FK0_MATCH_TASK_DET R
Inventory Id
INVENTORY_START_DATE datetime 16,3  √  null Inventory start date
INVENTORY_END_DATE datetime 16,3  √  null Inventory end date
INVENTORY_NAME varchar 256  √  null Inventory name
COMPANY_ID float 8  √  null Inventory company Id
COMPANY_NAME varchar 256  √  null Inventory company name

Analyzed at Thu Oct 04 14:29 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
INVENTORY_ID Primary key Asc PK_MATCH_INVENTORY

Close relationships  within of separation: