Difference between revisions of "Production (schema)"

From dbscript Online Help
Jump to: navigation, search
Line 16: Line 16:
 
|-
 
|-
 
| '''schema
 
| '''schema
−
| .Production
+
| Production
 
|- valign="top"
 
|- valign="top"
  
Line 32: Line 32:
 
{| 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"
 +
| '''Reference Type
 +
| '''Object Type
 
| '''Referencing Object
 
| '''Referencing Object
−
| '''Object Type
 
−
| '''Reference Type
 
  
 
|-
 
|-
 +
| Schema
 +
| Table
 
| [[Production.BillOfMaterials_(table)|Production.BillOfMaterials]]
 
| [[Production.BillOfMaterials_(table)|Production.BillOfMaterials]]
 +
 +
|-
 +
| Schema
 
| Table
 
| Table
 +
| [[Production.Culture_(table)|Production.Culture]]
 +
 +
|-
 
| Schema
 
| Schema
 +
| Table
 +
| [[Production.Document_(table)|Production.Document]]
 +
 
|-
 
|-
−
| [[Production.Culture_(table)|Production.Culture]]
+
| Schema
 
| Table
 
| Table
 +
| [[Production.Illustration_(table)|Production.Illustration]]
 +
 +
|-
 
| Schema
 
| Schema
 +
| Table
 +
| [[Production.Location_(table)|Production.Location]]
 +
 
|-
 
|-
−
| [[Production.Document_(table)|Production.Document]]
+
| Schema
 
| Table
 
| Table
 +
| [[Production.Product_(table)|Production.Product]]
 +
 +
|-
 
| Schema
 
| Schema
 +
| Table
 +
| [[Production.ProductCategory_(table)|Production.ProductCategory]]
 +
 
|-
 
|-
−
| [[Production.Illustration_(table)|Production.Illustration]]
+
| Schema
 
| Table
 
| Table
 +
| [[Production.ProductCostHistory_(table)|Production.ProductCostHistory]]
 +
 +
|-
 
| Schema
 
| Schema
 +
| Table
 +
| [[Production.ProductDescription_(table)|Production.ProductDescription]]
 +
 
|-
 
|-
−
| [[Production.Location_(table)|Production.Location]]
+
| Schema
 
| Table
 
| Table
 +
| [[Production.ProductDocument_(table)|Production.ProductDocument]]
 +
 +
|-
 
| Schema
 
| Schema
 +
| Table
 +
| [[Production.ProductInventory_(table)|Production.ProductInventory]]
 +
 
|-
 
|-
−
| [[Production.Product_(table)|Production.Product]]
+
| Schema
 
| Table
 
| Table
 +
| [[Production.ProductListPriceHistory_(table)|Production.ProductListPriceHistory]]
 +
 +
|-
 
| Schema
 
| Schema
 +
| Table
 +
| [[Production.ProductModel_(table)|Production.ProductModel]]
 +
 
|-
 
|-
−
| [[Production.ProductCategory_(table)|Production.ProductCategory]]
+
| Schema
 
| Table
 
| Table
 +
| [[Production.ProductModelIllustration_(table)|Production.ProductModelIllustration]]
 +
 +
|-
 
| Schema
 
| Schema
 +
| Table
 +
| [[Production.ProductModelProductDescriptionCulture_(table)|Production.ProductModelProductDescriptionCulture]]
 +
 
|-
 
|-
−
| [[Production.ProductCostHistory_(table)|Production.ProductCostHistory]]
+
| Schema
 
| Table
 
| Table
 +
| [[Production.ProductPhoto_(table)|Production.ProductPhoto]]
 +
 +
|-
 
| Schema
 
| Schema
 +
| Table
 +
| [[Production.ProductProductPhoto_(table)|Production.ProductProductPhoto]]
 +
 
|-
 
|-
−
| [[Production.ProductDescription_(table)|Production.ProductDescription]]
+
| Schema
 
| Table
 
| Table
 +
| [[Production.ProductReview_(table)|Production.ProductReview]]
 +
 +
|-
 
| Schema
 
| Schema
−
|-
 
−
| [[Production.ProductDocument_(table)|Production.ProductDocument]]
 
 
| Table
 
| Table
−
| Schema
+
| [[Production.ProductSubcategory_(table)|Production.ProductSubcategory]]
 +
 
 
|-
 
|-
−
| [[Production.ProductInventory_(table)|Production.ProductInventory]]
 
−
| Table
 
 
| Schema
 
| Schema
−
|-
 
−
| [[Production.ProductListPriceHistory_(table)|Production.ProductListPriceHistory]]
 
 
| Table
 
| Table
−
| Schema
+
| [[Production.ScrapReason_(table)|Production.ScrapReason]]
 +
 
 
|-
 
|-
−
| [[Production.ProductModel_(table)|Production.ProductModel]]
 
−
| Table
 
 
| Schema
 
| Schema
−
|-
 
−
| [[Production.ProductModelIllustration_(table)|Production.ProductModelIllustration]]
 
 
| Table
 
| Table
−
| Schema
+
| [[Production.TransactionHistory_(table)|Production.TransactionHistory]]
 +
 
 
|-
 
|-
−
| [[Production.ProductModelProductDescriptionCulture_(table)|Production.ProductModelProductDescriptionCulture]]
 
−
| Table
 
 
| Schema
 
| Schema
−
|-
 
−
| [[Production.ProductPhoto_(table)|Production.ProductPhoto]]
 
 
| Table
 
| Table
−
| Schema
+
| [[Production.TransactionHistoryArchive_(table)|Production.TransactionHistoryArchive]]
 +
 
 
|-
 
|-
−
| [[Production.ProductProductPhoto_(table)|Production.ProductProductPhoto]]
 
−
| Table
 
 
| Schema
 
| Schema
−
|-
 
−
| [[Production.ProductReview_(table)|Production.ProductReview]]
 
 
| Table
 
| Table
−
| Schema
+
| [[Production.UnitMeasure_(table)|Production.UnitMeasure]]
 +
 
 
|-
 
|-
−
| [[Production.ProductSubcategory_(table)|Production.ProductSubcategory]]
 
−
| Table
 
 
| Schema
 
| Schema
−
|-
 
−
| [[Production.ScrapReason_(table)|Production.ScrapReason]]
 
 
| Table
 
| Table
−
| Schema
+
| [[Production.WorkOrder_(table)|Production.WorkOrder]]
 +
 
 
|-
 
|-
−
| [[Production.TransactionHistory_(table)|Production.TransactionHistory]]
 
−
| Table
 
 
| Schema
 
| Schema
−
|-
 
−
| [[Production.TransactionHistoryArchive_(table)|Production.TransactionHistoryArchive]]
 
 
| Table
 
| Table
−
| Schema
+
| [[Production.WorkOrderRouting_(table)|Production.WorkOrderRouting]]
 +
 
 
|-
 
|-
−
| [[Production.UnitMeasure_(table)|Production.UnitMeasure]]
 
−
| Table
 
 
| Schema
 
| Schema
 +
| View
 +
| [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]]
 +
 
|-
 
|-
−
| [[Production.WorkOrder_(table)|Production.WorkOrder]]
 
−
| Table
 
 
| Schema
 
| Schema
 +
| View
 +
| [[Production.vProductModelCatalogDescription_(view)|Production.vProductModelCatalogDescription]]
 +
 
|-
 
|-
−
| [[Production.WorkOrderRouting_(table)|Production.WorkOrderRouting]]
 
−
| Table
 
 
| Schema
 
| Schema
−
|-
 
−
| [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]]
 
 
| View
 
| View
−
| Schema
+
| [[Production.vProductModelInstructions_(view)|Production.vProductModelInstructions]]
 +
 
 
|-
 
|-
−
| [[Production.vProductModelCatalogDescription_(view)|Production.vProductModelCatalogDescription]]
 
−
| View
 
 
| Schema
 
| Schema
 +
| XML Schema Collection
 +
| [[Production.ManuInstructionsSchemaCollection_(xml_schema_collection)|Production.ManuInstructionsSchemaCollection]]
 +
 
|-
 
|-
−
| [[Production.vProductModelInstructions_(view)|Production.vProductModelInstructions]]
 
−
| View
 
 
| Schema
 
| Schema
−
|-
 
−
| [[Production.ManuInstructionsSchemaCollection_(xml_schema_collection)|Production.ManuInstructionsSchemaCollection]]
 
 
| XML Schema Collection
 
| XML Schema Collection
−
| Schema
 
−
|-
 
 
| [[Production.ProductDescriptionSchemaCollection_(xml_schema_collection)|Production.ProductDescriptionSchemaCollection]]
 
| [[Production.ProductDescriptionSchemaCollection_(xml_schema_collection)|Production.ProductDescriptionSchemaCollection]]
−
| XML Schema Collection
+
 
−
| Schema
 
 
|}
 
|}

Revision as of 06:39, 30 November 2009

wikibot

schema .Production 
CREATE SCHEMA Production AUTHORIZATION dbo

automatically generated

schema Production
Description Contains objects related to products, inventory, and manufacturing. 
CREATE SCHEMA Production AUTHORIZATION dbo


Reference Type Object Type Referencing Object
Schema Table Production.BillOfMaterials
Schema Table Production.Culture
Schema Table Production.Document
Schema Table Production.Illustration
Schema Table Production.Location
Schema Table Production.Product
Schema Table Production.ProductCategory
Schema Table Production.ProductCostHistory
Schema Table Production.ProductDescription
Schema Table Production.ProductDocument
Schema Table Production.ProductInventory
Schema Table Production.ProductListPriceHistory
Schema Table Production.ProductModel
Schema Table Production.ProductModelIllustration
Schema Table Production.ProductModelProductDescriptionCulture
Schema Table Production.ProductPhoto
Schema Table Production.ProductProductPhoto
Schema Table Production.ProductReview
Schema Table Production.ProductSubcategory
Schema Table Production.ScrapReason
Schema Table Production.TransactionHistory
Schema Table Production.TransactionHistoryArchive
Schema Table Production.UnitMeasure
Schema Table Production.WorkOrder
Schema Table Production.WorkOrderRouting
Schema View Production.vProductAndDescription
Schema View Production.vProductModelCatalogDescription
Schema View Production.vProductModelInstructions
Schema XML Schema Collection Production.ManuInstructionsSchemaCollection
Schema XML Schema Collection Production.ProductDescriptionSchemaCollection
Retrieved from "http://dbshelp.devio.at/index.php?title=Production_(schema)&oldid=1719"