| Column | Data Type | Nullable | Default | Description / PK / Index |
| ProductSubcategoryID | int | not null | | Primary key for ProductSubcategory records.
PK_ProductSubcategory_ProductSubcategoryID |
| ProductCategoryID | int | not null | | Product category identification number. Foreign key to ProductCategory.ProductCategoryID.
|
| Name | Name | not null | | Subcategory description.
AK_ProductSubcategory_Name |
| rowguid | uniqueidentifier | not null | (NEWID()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_ProductSubcategory_rowguid |
| ModifiedDate | datetime | not null | (GETDATE()) | Date and time the record was last updated.
|