ScrewTurn Wiki

Edit

wikibot

TableProduction.ProductCategory
DescriptionHigh-level product categorization.

Edit

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.

Edit

Primary Key

Primary KeyColumns
PK_ProductCategory_ProductCategoryIDProductCategoryID

Edit

Indexes

IndexTypeColumns
AK_ProductCategory_NameUniqueName
AK_ProductCategory_rowguidUniquerowguid

Edit

Detail Tables

Detail TableColumnReferencing Column
Production.ProductSubcategoryProductCategoryIDProductCategoryID

Edit

References

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaProduction

Edit

automatically generated

TableProduction.ProductCategory
DescriptionHigh-level product categorization.

ColumnData TypeNullableDefaultDescription / PK / Index
ProductCategoryIDintnot null Primary key for ProductCategory records.
PK_ProductCategory_ProductCategoryID
NameNamenot null Category description.
AK_ProductCategory_Name
rowguiduniqueidentifiernot null(NEWID())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_ProductCategory_rowguid
ModifiedDatedatetimenot null(GETDATE())Date and time the record was last updated.



Detail TableColumnReferencing Column
Production.ProductSubcategoryProductCategoryIDProductCategoryID

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaProduction

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.