Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Search Engine

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.



Filter by Category


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

dbo Name (type) — 3.0%

wikibot type dbo.Name Source CREATE TYPE dbo.[Name] FROM nvarchar(100) NULL Dependencies Reference Type Object Type Referencing Object Data Type Table HumanResources.Department Data Type [...]

Sales SalesOrderHeader (table) — 1.5%

[...] Table Sales.SalesOrderHeader Description General sales order information. Columns Column Data Type Nullable Default Description SalesOrderID int not null Primary key. RevisionNumber tinyint not null ((0)) Incremental number to track changes to the sales order over time. OrderDate datetime not null (getdate()) Dates the sales order was created. DueDate datetime not null Date the order is due to the customer. ShipDate datetime null Date the order was shipped to the customer. Status tinyint not null ((1)) Order current status. 1 = In process; 2 = [...]

Purchasing Vendor (table) — 1.4%

[...] Companies from whom Adventure Works Cycles purchases parts or other goods. Columns Column Data Type Nullable Default Description VendorID int not null Primary key for Vendor records. AccountNumber dbo.AccountNumber not null Vendor account (identification) number. Name dbo.Name not null Company name. CreditRating tinyint not null 1 = Superior, 2 = Excellent, 3 = Above average, 4 = Average, 5 = Below average PreferredVendorStatus dbo.Flag not null ((1)) 0 = Do not use if another vendor is available. 1 = Preferred over other vendors supplying the [...]

Sales Store (table) — 1.3%

[...] Sales.Store Description Customers (resellers) of Adventure Works products. Columns Column Data Type Nullable Default Description CustomerID int not null Primary key. Foreign key to Customer.CustomerID. Name dbo.Name not null Name of the store. SalesPersonID int null ID of the sales person assigned to the customer. Foreign key to SalesPerson.SalesPersonID. Demographics xml null Demographic informationg about the store such as the number of employees, annual sales and store type. rowguid uniqueidentifier not null (newid()) [...]

Person Contact (table) — 1.3%

[...] Description Names of each employee, customer contact, and vendor contact. Columns Column Data Type Nullable Default Description ContactID int not null Primary key for Contact records. NameStyle dbo.NameStyle not null ((0)) 0 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (last name, first name) order. Title nvarchar(8) null A courtesy title. For example, Mr. or Ms. FirstName dbo.Name not null First name of the person. MiddleName dbo.Name null Middle name or middle initial of the [...]

dbo Flag (type) — 1.2%

wikibot type dbo.Flag Source CREATE TYPE dbo.Flag FROM bit NOT NULL Dependencies Reference Type [...]

OE XDBPO_TYPE (type) — 1.0%

wikibot Type OE.XDBPO_TYPE Source CREATE OR REPLACE TYPE "XDBPO_TYPE" AS OBJECT ("SYS_XDBPD$" "XDB"."XDB$RAW_LIST_T","Reference" VARCHAR2(30 CHAR),"ACTIONS" "XDBPO_ACTIONS_TYPE","REJECTION" [...]

Person StateProvince (table) — 1.0%

[...] Table Person.StateProvince Description State and province lookup table. Columns Column Data Type Nullable Default Description StateProvinceID int not null Primary key for StateProvince records. StateProvinceCode nchar(3) not null ISO standard state or province code. CountryRegionCode nvarchar(3) not null ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode. IsOnlyStateProvinceFlag dbo.Flag not null ((1)) 0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode. Name dbo.Name not null [...]

Production Product (table) — 1.0%

[...] 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) null Product color. SafetyStockLevel [...]

Sales Individual (table) — 1.0%

[...] Demographic data about customers that purchase Adventure Works products online. Columns Column Data Type Nullable Default Description CustomerID int not null Unique customer identification number. Foreign key to Customer.CustomerID. ContactID int not null Identifies the customer in the Contact table. Foreign key to Contact.ContactID. Demographics xml null Personal information such as hobbies, and income collected from online shoppers. Used for sales analysis. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary [...]

Production ProductModel (table) — 1.0%

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

Person AddressType (table) — 0.9%

[...] Person.AddressType Description Types of addresses stored in the Address table. Columns Column Data Type Nullable Default Description AddressTypeID int not null Primary key for AddressType records. Name dbo.Name not null Address type description. For example, Billing, Home, or Shipping. 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 [...]

Sales SalesTerritory (table) — 0.9%

[...] Table Sales.SalesTerritory Description Sales territory lookup table. Columns Column Data Type Nullable Default Description TerritoryID int not null Primary key for SalesTerritory records. Name dbo.Name not null Sales territory description CountryRegionCode nvarchar(3) not null ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode. Group nvarchar(50) not null Geographic area to which the sales territory belong. SalesYTD money not null ((0.00)) Sales in the territory year to date. SalesLastYear money not null [...]

HumanResources Employee (table) — 0.9%

[...] Description Employee information such as salary, department, and title. Columns Column Data Type Nullable Default Description EmployeeID int not null Primary key for Employee records. NationalIDNumber nvarchar(15) not null Unique national identification number such as a social security number. ContactID int not null Identifies the employee in the Contact table. Foreign key to Contact.ContactID. LoginID nvarchar(256) not null Network login. ManagerID int null Manager to whom the employee is assigned. Foreign Key to Employee.M Title nvarchar(50) [...]

Sales SalesOrderDetail (table) — 0.9%

[...] Individual products associated with a specific sales order. See SalesOrderHeader. Columns Column Data Type Nullable Default Description SalesOrderID int not null Primary key. Foreign key to SalesOrderHeader.SalesOrderID. SalesOrderDetailID int not null Primary key. One incremental unique number per product sold. CarrierTrackingNumber nvarchar(25) null Shipment tracking number supplied by the shipper. OrderQty smallint not null Quantity ordered per product. ProductID int not null Product sold to customer. Foreign key to Product.ProductID. SpecialOfferID [...]

Purchasing PurchaseOrderDetail (table) — 0.9%

[...] products associated with a specific purchase order. See PurchaseOrderHeader. Columns Column Data Type Nullable Default Description PurchaseOrderID int not null Primary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID. PurchaseOrderDetailID int not null Primary key. One line number per purchased product. DueDate datetime not null Date the product is expected to be received. OrderQty smallint not null Quantity ordered. ProductID int not null Product identification number. Foreign key to Product.ProductID. UnitPrice money not null Vendor's [...]

Purchasing PurchaseOrderHeader (table) — 0.9%

[...] Description General purchase order information. See PurchaseOrderDetail. Columns Column Data Type Nullable Default Description PurchaseOrderID int not null Primary key. RevisionNumber tinyint not null ((0)) Incremental number to track changes to the purchase order over time. Status tinyint not null ((1)) Order current status. 1 = Pending; 2 = Approved; 3 = Rejected; 4 = Complete EmployeeID int not null Employee who created the purchase order. Foreign key to Employee.EmployeeID. VendorID int not null Vendor with whom the purchase order is placed. [...]

Person ContactType (table) — 0.9%

[...] Description Lookup table containing the types of contacts stored in Contact. Columns Column Data Type Nullable Default Description ContactTypeID int not null Primary key for ContactType records. Name dbo.Name not null Contact type description. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_ContactType_ContactTypeID ContactTypeID Indexes Index Type Columns AK_ContactType_Name Unique Name Detail Tables Detail [...]

Person CountryRegion (table) — 0.8%

[...] Lookup table containing the ISO standard codes for countries and regions. Columns Column Data Type Nullable Default Description CountryRegionCode nvarchar(3) not null ISO standard code for countries and regions. Name dbo.Name not null Country or region name. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_CountryRegion_CountryRegionCode CountryRegionCode Indexes Index Type Columns AK_CountryRegion_Name Unique Name Detail Tables Detail [...]

Database Objects Oracle Demo Schema — 0.8%

[...] (PM) TEXTDOC_TYP (PM) WAREHOUSE_TYP (OE) XDBPO_ACTION_COLLECTION (OE) XDBPO_ACTION_TYPE (OE) XDBPO_ACTIONS_TYPE (OE) XDBPO_LINEITEM_COLLECTION [...]

dbo AccountNumber (type) — 0.8%

wikibot type dbo.AccountNumber Source CREATE TYPE dbo.AccountNumber FROM nvarchar(30) [...]

HumanResources Shift (table) — 0.8%

[...] wikibot Table HumanResources.Shift Description Work shift lookup table. Columns Column Data Type Nullable Default Description ShiftID tinyint not null Primary key for Shift records. Name dbo.Name not null Shift description. StartTime datetime not null Shift start time. EndTime datetime not null Shift end time. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_Shift_ShiftID ShiftID Indexes Index Type Columns AK_Shift_Name Unique [...]

HumanResources Department (table) — 0.8%

[...] table containing the departments within the Adventure Works Cycles company. Columns Column Data Type Nullable Default Description DepartmentID smallint not null Primary key for Department records. Name dbo.Name not null Name of the department. GroupName dbo.Name not null Name of the group to which the department belongs. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_Department_DepartmentID DepartmentID Indexes Index Type Columns AK_Department_Name [...]

dbo NameStyle (type) — 0.7%

wikibot type dbo.NameStyle Source CREATE TYPE dbo.NameStyle [...]

HumanResources JobCandidate (table) — 0.7%

[...] HumanResources.JobCandidate Description Résumés submitted to Human Resources by job applicants. Columns Column Data Type Nullable Default Description JobCandidateID int not null Primary key for JobCandidate records. EmployeeID int null Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID. Resume xml null Résumé in XML format. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_JobCandidate_JobCandidateID JobCandidateID Indexes Index Type [...]

OE XDBPO_LINEITEM_TYPE (type) — 0.7%

wikibot Type OE.XDBPO_LINEITEM_TYPE Source CREATE OR REPLACE TYPE "XDBPO_LINEITEM_

Production TransactionHistory (table) — 0.7%

[...] 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, or work order. TransactionDate datetime not null (getdate()) Date and [...]

Sales StoreContact (table) — 0.7%

[...] Sales.StoreContact Description Cross-reference table mapping stores and their employees. Columns Column Data Type Nullable Default Description CustomerID int not null Store identification number. Foreign key to Customer.CustomerID. ContactID int not null Contact (store employee) identification number. Foreign key to Contact.ContactID. ContactTypeID int not null Contact type such as owner or purchasing agent. Foreign key to ContactType.ContactTypeID. rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying the [...]

dbo Phone (type) — 0.7%

wikibot type dbo.Phone Source CREATE TYPE dbo.Phone [...]

Sales SalesPerson (table) — 0.7%

[...] Sales.SalesPerson Description Sales representative current information. Columns Column Data Type Nullable Default Description SalesPersonID int not null Primary key for SalesPerson records. TerritoryID int null Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID. SalesQuota money null Projected yearly sales. Bonus money not null ((0.00)) Bonus due if quota is met. CommissionPct smallmoney not null ((0.00)) Commision percent received per sale. SalesYTD money not null ((0.00)) Sales total year to date. SalesLastYear [...]

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.