Navigation¶

• Main Page
  

• Random Page
• Create a new Page
• All Pages
• Categories
• Navigation Paths
  

• Administration
• File Management
  

• Create Account
  

Search the wiki
»

Search in all Namespaces and all Categories
Search Files and Attachments

Filter by Category

This search, performed through 2.14 MB (338 documents, 3448 words), completed in 0.3 seconds and yielded 30 results.

Production (schema) — 9.9%

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 [...]

Sales (schema) — 5.1%

wikibot Schema Sales Description Contains objects related to customers, sales orders, and sales territories. Source CREATE SCHEMA Sales AUTHORIZATION dbo Dependencies Reference Type Object Type Referencing Object Schema Table Sales.ContactCreditCard Schema Table Sales.CountryRegionCurrency Schema [...]

Database Objects AdventureWorks — 4.4%

[...] 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) [...]

HumanResources (schema) — 3.2%

wikibot Schema HumanResources Description Contains objects related to employees and departments. Source CREATE SCHEMA HumanResources AUTHORIZATION dbo Dependencies Reference Type Object Type Referencing Object Schema Table HumanResources.Department Schema Table HumanResources.Employee Schema Table HumanResources.EmployeeAddress Schema Table HumanResources.EmployeeDepartmentHistory [...]

Production Product (table) — 2.9%

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) [...]

Production ProductModel (table) — 2.5%

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 [...]

Production WorkOrder (table) — 2.3%

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. [...]

Production ProductDescriptionSchemaCollection (xml schema collection) — 2.1%

wikibot XML Schema Collection Production.ProductDescriptionSchemaCollection Description Collection of XML schemas for the CatalogDescription column in the Production.ProductModel [...]

Production ManuInstructionsSchemaCollection (xml schema collection) — 2.1%

wikibot XML Schema Collection Production.ManuInstructionsSchemaCollection Description Collection of XML schemas for the Instructions column in the Production.ProductModel table. Source [...]

Production vProductAndDescription (view) — 2.1%

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] [...]

Person (schema) — 2.1%

wikibot Schema Person Description Contains objects related to names and addresses of customers, vendors, and employees Source CREATE SCHEMA Person AUTHORIZATION dbo Dependencies Reference Type Object Type Referencing Object [...]

Purchasing (schema) — 1.7%

[...] Purchasing Description Contains objects related to vendors and purchase orders. Source CREATE SCHEMA Purchasing AUTHORIZATION dbo Dependencies Reference Type Object Type Referencing Object Schema Table Purchasing.ProductVendor Schema [...]

Production ProductModelProductDescriptionCulture (table) — 1.4%

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()) [...]

Production UnitMeasure (table) — 1.4%

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 [...]

Production vProductModelInstructions (view) — 1.4%

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]', [...]

Production vProductModelCatalogDescription (view) — 1.4%

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 [...]

Sales StoreSurveySchemaCollection (xml schema collection) — 1.2%

wikibot XML Schema Collection Sales.StoreSurveySchemaCollection Description Collection of XML schemas for the Demographics column in the Sales.Store table. Source [...]

HumanResources HRResumeSchemaCollection (xml schema collection) — 1.2%

wikibot XML Schema Collection HumanResources.HRResumeSchemaCollection Description Collection of XML schemas for the Resume column in the HumanResources.JobCandidate table. Source [...]

Sales IndividualSurveySchemaCollection (xml schema collection) — 1.2%

wikibot XML Schema Collection Sales.IndividualSurveySchemaCollection Description Collection of XML schemas for the Demographics column in the Sales.Individual table. Source [...]

Production TransactionHistory (table) — 1.2%

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, [...]

Person AdditionalContactInfoSchemaCollection (xml schema collection) — 1.2%

wikibot XML Schema Collection Person.AdditionalContactInfoSchemaCollection Description Collection of XML schemas for the AdditionalContactInfo column in the Person.Contact table. Source [...]

Production Location (table) — 1.2%

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 [...]

Production BillOfMaterials (table) — 1.2%

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 [...]

dbo Name (type) — 1.2%

[...] 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 [...]

Production ProductProductPhoto (table) — 1.1%

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 [...]

Production ScrapReason (table) — 1.1%

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 [...]

Production WorkOrderRouting (table) — 1.1%

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 [...]

Production Culture (table) — 1.1%

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 [...]

Production ProductSubcategory (table) — 1.1%

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. [...]

Production ProductInventory (table) — 1.1%

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 [...]