Difference between revisions of "Production.ProductModel (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Production.ProductModel |- |} {| border="1" cellpadding="5" cellspacing="0" ...)
 
Line 59: Line 59:
 
| (getdate())
 
| (getdate())
 
|  
 
|  
 +
|
 +
|}
 +
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Detail Table
 +
| '''Column
 +
| '''Referencing Column
 +
 +
|-
 +
| [[Production.Product_(table)|Production.Product]]
 +
| ProductModelID
 +
| ProductModelID
 +
|-
 +
| [[Production.ProductModelIllustration_(table)|Production.ProductModelIllustration]]
 +
| ProductModelID
 +
| ProductModelID
 +
|-
 +
| [[Production.ProductModelProductDescriptionCulture_(table)|Production.ProductModelProductDescriptionCulture]]
 +
| ProductModelID
 +
| ProductModelID
 +
|}
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| Production.ProductModel
 +
|-
 +
 +
| '''Description
 +
| Product model classification.
 +
|-
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''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.
 
|  
 
|  
 
|}
 
|}

Revision as of 00:26, 27 November 2009

wikibot

Table Production.ProductModel


Column Data Type Nullable Default PK Index
ProductModelID int not null PK_ProductModel_ProductModelID
Name dbo.Name not null AK_ProductModel_Name
CatalogDescription xml null PXML_ProductModel_CatalogDescription
Instructions xml null PXML_ProductModel_Instructions
rowguid uniqueidentifier not null (newid()) AK_ProductModel_rowguid
ModifiedDate datetime not null (getdate())


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

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
Retrieved from "http://dbshelp.devio.at/index.php?title=Production.ProductModel_(table)&oldid=1106"