schema icon 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 true
Control dbo true
Delete
Execute dbo true
Insert dbo true
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 true

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