AdventureWorks
| Table Name: | Production.ProductSubcategory |
| Description: | Product subcategories. See ProductCategory table. |
| Primary Keys: | ProductSubcategoryID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| ProductSubcategoryID | int - Identity | None | No | Primary key for ProductSubcategory records. |
| ProductCategoryID | int | None | No | Product category identification number. Foreign key to ProductCategory.ProductCategoryID. |
| Name | nvarchar (50) | None | No | Subcategory description. |
| rowguid | uniqueidentifier | (newid()) | No | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_ProductSubcategory_ProductSubcategoryID | Yes | Yes | ProductSubcategoryID |
| AK_ProductSubcategory_Name | No | Yes | Name |
| AK_ProductSubcategory_rowguid | No | Yes | rowguid |
| Internal Foreign Key Constraint | Affected Field | Source Table |
|---|---|---|
| FK_ProductSubcategory_ProductCategory_ProductCategoryID | ProductCategoryID | Production.ProductCategory |
| Primary Key as Foreign Key Constraint | Affected Table | Affected Field |
|---|---|---|
| FK_Product_ProductSubcategory_ProductSubcategoryID | Production.Product | ProductSubcategoryID |