ScrewTurn Wiki

Navigation

Main Page

Quick Search

Advanced Search »

PoweredBy

Discuss (0)View Page Code History

Production.ProductModel_(table)

Modified: 2010/02/11 07:50 by wikibot - Uncategorized

(10) » IX.AQ$ORDERS_QUEUETABLE_(view) » Production.TransactionHistory_(table) » Production.ProductModel_(table)

wikibot

Table	Production.ProductModel
Description	Product model classification.

Columns

Column	Data Type	Nullable	Default	Description
ProductModelID	int	not null		Primary key for ProductModel records.
Name	dbo.Name	not null		Product model description.
CatalogDescription	xml	null		Detailed product catalog information in xml format.
Instructions	xml	null		Manufacturing instructions in xml format.
rowguid	uniqueidentifier	not null	(newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Primary Key

Primary Key	Columns
PK_ProductModel_ProductModelID	ProductModelID

Indexes

Index	Type	Columns
AK_ProductModel_Name	Unique	Name
AK_ProductModel_rowguid	Unique	rowguid
PXML_ProductModel_CatalogDescription		CatalogDescription
PXML_ProductModel_Instructions		Instructions

Detail Tables

Detail Table	Column	Referencing Column
Production.Product	ProductModelID	ProductModelID
Production.ProductModelIllustration	ProductModelID	ProductModelID
Production.ProductModelProductDescriptionCulture	ProductModelID	ProductModelID

References

Dependency Type	Object Type	Referenced Object
Data Type	Type	dbo.Name
Schema	Schema	Production
Data Type	XML Schema Collection	Production.ManuInstructionsSchemaCollection
Data Type	XML Schema Collection	Production.ProductDescriptionSchemaCollection

Dependencies

Reference Type	Object Type	Referencing Object
Select	View	Production.vProductAndDescription
Select	View	Production.vProductModelCatalogDescription
Select	View	Production.vProductModelInstructions

automatically generated

Table	Production.ProductModel
Description	Product model classification.

Column	Data Type	Nullable	Default	Description / PK / Index
ProductModelID	int	not null		Primary key for ProductModel records. PK_ProductModel_ProductModelID
Name	Name	not null		Product model description. AK_ProductModel_Name
CatalogDescription	XML	null		Detailed product catalog information in xml format. PXML_ProductModel_CatalogDescription
Instructions	XML	null		Manufacturing instructions in xml format. PXML_ProductModel_Instructions
rowguid	uniqueidentifier	not null	(NEWID())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. AK_ProductModel_rowguid
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Detail Table	Column	Referencing Column
Production.Product	ProductModelID	ProductModelID
Production.ProductModelIllustration	ProductModelID	ProductModelID
Production.ProductModelProductDescriptionCulture	ProductModelID	ProductModelID

Dependency Type	Object Type	Referenced Object
Data Type	Type	dbo.Name
Schema	Schema	Production
Data Type	XML Schema Collection	Production.ManuInstructionsSchemaCollection
Data Type	XML Schema Collection	Production.ProductDescriptionSchemaCollection

Reference Type	Object Type	Referencing Object
Select	View	Production.vProductAndDescription
Select	View	Production.vProductModelCatalogDescription
Select	View	Production.vProductModelInstructions

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