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.

Production (schema) — 2.5%

[...] 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 Schema Table Production.Product Schema Table [...]

dbo Name (type) — 2.3%

[...] FROM nvarchar(100) NULL Dependencies Reference Type Object Type Referencing Object Data Type Table HumanResources.Department Data Type Table HumanResources.Shift Data Type Table Person.AddressType Data Type Table Person.Contact Data Type Table Person.ContactType [...]

Sales (schema) — 2.2%

[...] Sales AUTHORIZATION dbo Dependencies Reference Type Object Type Referencing Object Schema Table Sales.ContactCreditCard Schema Table Sales.CountryRegionCurrency Schema Table Sales.CreditCard Schema Table Sales.Currency [...]

Purchasing PurchaseOrderDetail (table) — 1.4%

wikibot Table Purchasing.PurchaseOrderDetail Description Individual 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 [...]

dbo uspLogError (procedure) — 1.3%

wikibot Procedure dbo.uspLogError Description Logs error information in the ErrorLog table about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without inserting error information. Source -- uspLogError logs error information in the ErrorLog table about the -- error that caused execution to jump to the CATCH block of a -- TRY...CATCH construct. This should be executed from within the scope -- of a [...]

Sales SalesOrderHeader (table) — 1.2%

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

Sales Individual (table) — 1.0%

wikibot Table Sales.Individual Description 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 [...]

Database Objects Oracle Demo Schema — 1.0%

[...] AQ$_ORDERS_QUEUETABLE_I (IX) AQ$_ORDERS_QUEUETABLE_S (IX) AQ$_ORDERS_QUEUETABLE_T (IX) AQ$_STREAMS_QUEUE_TABLE_G (IX) AQ$_STREAMS_QUEUE_TABLE_H (IX) AQ$_STREAMS_QUEUE_TABLE_I (IX) AQ$_STREAMS_QUEUE_TABLE_S (IX) AQ$_STREAMS_QUEUE_TABLE_T (IX) CAL_MONTH_SALES_MV (SH) CATEGORIES_TAB (OE) CHANNELS (SH) COSTS (SH) COUNTRIES (HR) COUNTRIES (SH) CUSTOMERS (OE) CUSTOMERS (SH) DEPARTMENTS (HR) DR$SUP_TEXT_IDX$I [...]

Sales vStoreWithDemographics (view) — 1.0%

[...] UPPER([Sales].[Customer].[CustomerType]) = 'S'); References Dependency Type Object Type Referenced Object Select Table Person.Address Select Table Person.AddressType Select [...]

Sales SalesOrderDetail (table) — 0.9%

wikibot Table Sales.SalesOrderDetail Description 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 [...]

HR DEPARTMENTS (table) — 0.9%

wikibot Table HR.DEPARTMENTS Description Departments table that shows details of departments where employees Columns Column Data Type Nullable Default Description DEPARTMENT_ID NUMBER(4, 0) not null Primary key column of departments table. DEPARTMENT_NAME VARCHAR2(30) not null A not null column that shows name of a department. Administration, MANAGER_ID NUMBER(6, 0) null Manager_id of a department. Foreign key to employee_id column of employees table. The [...]

Purchasing PurchaseOrderHeader (table) — 0.9%

wikibot Table Purchasing.PurchaseOrderHeader 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 [...]

dbo uspPrintError (procedure) — 0.9%

[...] Type Referencing Object Child Type Child Object Execute Procedure dbo.uspLogError Execute Table Production.WorkOrder Trigger iWorkOrder Execute Table Production.WorkOrder Trigger uWorkOrder Execute Table Purchasing.PurchaseOrderDetail Trigger iPurchaseOrderDetail Execute Table Purchasing.PurchaseOrderDetail Trigger uPurchaseOrderDetail [...]

dbo ufnGetContactInformation (function) — 0.8%

wikibot Function dbo.ufnGetContactInformation Description Table value function returning the first name, last name, job title and contact type for a given contact. Source CREATE FUNCTION [dbo].[ufnGetContactInformation](@ContactID int) RETURNS @retContactInformation TABLE ( -- Columns returned by the function [ContactID] int PRIMARY KEY NOT NULL, [FirstName] [nvarchar](50) NULL, [LastName] [nvarchar](50) NULL, [JobTitle] [nvarchar](50) NULL, [ContactType] [nvarchar](50) NULL ) AS -- Returns the first [...]

Sales vIndividualCustomer (view) — 0.8%

[...] UPPER([Sales].[Customer].[CustomerType]) = 'I'); References Dependency Type Object Type Referenced Object Select Table Person.Address Select Table Person.AddressType [...]

Sales vSalesPerson (view) — 0.8%

[...] = sp.[CountryRegionCode]; References Dependency Type Object Type Referenced Object Select Table HumanResources.Employee Select Table HumanResources.EmployeeAddress [...]

HR COUNTRIES (table) — 0.8%

wikibot Table HR.COUNTRIES Description country table. Contains 25 rows. References with locations table. Columns Column Data Type Nullable Default Description COUNTRY_ID CHAR(2) not null Primary key of countries table. COUNTRY_NAME VARCHAR2(40) null Country name REGION_ID NUMBER null Region ID for the country. Foreign key to region_id column in the departments table. Primary Key Primary Key Columns COUNTRY_C_ID_PK COUNTRY_ID [...]

Purchasing vVendor (view) — 0.8%

[...] = sp.[CountryRegionCode]; References Dependency Type Object Type Referenced Object Select Table Person.Address Select Table Person.Contact Select [...]

Production TransactionHistory (table) — 0.8%

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

SH SALES (table) — 0.8%

wikibot Table SH.SALES Description facts table, without a primary key; all rows are uniquely identified by the combination of all foreign keys Columns Column Data Type Nullable Default Description PROD_ID NUMBER not null FK to the products dimension table CUST_ID NUMBER not null [...]

Person ContactType (table) — 0.7%

wikibot Table Person.ContactType 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 [...]

Sales SalesTerritory (table) — 0.7%

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

Purchasing (schema) — 0.7%

[...] Purchasing AUTHORIZATION dbo Dependencies Reference Type Object Type Referencing Object Schema Table Purchasing.ProductVendor Schema Table Purchasing.PurchaseOrderDetail Schema Table [...]

HumanResources (schema) — 0.7%

[...] HumanResources AUTHORIZATION dbo Dependencies Reference Type Object Type Referencing Object Schema Table HumanResources.Department Schema Table HumanResources.Employee Schema Table HumanResources.EmployeeAddress [...]

HumanResources vEmployee (view) — 0.6%

[...] = sp.[CountryRegionCode]; References Dependency Type Object Type Referenced Object Select Table HumanResources.Employee Select Table HumanResources.EmployeeAddress [...]

Sales Store (table) — 0.6%

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

Person CountryRegion (table) — 0.6%

wikibot Table Person.CountryRegion Description 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 [...]

HumanResources Shift (table) — 0.6%

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

Person AddressType (table) — 0.6%

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

Person (schema) — 0.6%

[...] Person AUTHORIZATION dbo Dependencies Reference Type Object Type Referencing Object Schema Table Person.Address Schema Table Person.AddressType [...]

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