Production.ProductSubcategory
Documentation | AdventureWorks |
Schema | Production |
Name | ProductSubcategory |
Module | Products |
Product subcategories. See ProductCategory table.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | ProductSubcategoryID | int | Identity | Primary key for ProductSubcategory records. | ||||
Primary key for ProductSubcategory records. Identity |
||||||||
2 | ProductCategoryID | int | Production.ProductCategory | Product category identification number. Foreign key to ProductCategory.ProductCategoryID. | ||||
Product category identification number. Foreign key to ProductCategory.ProductCategoryID. References: Production.ProductCategory |
||||||||
3 | Name | nvarchar(50) | Subcategory description. | |||||
Subcategory description. |
||||||||
4 | rowguid | uniqueidentifier | Default: newid() | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. | ||||
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. Default: newid() |
||||||||
5 | ModifiedDate | datetime | Default: getdate() | Date and time the record was last updated. | ||||
Date and time the record was last updated. Default: getdate() |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
Production.ProductSubcategory | Production.ProductCategory | Production.ProductSubcategory.ProductCategoryID = Production.ProductCategory.ProductCategoryID | FK_ProductSubcategory_ProductCategory_ProductCategoryID Foreign key constraint referencing ProductCategory.ProductCategoryID. |
|
Production.ProductSubcategory.ProductCategoryID = Production.ProductCategory.ProductCategoryID Name: FK_ProductSubcategory_ProductCategory_ProductCategoryIDForeign key constraint referencing ProductCategory.ProductCategoryID. |
||||
Production.Product | Production.ProductSubcategory | Production.Product.ProductSubcategoryID = Production.ProductSubcategory.ProductSubcategoryID | FK_Product_ProductSubcategory_ProductSubcategoryID Foreign key constraint referencing ProductSubcategory.ProductSubcategoryID. |
|
Production.Product.ProductSubcategoryID = Production.ProductSubcategory.ProductSubcategoryID Name: FK_Product_ProductSubcategory_ProductSubcategoryIDForeign key constraint referencing ProductSubcategory.ProductSubcategoryID. |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_ProductSubcategory_ProductSubcategoryID | ProductSubcategoryID | Primary key (clustered) constraint | |
Primary key (clustered) constraint | |||
AK_ProductSubcategory_Name | Name | Unique nonclustered index. | |
Unique nonclustered index. | |||
AK_ProductSubcategory_rowguid | rowguid | Unique nonclustered index. Used to support replication samples. | |
Unique nonclustered index. Used to support replication samples. |
Uses
Name |
---|
Production.ProductSubcategory
|
Used by
Name |
---|
Production.ProductSubcategory
|
Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56