Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Production ProductCategory (table)

Compare Page Revisions



« Older Revision - Back to Page History - Current Revision


Page Revision: 2010/06/24 01:09


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

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