Production.ProductCategory (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

Table Production.ProductCategory
Description High-level product categorization.

Columns[edit]

Column Data Type Nullable Default Description
ProductCategoryID int not null Primary key for ProductCategory records.
Name dbo.Name not null Category description.
rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate datetime not null (getdate()) Date and time the record was last updated.

Primary Key[edit]

Primary Key Columns
PK_ProductCategory_ProductCategoryID ProductCategoryID

Indexes[edit]

Index Type Columns
AK_ProductCategory_Name Unique Name
AK_ProductCategory_rowguid Unique rowguid

Detail Tables[edit]

Detail Table Column Referencing Column
Production.ProductSubcategory ProductCategoryID ProductCategoryID

References[edit]

Dependency Type Object Type Referenced Object
Data Type Type dbo.Name
Schema Schema Production


automatically generated[edit]

Table Production.ProductCategory
Description High-level product categorization.


Column Data Type Nullable Default Description / PK / Index
ProductCategoryID int not null Primary key for ProductCategory records.
PK_ProductCategory_ProductCategoryID
Name Name not null Category description.
AK_ProductCategory_Name
rowguid uniqueidentifier not null (NEWID()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_ProductCategory_rowguid
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Detail Table Column Referencing Column
Production.ProductSubcategory ProductCategoryID ProductCategoryID


Dependency Type Object Type Referenced Object
Data Type Type dbo.Name
Schema Schema Production