Table BDNA_PUBLISH.dbo.MATCH_SOFTWARE_METERING
Has Matched Software Metering 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
ID float 8 Unique sofware metering Id
HOST_ID float 8  √  null
DISC_HOSTS.HOST_ID FK6_MATCH_SOFTWARE_METERING R
Host Id for metering data
TASK_ID float 8
DISC_HOSTS.TASK_ID FK6_MATCH_SOFTWARE_METERING R
MATCH_TASK_DET.TASK_ID FK4_MATCH_SOFTWARE_METERING R
Task Id for this row
INVENTORY_ID float 8
DISC_HOSTS.INVENTORY_ID FK6_MATCH_SOFTWARE_METERING R
MATCH_INVENTORY.INVENTORY_ID FK5_MATCH_SOFTWARE_METERING R
Inventory Id for this row
HOSTNAME nvarchar 2048  √  null Host name for metering data
PUBLISHER nvarchar 4000  √  null Publihser for metering data eg: Adobe Systems, Microsoft
PRODUCT_NAME nvarchar 4000  √  null Product name for metering data eg: Dreamweaver, Access
PRODUCT_FAMILY nvarchar 510  √  null Product family for metering data eg: Creative, Office
VERSION nvarchar 128  √  null Product version for metering data
EDITION nvarchar 4000  √  null Product edition for metering data
NUMBER_OF_MINUTES float 8  √  null Number of minutes
USAGE_MONTH char 3  √  null usage month eg: Oct, Nov
USAGE_MONTH_N float 8  √  null usage month number eg: 10, 11
USAGE_YEAR float 8  √  null usage year eg: 2008, 2010
CAT_PUBLISHER_ID float 8  √  null publisher Id from catalog
CAT_PRODUCT_ID float 8  √  null product Id from catalog
CAT_VERSION_ID float 8  √  null version Id from catalog
CAT_VERSION_GROUP nvarchar 128  √  null version group Id from catalog
CAT_EDITION_ID float 8  √  null edition Id from catalog
CAT_RELEASE_ID float 8  √  null release Id from catalog
DISCOVERED_INSTALLDATE datetime 16,3  √  null discovered installed date
DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM

Analyzed at Thu Oct 04 14:29 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
ID + TASK_ID + INVENTORY_ID Primary key Asc/Asc/Asc PK_MATCH_SOFTWARE_METERING
INVENTORY_ID + HOST_ID Performance Asc/Asc REP_IDX__dta_index_MATCH_SOFTWARE_METERING_8_1269579561__K4_K2_6_7_8_9_10_11_12_13_14_15_16_17_18

Close relationships  within of separation: