# Schema: Production

## Properties

Name | Value
--- | ---
Name | Production
ID | 7
Owner | dbo

## Extended Properties

Name | Value
--- | ---
MS_Description | Contains objects related to products, inventory, and manufacturing.

## Permissions

#### Permissions for: duser

Permission | Grantor | Grant | With Grant Option | Deny
--- | --- | --- | --- | ---
Alter | dbo |  |  |
Control | dbo |  |  |
Delete |  |  |  |
Execute | dbo |  |  |
Insert | dbo |  |  |
References |  |  |  |
Select |  |  |  |
Take Ownership |  |  |  |
Update |  |  |  |
View Change Tracking |  |  |  |
View Definition |  |  |  |

#### Permissions for: public

Permission | Grantor | Grant | With Grant Option | Deny
--- | --- | --- | --- | ---
Alter |  |  |  |
Control |  |  |  |
Delete |  |  |  |
Execute |  |  |  |
Insert |  |  |  |
References |  |  |  |
Select |  |  |  |
Take Ownership |  |  |  |
Update |  |  |  |
View Change Tracking |  |  |  |
View Definition | dbo |  |  |

## Objects

Name | Type
--- | ---
CK_BillOfMaterials_BOMLevel | CHECK constraint
CK_BillOfMaterials_EndDate | CHECK constraint
CK_BillOfMaterials_PerAssemblyQty | CHECK constraint
CK_BillOfMaterials_ProductAssemblyID | CHECK constraint
CK_Document_Status | CHECK constraint
CK_Location_Availability | CHECK constraint
CK_Location_CostRate | CHECK constraint
CK_Product_Class | CHECK constraint
CK_Product_DaysToManufacture | CHECK constraint
CK_Product_ListPrice | CHECK constraint
CK_Product_ProductLine | CHECK constraint
CK_Product_ReorderPoint | CHECK constraint
CK_Product_SafetyStockLevel | CHECK constraint
CK_Product_SellEndDate | CHECK constraint
CK_Product_StandardCost | CHECK constraint
CK_Product_Style | CHECK constraint
CK_Product_Weight | CHECK constraint
CK_ProductCostHistory_EndDate | CHECK constraint
CK_ProductCostHistory_StandardCost | CHECK constraint
CK_ProductInventory_Bin | CHECK constraint
CK_ProductInventory_Shelf | CHECK constraint
CK_ProductListPriceHistory_EndDate | CHECK constraint
CK_ProductListPriceHistory_ListPrice | CHECK constraint
CK_ProductReview_Rating | CHECK constraint
CK_TransactionHistory_TransactionType | CHECK constraint
CK_TransactionHistoryArchive_TransactionType | CHECK constraint
CK_WorkOrder_EndDate | CHECK constraint
CK_WorkOrder_OrderQty | CHECK constraint
CK_WorkOrder_ScrappedQty | CHECK constraint
CK_WorkOrderRouting_ActualCost | CHECK constraint
CK_WorkOrderRouting_ActualEndDate | CHECK constraint
CK_WorkOrderRouting_ActualResourceHrs | CHECK constraint
CK_WorkOrderRouting_PlannedCost | CHECK constraint
CK_WorkOrderRouting_ScheduledEndDate | CHECK constraint
FK_BillOfMaterials_Product_ComponentID | FOREIGN KEY constraint
FK_BillOfMaterials_Product_ProductAssemblyID | FOREIGN KEY constraint
FK_BillOfMaterials_UnitMeasure_UnitMeasureCode | FOREIGN KEY constraint
FK_Document_Employee_Owner | FOREIGN KEY constraint
FK_Product_ProductModel_ProductModelID | FOREIGN KEY constraint
FK_Product_ProductSubcategory_ProductSubcategoryID | FOREIGN KEY constraint
FK_Product_UnitMeasure_SizeUnitMeasureCode | FOREIGN KEY constraint
FK_Product_UnitMeasure_WeightUnitMeasureCode | FOREIGN KEY constraint
FK_ProductCostHistory_Product_ProductID | FOREIGN KEY constraint
FK_ProductDocument_Document_DocumentNode | FOREIGN KEY constraint
FK_ProductDocument_Product_ProductID | FOREIGN KEY constraint
FK_ProductInventory_Location_LocationID | FOREIGN KEY constraint
FK_ProductInventory_Product_ProductID | FOREIGN KEY constraint
FK_ProductListPriceHistory_Product_ProductID | FOREIGN KEY constraint
FK_ProductModelIllustration_Illustration_IllustrationID | FOREIGN KEY constraint
FK_ProductModelIllustration_ProductModel_ProductModelID | FOREIGN KEY constraint
FK_ProductModelProductDescriptionCulture_Culture_CultureID | FOREIGN KEY constraint
FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID | FOREIGN KEY constraint
FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID | FOREIGN KEY constraint
FK_ProductProductPhoto_Product_ProductID | FOREIGN KEY constraint
FK_ProductProductPhoto_ProductPhoto_ProductPhotoID | FOREIGN KEY constraint
FK_ProductReview_Product_ProductID | FOREIGN KEY constraint
FK_ProductSubcategory_ProductCategory_ProductCategoryID | FOREIGN KEY constraint
FK_TransactionHistory_Product_ProductID | FOREIGN KEY constraint
FK_WorkOrder_Product_ProductID | FOREIGN KEY constraint
FK_WorkOrder_ScrapReason_ScrapReasonID | FOREIGN KEY constraint
FK_WorkOrderRouting_Location_LocationID | FOREIGN KEY constraint
FK_WorkOrderRouting_WorkOrder_WorkOrderID | FOREIGN KEY constraint
PK_BillOfMaterials_BillOfMaterialsID | PRIMARY KEY constraint
PK_Culture_CultureID | PRIMARY KEY constraint
PK_Document_DocumentNode | PRIMARY KEY constraint
PK_Illustration_IllustrationID | PRIMARY KEY constraint
PK_Location_LocationID | PRIMARY KEY constraint
PK_Product_ProductID | PRIMARY KEY constraint
PK_ProductCategory_ProductCategoryID | PRIMARY KEY constraint
PK_ProductCostHistory_ProductID_StartDate | PRIMARY KEY constraint
PK_ProductDescription_ProductDescriptionID | PRIMARY KEY constraint
PK_ProductDocument_ProductID_DocumentNode | PRIMARY KEY constraint
PK_ProductInventory_ProductID_LocationID | PRIMARY KEY constraint
PK_ProductListPriceHistory_ProductID_StartDate | PRIMARY KEY constraint
PK_ProductModel_ProductModelID | PRIMARY KEY constraint
PK_ProductModelIllustration_ProductModelID_IllustrationID | PRIMARY KEY constraint
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID | PRIMARY KEY constraint
PK_ProductPhoto_ProductPhotoID | PRIMARY KEY constraint
PK_ProductProductPhoto_ProductID_ProductPhotoID | PRIMARY KEY constraint
PK_ProductReview_ProductReviewID | PRIMARY KEY constraint
PK_ProductSubcategory_ProductSubcategoryID | PRIMARY KEY constraint
PK_ScrapReason_ScrapReasonID | PRIMARY KEY constraint
PK_TransactionHistory_TransactionID | PRIMARY KEY constraint
PK_TransactionHistoryArchive_TransactionID | PRIMARY KEY constraint
PK_UnitMeasure_UnitMeasureCode | PRIMARY KEY constraint
PK_WorkOrder_WorkOrderID | PRIMARY KEY constraint
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence | PRIMARY KEY constraint
uspGetList | SQL Stored Procedure
iWorkOrder | SQL DML trigger
uWorkOrder | SQL DML trigger
UQ__Document__F73921F730F848ED | UNIQUE constraint
BillOfMaterials | Table (user-defined)
Culture | Table (user-defined)
Document | Table (user-defined)
Illustration | Table (user-defined)
Location | Table (user-defined)
Product | Table (user-defined)
ProductCategory | Table (user-defined)
ProductCostHistory | Table (user-defined)
ProductDescription | Table (user-defined)
ProductDocument | Table (user-defined)
ProductInventory | Table (user-defined)
ProductListPriceHistory | Table (user-defined)
ProductModel | Table (user-defined)
ProductModelIllustration | Table (user-defined)
ProductModelProductDescriptionCulture | Table (user-defined)
ProductPhoto | Table (user-defined)
ProductProductPhoto | Table (user-defined)
ProductReview | Table (user-defined)
ProductSubcategory | Table (user-defined)
ScrapReason | Table (user-defined)
TransactionHistory | Table (user-defined)
TransactionHistoryArchive | Table (user-defined)
UnitMeasure | Table (user-defined)
WorkOrder | Table (user-defined)
WorkOrderRouting | Table (user-defined)
vProductAndDescription | View
vProductModelCatalogDescription | View
vProductModelInstructions | View
ManuInstructionsSchemaCollection | XML Schema Collection
ProductDescriptionSchemaCollection | XML Schema Collection

## SQL

Script
CREATE SCHEMA [Production] AUTHORIZATION [dbo] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Contains objects related to products, inventory, and manufacturing.' , @level0type=N'SCHEMA',@level0name=N'Production'

#### See also

List of Schemas