Production.ProductCategory
Documentation | AdventureWorks |
Schema | Production |
Name | ProductCategory |
Module | Products |
High-level product categorization.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | ProductCategoryID | int | Identity | Primary key for ProductCategory records. | ||||
Primary key for ProductCategory records. Identity |
||||||||
2 | Name | nvarchar(50) | Production.ProductModelIllustration | Category description. | ||||
Category description. References: Production.ProductModelIllustration |
||||||||
3 | 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() |
||||||||
4 | 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.ProductCategory | Production.ProductModelIllustration | Production.ProductCategory.Name = Production.ProductModelIllustration.ProductModelID Production.ProductCategory.Name = Production.ProductModelIllustration.IllustrationID |
fk_ProductModelIllustration_ProductCategory | |
Production.ProductCategory.Name = Production.ProductModelIllustration.ProductModelID Name: fk_ProductModelIllustration_ProductCategoryProduction.ProductCategory.Name = Production.ProductModelIllustration.IllustrationID |
||||
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. |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_ProductCategory_ProductCategoryID | ProductCategoryID | Primary key (clustered) constraint | |
Primary key (clustered) constraint | |||
AK_ProductCategory_Name | Name | Unique nonclustered index. | |
Unique nonclustered index. | |||
AK_ProductCategory_rowguid | rowguid | Unique nonclustered index. Used to support replication samples. | |
Unique nonclustered index. Used to support replication samples. |
Uses
Name |
---|
Production.ProductCategory
|
Used by
Name |
---|
Production.ProductCategory
|
Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56