About Primary Keys

The ResProdName, ResProdVer, and ResProdLangID fields are primary keys that function as a group (Group 1).The FileName and FileSize fields are primary keys that also function as a group (Group 2). For an entry to be imported into your product compliance database, it must have complete information for each item in Group 1, Group 2, or both. If one item is missing in Group 1, but Group 2 is completed (or vice versa), the line will still be imported.

When you import information into the product compliance database, all of the primary key fields for a given source and compliance type must match the same primary key fields on an imported row for the current row in your database to be updated. If one of the primary key fields does not match, a new row will be added to your compliance database.

Related Topics

Topic Link

Import Product Compliance Information into Your Database

Topic Link

View Product Compliance Results

Topic Link

About WBEM Property Names

Topic Link

About Product Compliance Database Design

Topic Link

Understanding Product Compliance Issues Overview