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

From dbscript Online Help
Jump to: navigation, search
 
(8 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| Production.ProductModel
 
| Production.ProductModel
−
|-
+
|- valign="top"
 +
| '''Description
 +
| Product model classification.
 
|}
 
|}
  
−
 
+
=== 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 15: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
+
 
−
+
|- valign="top"
−
|-
 
 
| ProductModelID
 
| ProductModelID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_ProductModel_ProductModelID
+
| Primary key for ProductModel records.
−
|
+
|- valign="top"
−
|-
 
 
| Name
 
| Name
 
| dbo.Name
 
| dbo.Name
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Product model description.
−
| AK_ProductModel_Name
+
|- valign="top"
−
|-
 
 
| CatalogDescription
 
| CatalogDescription
 
| xml
 
| xml
 
| null
 
| null
 
|  
 
|  
−
|  
+
| Detailed product catalog information in xml format.
−
| PXML_ProductModel_CatalogDescription
+
|- valign="top"
−
|-
 
 
| Instructions
 
| Instructions
 
| xml
 
| xml
 
| null
 
| null
 
|  
 
|  
−
|  
+
| Manufacturing instructions in xml format.
−
| PXML_ProductModel_Instructions
+
|- valign="top"
−
|-
 
 
| rowguid
 
| rowguid
 
| uniqueidentifier
 
| uniqueidentifier
 
| not null
 
| not null
 
| (newid())
 
| (newid())
−
|  
+
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
−
| AK_ProductModel_rowguid
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
 +
| 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
 +
|- valign="top"
 +
| PK_ProductModel_ProductModelID
 +
| ProductModelID
 +
|}
 +
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|- valign="top"
 +
| AK_ProductModel_Name
 +
| Unique
 +
| Name
 +
|- valign="top"
 +
| AK_ProductModel_rowguid
 +
| Unique
 +
| rowguid
 +
|- valign="top"
 +
| PXML_ProductModel_CatalogDescription
 
|  
 
|  
 +
| CatalogDescription
 +
|- valign="top"
 +
| 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 69: Line 98:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[Production.Product_(table)|Production.Product]]
 
| [[Production.Product_(table)|Production.Product]]
 
| ProductModelID
 
| ProductModelID
 
| ProductModelID
 
| ProductModelID
−
|-
+
|- valign="top"
 
| [[Production.ProductModelIllustration_(table)|Production.ProductModelIllustration]]
 
| [[Production.ProductModelIllustration_(table)|Production.ProductModelIllustration]]
 
| ProductModelID
 
| ProductModelID
 
| ProductModelID
 
| ProductModelID
−
|-
+
|- valign="top"
 
| [[Production.ProductModelProductDescriptionCulture_(table)|Production.ProductModelProductDescriptionCulture]]
 
| [[Production.ProductModelProductDescriptionCulture_(table)|Production.ProductModelProductDescriptionCulture]]
 
| ProductModelID
 
| ProductModelID
 
| ProductModelID
 
| ProductModelID
 
|}
 
|}
 +
 +
=== References ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|- valign="top"
 +
| Data Type
 +
| Type
 +
| [[dbo.Name_(type)|dbo.Name]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[Production_(schema)|Production]]
 +
 +
|- valign="top"
 +
| Data Type
 +
| XML Schema Collection
 +
| [[Production.ManuInstructionsSchemaCollection_(xml schema collection)|Production.ManuInstructionsSchemaCollection]]
 +
 +
|- valign="top"
 +
| Data Type
 +
| XML Schema Collection
 +
| [[Production.ProductDescriptionSchemaCollection_(xml schema collection)|Production.ProductDescriptionSchemaCollection]]
 +
 +
|}
 +
 +
=== Dependencies ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|- valign="top"
 +
| Select
 +
| View
 +
| [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]]
 +
 +
|- valign="top"
 +
| Select
 +
| View
 +
| [[Production.vProductModelCatalogDescription_(view)|Production.vProductModelCatalogDescription]]
 +
 +
|- valign="top"
 +
| Select
 +
| View
 +
| [[Production.vProductModelInstructions_(view)|Production.vProductModelInstructions]]
 +
 +
|}
 +
  
 
== automatically generated ==
 
== automatically generated ==
Line 90: Line 173:
 
| '''Table
 
| '''Table
 
| Production.ProductModel
 
| Production.ProductModel
−
|-
+
|- valign="top"
−
 
 
 
| '''Description
 
| '''Description
 
| Product model classification.
 
| Product model classification.
 
|-
 
|-
−
 
 
|}
 
|}
  
Line 105: Line 186:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''Description
+
| '''Description / PK / Index
−
| '''PK / Index
 
 
 
−
|-
+
|- valign="top"
 
| ProductModelID
 
| ProductModelID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key for ProductModel records.
+
| Primary key for ProductModel records.<br />PK_ProductModel_ProductModelID
−
| PK_ProductModel_ProductModelID
+
|- valign="top"
−
|-
 
 
| Name
 
| Name
 
| Name
 
| Name
 
| not null
 
| not null
 
|  
 
|  
−
| Product model description.
+
| Product model description.<br />AK_ProductModel_Name
−
| AK_ProductModel_Name
+
|- valign="top"
−
|-
 
 
| CatalogDescription
 
| CatalogDescription
 
| XML
 
| XML
 
| null
 
| null
 
|  
 
|  
−
| Detailed product catalog information in xml format.
+
| Detailed product catalog information in xml format.<br />PXML_ProductModel_CatalogDescription
−
| PXML_ProductModel_CatalogDescription
+
|- valign="top"
−
|-
 
 
| Instructions
 
| Instructions
 
| XML
 
| XML
 
| null
 
| null
 
|  
 
|  
−
| Manufacturing instructions in xml format.
+
| Manufacturing instructions in xml format.<br />PXML_ProductModel_Instructions
−
| PXML_ProductModel_Instructions
+
|- valign="top"
−
|-
 
 
| rowguid
 
| rowguid
 
| uniqueidentifier
 
| uniqueidentifier
 
| not null
 
| not null
 
| (NEWID())
 
| (NEWID())
−
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
+
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_ProductModel_rowguid
−
| AK_ProductModel_rowguid
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (GETDATE())
 
| (GETDATE())
−
| Date and time the record was last updated.
+
| Date and time the record was last updated.<br />
−
|
 
 
|}
 
|}
  
Line 172: Line 246:
 
| ProductModelID
 
| ProductModelID
 
| ProductModelID
 
| ProductModelID
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|-
 +
| Data Type
 +
| Type
 +
| [[dbo.Name_(type)|dbo.Name]]
 +
 +
|-
 +
| Schema
 +
| Schema
 +
| [[Production_(schema)|Production]]
 +
 +
|-
 +
| Data Type
 +
| XML Schema Collection
 +
| [[Production.ManuInstructionsSchemaCollection_(xml_schema_collection)|Production.ManuInstructionsSchemaCollection]]
 +
 +
|-
 +
| Data Type
 +
| XML Schema Collection
 +
| [[Production.ProductDescriptionSchemaCollection_(xml_schema_collection)|Production.ProductDescriptionSchemaCollection]]
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|-
 +
| Select
 +
| View
 +
| [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]]
 +
 +
|-
 +
| Select
 +
| View
 +
| [[Production.vProductModelCatalogDescription_(view)|Production.vProductModelCatalogDescription]]
 +
 +
|-
 +
| Select
 +
| View
 +
| [[Production.vProductModelInstructions_(view)|Production.vProductModelInstructions]]
 +
 
|}
 
|}

Latest revision as of 23:16, 23 June 2010

wikibot[edit]

Table Production.ProductModel
Description Product model classification.

Columns[edit]

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[edit]

Primary Key Columns
PK_ProductModel_ProductModelID ProductModelID

Indexes[edit]

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

Detail Tables[edit]

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

References[edit]

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[edit]

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


automatically generated[edit]

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=2635"