Production ProductModel (table)

wikibot

TableProduction.ProductModel
DescriptionProduct model classification.

Columns

ColumnData TypeNullableDefaultDescription
ProductModelIDintnot null Primary key for ProductModel records.
Namedbo.Namenot null Product model description.
CatalogDescriptionxmlnull Detailed product catalog information in xml format.
Instructionsxmlnull Manufacturing instructions in xml format.
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_ProductModel_ProductModelIDProductModelID

Indexes

IndexTypeColumns
AK_ProductModel_NameUniqueName
AK_ProductModel_rowguidUniquerowguid
PXML_ProductModel_CatalogDescription CatalogDescription
PXML_ProductModel_Instructions Instructions

Detail Tables

Detail TableColumnReferencing Column
Production.ProductProductModelIDProductModelID
Production.ProductModelIllustrationProductModelIDProductModelID
Production.ProductModelProductDescriptionCultureProductModelIDProductModelID

References

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaProduction
Data TypeXML Schema CollectionProduction.ManuInstructionsSchemaCollection
Data TypeXML Schema CollectionProduction.ProductDescriptionSchemaCollection

Dependencies

Reference TypeObject TypeReferencing Object
SelectViewProduction.vProductAndDescription
SelectViewProduction.vProductModelCatalogDescription
SelectViewProduction.vProductModelInstructions