Latest revision |
Your text |
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" | + | |- |
− | | '''Schema | + | | '''schema |
| | Production | | | Production |
| |- valign="top" | | |- valign="top" |
| | '''Description | | | '''Description |
| | Contains objects related to products, inventory, and manufacturing. | | | Contains objects related to products, inventory, and manufacturing. |
| + | |- |
| |} | | |} |
| | | |
− | === Source ===
| |
| <pre> | | <pre> |
| CREATE SCHEMA Production AUTHORIZATION dbo | | CREATE SCHEMA Production AUTHORIZATION dbo |
| </pre> | | </pre> |
| | | |
− | === Dependencies ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Reference Type
| |
− | | '''Object Type
| |
− | | '''Referencing Object
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.BillOfMaterials_(table)|Production.BillOfMaterials]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.Culture_(table)|Production.Culture]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.Document_(table)|Production.Document]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.Illustration_(table)|Production.Illustration]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.Location_(table)|Production.Location]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.Product_(table)|Production.Product]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.ProductCategory_(table)|Production.ProductCategory]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.ProductCostHistory_(table)|Production.ProductCostHistory]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.ProductDescription_(table)|Production.ProductDescription]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.ProductDocument_(table)|Production.ProductDocument]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.ProductInventory_(table)|Production.ProductInventory]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.ProductListPriceHistory_(table)|Production.ProductListPriceHistory]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.ProductModel_(table)|Production.ProductModel]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.ProductModelIllustration_(table)|Production.ProductModelIllustration]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.ProductModelProductDescriptionCulture_(table)|Production.ProductModelProductDescriptionCulture]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.ProductPhoto_(table)|Production.ProductPhoto]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.ProductProductPhoto_(table)|Production.ProductProductPhoto]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.ProductReview_(table)|Production.ProductReview]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.ProductSubcategory_(table)|Production.ProductSubcategory]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.ScrapReason_(table)|Production.ScrapReason]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.TransactionHistory_(table)|Production.TransactionHistory]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.TransactionHistoryArchive_(table)|Production.TransactionHistoryArchive]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.UnitMeasure_(table)|Production.UnitMeasure]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.WorkOrder_(table)|Production.WorkOrder]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Production.WorkOrderRouting_(table)|Production.WorkOrderRouting]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | View
| |
− | | [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | View
| |
− | | [[Production.vProductModelCatalogDescription_(view)|Production.vProductModelCatalogDescription]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | View
| |
− | | [[Production.vProductModelInstructions_(view)|Production.vProductModelInstructions]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | XML Schema Collection
| |
− | | [[Production.ManuInstructionsSchemaCollection_(xml schema collection)|Production.ManuInstructionsSchemaCollection]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | XML Schema Collection
| |
− | | [[Production.ProductDescriptionSchemaCollection_(xml schema collection)|Production.ProductDescriptionSchemaCollection]]
| |
− |
| |
− | |}
| |
| | | |
| | | |