Difference between revisions of "Production (schema)"

From dbscript Online Help
Jump to: navigation, search
Line 17: Line 17:
 
| '''schema
 
| '''schema
 
| .Production
 
| .Production
|-
+
|- valign="top"
  
 
| '''Description
 
| '''Description
Line 28: Line 28:
 
CREATE SCHEMA Production AUTHORIZATION dbo
 
CREATE SCHEMA Production AUTHORIZATION dbo
 
</pre>
 
</pre>
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Referencing Object
 +
| '''Object Type
 +
| '''Reference Type
 +
 +
|-
 +
| [[Production.BillOfMaterials_(table)|Production.BillOfMaterials]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.Culture_(table)|Production.Culture]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.Document_(table)|Production.Document]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.Illustration_(table)|Production.Illustration]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.Location_(table)|Production.Location]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.Product_(table)|Production.Product]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.ProductCategory_(table)|Production.ProductCategory]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.ProductCostHistory_(table)|Production.ProductCostHistory]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.ProductDescription_(table)|Production.ProductDescription]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.ProductDocument_(table)|Production.ProductDocument]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.ProductInventory_(table)|Production.ProductInventory]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.ProductListPriceHistory_(table)|Production.ProductListPriceHistory]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.ProductModel_(table)|Production.ProductModel]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.ProductModelIllustration_(table)|Production.ProductModelIllustration]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.ProductModelProductDescriptionCulture_(table)|Production.ProductModelProductDescriptionCulture]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.ProductPhoto_(table)|Production.ProductPhoto]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.ProductProductPhoto_(table)|Production.ProductProductPhoto]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.ProductReview_(table)|Production.ProductReview]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.ProductSubcategory_(table)|Production.ProductSubcategory]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.ScrapReason_(table)|Production.ScrapReason]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.TransactionHistory_(table)|Production.TransactionHistory]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.TransactionHistoryArchive_(table)|Production.TransactionHistoryArchive]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.UnitMeasure_(table)|Production.UnitMeasure]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.WorkOrder_(table)|Production.WorkOrder]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.WorkOrderRouting_(table)|Production.WorkOrderRouting]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]]
 +
| View
 +
| Schema
 +
|-
 +
| [[Production.vProductModelCatalogDescription_(view)|Production.vProductModelCatalogDescription]]
 +
| View
 +
| Schema
 +
|-
 +
| [[Production.vProductModelInstructions_(view)|Production.vProductModelInstructions]]
 +
| View
 +
| Schema
 +
|-
 +
| [[Production.ManuInstructionsSchemaCollection_(xml_schema_collection)|Production.ManuInstructionsSchemaCollection]]
 +
| XML Schema Collection
 +
| Schema
 +
|-
 +
| [[Production.ProductDescriptionSchemaCollection_(xml_schema_collection)|Production.ProductDescriptionSchemaCollection]]
 +
| XML Schema Collection
 +
| Schema
 +
|}

Revision as of 06:26, 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


Referencing Object Object Type Reference Type
Production.BillOfMaterials Table Schema
Production.Culture Table Schema
Production.Document Table Schema
Production.Illustration Table Schema
Production.Location Table Schema
Production.Product Table Schema
Production.ProductCategory Table Schema
Production.ProductCostHistory Table Schema
Production.ProductDescription Table Schema
Production.ProductDocument Table Schema
Production.ProductInventory Table Schema
Production.ProductListPriceHistory Table Schema
Production.ProductModel Table Schema
Production.ProductModelIllustration Table Schema
Production.ProductModelProductDescriptionCulture Table Schema
Production.ProductPhoto Table Schema
Production.ProductProductPhoto Table Schema
Production.ProductReview Table Schema
Production.ProductSubcategory Table Schema
Production.ScrapReason Table Schema
Production.TransactionHistory Table Schema
Production.TransactionHistoryArchive Table Schema
Production.UnitMeasure Table Schema
Production.WorkOrder Table Schema
Production.WorkOrderRouting Table Schema
Production.vProductAndDescription View Schema
Production.vProductModelCatalogDescription View Schema
Production.vProductModelInstructions View Schema
Production.ManuInstructionsSchemaCollection XML Schema Collection Schema
Production.ProductDescriptionSchemaCollection XML Schema Collection Schema