Production ProductCategory (table)

wikibot

TableProduction.ProductCategory
DescriptionHigh-level product categorization.

Columns

ColumnData TypeNullableDefaultDescription
ProductCategoryIDintnot null Primary key for ProductCategory records.
Namedbo.Namenot null Category description.
rowguiduniqueidentifiernot null(newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_ProductCategory_ProductCategoryIDProductCategoryID

Indexes

IndexTypeColumns
AK_ProductCategory_NameUniqueName
AK_ProductCategory_rowguidUniquerowguid

Detail Tables

Detail TableColumnReferencing Column
Production.ProductSubcategoryProductCategoryIDProductCategoryID

References

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaProduction