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

From dbscript Online Help
Jump to: navigation, search
Line 12: Line 12:
  
  
 +
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 18: Line 19:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''Description / PK / Index
+
| '''Description
 
 
 
|- valign="top"
 
|- valign="top"
Line 25: Line 26:
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key for ProductModel records.<br />PK_ProductModel_ProductModelID
+
| Primary key for ProductModel records.
 
|- valign="top"
 
|- valign="top"
 
| Name
 
| Name
Line 31: Line 32:
 
| not null
 
| not null
 
|  
 
|  
−
| Product model description.<br />AK_ProductModel_Name
+
| Product model description.
 
|- valign="top"
 
|- valign="top"
 
| CatalogDescription
 
| CatalogDescription
Line 37: Line 38:
 
| null
 
| null
 
|  
 
|  
−
| Detailed product catalog information in xml format.<br />PXML_ProductModel_CatalogDescription
+
| Detailed product catalog information in xml format.
 
|- valign="top"
 
|- valign="top"
 
| Instructions
 
| Instructions
Line 43: Line 44:
 
| null
 
| null
 
|  
 
|  
−
| Manufacturing instructions in xml format.<br />PXML_ProductModel_Instructions
+
| Manufacturing instructions in xml format.
 
|- valign="top"
 
|- valign="top"
 
| rowguid
 
| rowguid
Line 49: Line 50:
 
| not null
 
| not null
 
| (newid())
 
| (newid())
−
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_ProductModel_rowguid
+
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
 
|- valign="top"
 
|- valign="top"
 
| ModifiedDate
 
| ModifiedDate
Line 55: Line 56:
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
−
| Date and time the record was last updated.<br />
+
| Date and time the record was last updated.
 
|}
 
|}
  
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|-
 +
| PK_ProductModel_ProductModelID
 +
| ProductModelID
 +
|}
  
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|-
 +
| AK_ProductModel_Name
 +
| Unique
 +
| Name
 +
|-
 +
| AK_ProductModel_rowguid
 +
| Unique
 +
| rowguid
 +
|-
 +
| PXML_ProductModel_CatalogDescription
 +
|
 +
| CatalogDescription
 +
|-
 +
| PXML_ProductModel_Instructions
 +
|
 +
| Instructions
 +
|}
  
 +
=== Detail Tables ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 80: Line 115:
 
|}
 
|}
  
−
 
+
=== References ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 91: Line 126:
 
| Type
 
| Type
 
| [[dbo.Name_(type)|dbo.Name]]
 
| [[dbo.Name_(type)|dbo.Name]]
 +
 +
|-
 +
| Schema
 +
| Schema
 +
| [[Production_(schema)|Production]]
  
 
|-
 
|-
Line 104: Line 144:
 
|}
 
|}
  
−
 
+
=== Dependencies ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 127: Line 167:
  
 
|}
 
|}
−
 
  
  

Revision as of 23:07, 2 February 2010

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