Difference between revisions of "Production (schema)"
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