Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Production ProductModel (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 18:03


wikibot

TableProduction.ProductModel
DescriptionProduct model classification.

ColumnData TypeNullableDefaultDescription / PK / Index
ProductModelIDintnot null Primary key for ProductModel records.
PK_ProductModel_ProductModelID
Namedbo.Namenot null Product model description.
AK_ProductModel_Name
CatalogDescriptionxmlnull Detailed product catalog information in xml format.
PXML_ProductModel_CatalogDescription
Instructionsxmlnull Manufacturing instructions in xml format.
PXML_ProductModel_Instructions
rowguiduniqueidentifiernot null(newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_ProductModel_rowguid
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



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

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

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

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