Here you can search through the pages of this Namespace, their attachments and the files uploaded to the system.
Note: the results will only display the items you have permissions to read.
wikibot
Schema Production Description Contains objects related to products, inventory, and manufacturing. Source
CREATE SCHEMA Production AUTHORIZATION dbo
Dependencies Reference Type Object Type Referencing Object Schema Table Production.BillOfMaterials Schema Table Production.Culture Schema Table Production.Document Schema Table Production.Illustration Schema Table Production.Location [...]
[...] Tables
Address (Person)
AddressType (Person)
AWBuildVersion (dbo)
BillOfMaterials (Production)
Contact (Person)
ContactCreditCard (Sales)
ContactType (Person)
CountryRegion (Person)
CountryRegionCurrency (Sales)
CreditCard (Sales)
Culture (Production)
Currency (Sales)
CurrencyRate (Sales)
Customer (Sales)
CustomerAddress (Sales)
DatabaseLog (dbo)
Department (HumanResources)
Document (Production)
Employee (HumanResources) [...]
wikibot
Table Production.Product Description Products sold or used in the manfacturing of sold products. Columns Column Data Type Nullable Default Description ProductID int not null Primary key for Product records. Name dbo.Name not null Name of the product. ProductNumber nvarchar(25) not null Unique product identification number. MakeFlag dbo.Flag not null ((1)) 0 = Product is purchased, 1 = Product is manufactured in-house. FinishedGoodsFlag dbo.Flag not null ((1)) 0 = Product is not a salable item. 1 = Product is salable. Color nvarchar(15) [...]
wikibot
Table Production.WorkOrder Description Manufacturing work orders. Columns Column Data Type Nullable Default Description WorkOrderID int not null Primary key for WorkOrder records. ProductID int not null Product identification number. Foreign key to Product.ProductID. OrderQty int not null Product quantity to build. StockedQty Quantity built and put in inventory. ScrappedQty smallint not null Quantity that failed inspection. StartDate datetime not null Work order start date. EndDate datetime null Work order end date. [...]
wikibot
View Production.vProductAndDescription Description Product names and descriptions. Product descriptions are provided in multiple languages. Source
CREATE VIEW [Production].[vProductAndDescription]
WITH SCHEMABINDING
AS
-- View (indexed or standard) to display products and product descriptions by language.
SELECT
p.[ProductID]
,p.[Name]
,pm.[Name] AS [ProductModel]
,pmx.[CultureID]
,pd.[Description]
FROM [Production].[Product] p
INNER JOIN [Production].[ProductModel] [...]
wikibot
Table Production.ProductModel Description Product model classification. Columns Column Data Type Nullable Default Description ProductModelID int not null Primary key for ProductModel records. Name dbo.Name not null Product model description. CatalogDescription xml null Detailed product catalog information in xml format. Instructions xml null Manufacturing instructions in xml format. rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. ModifiedDate [...]
[...] Data Type Table Person.CountryRegion Data Type Table Person.StateProvince Data Type Table Production.Culture Data Type Table Production.Location Data Type Table Production.Product Data [...]
wikibot
Table Production.ProductModelProductDescriptionCulture Description Cross-reference table mapping product descriptions and the language the description is written in. Columns Column Data Type Nullable Default Description ProductModelID int not null Primary key. Foreign key to ProductModel.ProductModelID. ProductDescriptionID int not null Primary key. Foreign key to ProductDescription.ProductDescriptionID. CultureID nchar(6) not null Culture identification number. Foreign key to Culture.CultureID. ModifiedDate datetime not null (getdate()) [...]
wikibot
Table Production.UnitMeasure Description Unit of measure lookup table. Columns Column Data Type Nullable Default Description UnitMeasureCode nchar(3) not null Primary key. Name dbo.Name not null Unit of measure description. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_UnitMeasure_UnitMeasureCode UnitMeasureCode Indexes Index Type Columns AK_UnitMeasure_Name Unique Name Detail Tables Detail Table Column Referencing Column Production.BillOfMaterials [...]
wikibot
View Production.vProductModelCatalogDescription Description Displays the content from each element in the xml column CatalogDescription for each product in the Production.ProductModel table that has catalog data. Source
CREATE VIEW [Production].[vProductModelCatalogDescription]
AS
SELECT
[ProductModelID]
,[Name]
,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";
declare namespace [...]
wikibot
View Production.vProductModelInstructions Description Displays the content from each element in the xml column Instructions for each product in the Production.ProductModel table that has manufacturing instructions. Source
CREATE VIEW [Production].[vProductModelInstructions]
AS
SELECT
[ProductModelID]
,[Name]
,[Instructions].value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions";
(/root/text())[1]', [...]
wikibot
Table Production.Location Description Product inventory and manufacturing locations. Columns Column Data Type Nullable Default Description LocationID smallint not null Primary key for Location records. Name dbo.Name not null Location description. CostRate smallmoney not null ((0.00)) Standard hourly cost of the manufacturing location. Availability decimal(8, 2) not null ((0.00)) Work capacity (in hours) of the manufacturing location. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key [...]
wikibot
Table Production.BillOfMaterials Description Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components. Columns Column Data Type Nullable Default Description BillOfMaterialsID int not null Primary key for BillOfMaterials records. ProductAssemblyID int null Parent product identification number. Foreign key to Product.ProductID. ComponentID int not null Component identification number. Foreign key to Product.ProductID. StartDate datetime not null [...]
wikibot
Table Production.TransactionHistory Description Record of each purchase order, sales order, or work order transaction year to date. Columns Column Data Type Nullable Default Description TransactionID int not null Primary key for TransactionHistory records. ProductID int not null Product identification number. Foreign key to Product.ProductID. ReferenceOrderID int not null Purchase order, sales order, or work order identification number. ReferenceOrderLineID int not null ((0)) Line number associated with the purchase order, sales order, [...]
wikibot
Table Production.ProductInventory Description Product inventory information. Columns Column Data Type Nullable Default Description ProductID int not null Product identification number. Foreign key to Product.ProductID. LocationID smallint not null Inventory location identification number. Foreign key to Location.LocationID. Shelf nvarchar(10) not null Storage compartment within an inventory location. Bin tinyint not null Storage container on a shelf in an inventory location. Quantity smallint not null ((0)) Quantity of products [...]
wikibot
XML Schema Collection Production.ProductDescriptionSchemaCollection Description Collection of XML schemas for the CatalogDescription column in the Production.ProductModel table. Source
References Dependency Type Object Type Referenced Object Schema Schema Production [...]
wikibot
Table Production.ProductDocument Description Cross-reference table mapping products to related product documents. Columns Column Data Type Nullable Default Description ProductID int not null Product identification number. Foreign key to Product.ProductID. DocumentID int not null Document identification number. Foreign key to Document.DocumentID. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_ProductDocument_ProductID_DocumentID ProductID, DocumentID Foreign [...]
wikibot
Table Production.ScrapReason Description Manufacturing failure reasons lookup table. Columns Column Data Type Nullable Default Description ScrapReasonID smallint not null Primary key for ScrapReason records. Name dbo.Name not null Failure description. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_ScrapReason_ScrapReasonID ScrapReasonID Indexes Index Type Columns AK_ScrapReason_Name Unique Name Detail Tables Detail Table Column Referencing Column [...]
wikibot
Table Production.WorkOrderRouting Description Work order details. Columns Column Data Type Nullable Default Description WorkOrderID int not null Primary key. Foreign key to WorkOrder.WorkOrderID. ProductID int not null Primary key. Foreign key to Product.ProductID. OperationSequence smallint not null Primary key. Indicates the manufacturing process sequence. LocationID smallint not null Manufacturing location where the part is processed. Foreign key to Location.LocationID. ScheduledStartDate datetime not null Planned manufacturing [...]
wikibot
Table Production.ProductSubcategory Description Product subcategories. See ProductCategory table. Columns Column Data Type Nullable Default Description ProductSubcategoryID int not null Primary key for ProductSubcategory records. ProductCategoryID int not null Product category identification number. Foreign key to ProductCategory.ProductCategoryID. Name dbo.Name not null Subcategory description. rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. [...]
wikibot
Table Production.ProductModelIllustration Description Cross-reference table mapping product models and illustrations. Columns Column Data Type Nullable Default Description ProductModelID int not null Primary key. Foreign key to ProductModel.ProductModelID. IllustrationID int not null Primary key. Foreign key to Illustration.IllustrationID. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_ProductModelIllustration_ProductModelID_IllustrationID ProductModelID, [...]
wikibot
Table Production.ProductProductPhoto Description Cross-reference table mapping products and product photos. Columns Column Data Type Nullable Default Description ProductID int not null Product identification number. Foreign key to Product.ProductID. ProductPhotoID int not null Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID. Primary dbo.Flag not null ((0)) 0 = Photo is not the principal image. 1 = Photo is the principal image. ModifiedDate datetime not null (getdate()) Date and time the record was last [...]
wikibot
XML Schema Collection Production.ManuInstructionsSchemaCollection Description Collection of XML schemas for the Instructions column in the Production.ProductModel table. Source
References [...]
wikibot
Table Production.Culture Description Lookup table containing the languages in which some AdventureWorks data is stored. Columns Column Data Type Nullable Default Description CultureID nchar(6) not null Primary key for Culture records. Name dbo.Name not null Culture description. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_Culture_CultureID CultureID Indexes Index Type Columns AK_Culture_Name Unique Name Detail Tables Detail Table Column Referencing [...]
wikibot
Table Production.ProductDescription Description Product descriptions in several languages. Columns Column Data Type Nullable Default Description ProductDescriptionID int not null Primary key for ProductDescription records. Description nvarchar(400) not null Description of the product. rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key [...]
wikibot
Table Production.ProductPhoto Description Product images. Columns Column Data Type Nullable Default Description ProductPhotoID int not null Primary key for ProductPhoto records. ThumbNailPhoto varbinary(max) null Small image of the product. ThumbnailPhotoFileName nvarchar(50) null Small image file name. LargePhoto varbinary(max) null Large image of the product. LargePhotoFileName nvarchar(50) null Large image file name. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary [...]
[...] >=(0.00)) Check constraint UnitPrice >= (0.00) Foreign Keys Relation Column Referenced Column Production.Product ProductID ProductID Purchasing.PurchaseOrderHeader PurchaseOrderID PurchaseOrderID Triggers Trigger Type iPurchaseOrderDetail ON INSERT uPurchaseOrderDetail ON UPDATE Trigger iPurchaseOrderDetail
CREATE TRIGGER [Purchasing].[iPurchaseOrderDetail] ON [Purchasing].[PurchaseOrderDetail]
AFTER INSERT AS
BEGIN
DECLARE @Count int;
SET @Count = @@ROWCOUNT;
IF @Count = 0
RETURN;
SET NOCOUNT ON;
BEGIN TRY
INSERT [...]
wikibot
Table Production.ProductReview Description Customer reviews of products they have purchased. Columns Column Data Type Nullable Default Description ProductReviewID int not null Primary key for ProductReview records. ProductID int not null Product identification number. Foreign key to Product.ProductID. ReviewerName dbo.Name not null Name of the reviewer. ReviewDate datetime not null (getdate()) Date review was submitted. EmailAddress nvarchar(50) not null Reviewer's e-mail address. Rating int not null Product rating given by the [...]
wikibot
Table Production.Document Description Product maintenance documents. Columns Column Data Type Nullable Default Description DocumentID int not null Primary key for Document records. Title nvarchar(50) not null Title of the document. FileName nvarchar(400) not null Directory path and file name of the document FileExtension nvarchar(8) not null File extension indicating the document type. For example, .doc or .txt. Revision nchar(5) not null Revision number of the document. ChangeNumber int not null ((0)) Engineering change approval [...]
wikibot
Table Production.ProductCategory Description High-level product categorization. Columns Column Data Type Nullable Default Description ProductCategoryID int not null Primary key for ProductCategory records. Name dbo.Name not null Category description. rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_ProductCategory_ProductCategoryID [...]