ScrewTurn Wiki

Edit

wikibot

adventureworks (mie60)

Edit

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)
EmployeeAddress (HumanResources)
EmployeeDepartmentHistory (HumanResources)
EmployeePayHistory (HumanResources)
ErrorLog (dbo)
Illustration (Production)
Individual (Sales)
JobCandidate (HumanResources)
Location (Production)
Product (Production)
ProductCategory (Production)
ProductCostHistory (Production)
ProductDescription (Production)
ProductDocument (Production)
ProductInventory (Production)
ProductListPriceHistory (Production)
ProductModel (Production)
ProductModelIllustration (Production)
ProductModelProductDescriptionCulture (Production)
ProductPhoto (Production)
ProductProductPhoto (Production)
ProductReview (Production)
ProductSubcategory (Production)
ProductVendor (Purchasing)
PurchaseOrderDetail (Purchasing)
PurchaseOrderHeader (Purchasing)
SalesOrderDetail (Sales)
SalesOrderHeader (Sales)
SalesOrderHeaderSalesReason (Sales)
SalesPerson (Sales)
SalesPersonQuotaHistory (Sales)
SalesReason (Sales)
SalesTaxRate (Sales)
SalesTerritory (Sales)
SalesTerritoryHistory (Sales)
ScrapReason (Production)
Shift (HumanResources)
ShipMethod (Purchasing)
ShoppingCartItem (Sales)
SpecialOffer (Sales)
SpecialOfferProduct (Sales)
StateProvince (Person)
Store (Sales)
StoreContact (Sales)
TransactionHistory (Production)
TransactionHistoryArchive (Production)
UnitMeasure (Production)
Vendor (Purchasing)
VendorAddress (Purchasing)
VendorContact (Purchasing)
WorkOrder (Production)
WorkOrderRouting (Production)
Edit

Views

vAdditionalContactInfo (Person)
vEmployee (HumanResources)
vEmployeeDepartment (HumanResources)
vEmployeeDepartmentHistory (HumanResources)
vIndividualCustomer (Sales)
vIndividualDemographics (Sales)
vJobCandidate (HumanResources)
vJobCandidateEducation (HumanResources)
vJobCandidateEmployment (HumanResources)
vProductAndDescription (Production)
vProductModelCatalogDescription (Production)
vProductModelInstructions (Production)
vSalesPerson (Sales)
vSalesPersonSalesByFiscalYears (Sales)
vStateProvinceCountryRegion (Person)
vStoreWithDemographics (Sales)
vVendor (Purchasing)
Edit

Procedures

uspGetBillOfMaterials (dbo)
uspGetEmployeeManagers (dbo)
uspGetManagerEmployees (dbo)
uspGetWhereUsedProductID (dbo)
uspLogError (dbo)
uspPrintError (dbo)
uspUpdateEmployeeHireInfo (HumanResources)
uspUpdateEmployeeLogin (HumanResources)
uspUpdateEmployeePersonalInfo (HumanResources)
Edit

Functions

ufnGetAccountingEndDate (dbo)
ufnGetAccountingStartDate (dbo)
ufnGetDocumentStatusText (dbo)
ufnGetProductDealerPrice (dbo)
ufnGetProductListPrice (dbo)
ufnGetProductStandardCost (dbo)
ufnGetPurchaseOrderStatusText (dbo)
ufnGetSalesOrderStatusText (dbo)
ufnGetStock (dbo)
ufnLeadingZeros (dbo)
ufnGetContactInformation (dbo)
Edit

Schemas

HumanResources
Person
Production
Purchasing
Sales
Edit

Types

AccountNumber (dbo)
Flag (dbo)
Name (dbo)
NameStyle (dbo)
OrderNumber (dbo)
Phone (dbo)
Edit

XML Schema Collections

AdditionalContactInfoSchemaCollection (Person)
HRResumeSchemaCollection (HumanResources)
IndividualSurveySchemaCollection (Sales)
ManuInstructionsSchemaCollection (Production)
ProductDescriptionSchemaCollection (Production)
StoreSurveySchemaCollection (Sales)
Edit

Database Triggers

ddlDatabaseTriggerLog

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