Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Discuss (0)
View Page Code
History
public application_service_map (table)
Print
RSS
Modified on 2011/08/27 11:43
by
wikibot
Categorized as
Uncategorized
public applications (table)
public ifservices (table)
dbo AccountNumber (type)
dbo AWBuildVersion (table)
dbo DatabaseLog (table)
dbo ErrorLog (table)
dbo Flag (type)
dbo Name (type)
dbo NameStyle (type)
dbo OrderNumber (type)
dbo Phone (type)
dbo ufnGetAccountingEndDate (function)
dbo ufnGetAccountingStartDate (function)
dbo ufnGetContactInformation (function)
dbo ufnGetDocumentStatusText (function)
dbo ufnGetProductDealerPrice (function)
dbo ufnGetProductListPrice (function)
dbo ufnGetProductStandardCost (function)
dbo ufnGetPurchaseOrderStatusText (function)
dbo ufnGetSalesOrderStatusText (function)
dbo ufnGetStock (function)
dbo ufnLeadingZeros (function)
dbo uspGetBillOfMaterials (procedure)
dbo uspGetEmployeeManagers (procedure)
dbo uspGetManagerEmployees (procedure)
dbo uspGetWhereUsedProductID (procedure)
dbo uspLogError (procedure)
dbo uspPrintError (procedure)
ddlDatabaseTriggerLog (database trigger)
HumanResources (schema)
HumanResources Department (table)
HumanResources Employee (table)
HumanResources EmployeeAddress (table)
HumanResources EmployeeDepartmentHistory (table)
HumanResources EmployeePayHistory (table)
HumanResources HRResumeSchemaCollection (xml schema collection)
HumanResources JobCandidate (table)
HumanResources Shift (table)
HumanResources uspUpdateEmployeeHireInfo (procedure)
HumanResources uspUpdateEmployeeLogin (procedure)
HumanResources uspUpdateEmployeePersonalInfo (procedure)
HumanResources vEmployee (view)
HumanResources vEmployeeDepartment (view)
HumanResources vEmployeeDepartmentHistory (view)
HumanResources vJobCandidate (view)
HumanResources vJobCandidateEducation (view)
HumanResources vJobCandidateEmployment (view)
Person (schema)
Person AdditionalContactInfoSchemaCollection (xml schema collection)
Person Address (table)
Person AddressType (table)
Person Contact (table)
Person ContactType (table)
Person CountryRegion (table)
Person StateProvince (table)
Person vAdditionalContactInfo (view)
Person vStateProvinceCountryRegion (view)
Production (schema)
Production BillOfMaterials (table)
Production Culture (table)
Production Document (table)
Production Illustration (table)
Production Location (table)
Production ManuInstructionsSchemaCollection (xml schema collection)
Production Product (table)
Production ProductCategory (table)
Production ProductCostHistory (table)
Production ProductDescription (table)
Production ProductDescriptionSchemaCollection (xml schema collection)
Production ProductDocument (table)
Production ProductInventory (table)
Production ProductListPriceHistory (table)
Production ProductModel (table)
Production ProductModelIllustration (table)
Production ProductModelProductDescriptionCulture (table)
Production ProductPhoto (table)
Production ProductProductPhoto (table)
Production ProductReview (table)
Production ProductSubcategory (table)
Production ScrapReason (table)
Production TransactionHistory (table)
Production TransactionHistoryArchive (table)
Production UnitMeasure (table)
Production vProductAndDescription (view)
Production vProductModelCatalogDescription (view)
Production vProductModelInstructions (view)
Production WorkOrder (table)
Production WorkOrderRouting (table)
Purchasing (schema)
Purchasing ProductVendor (table)
Purchasing PurchaseOrderDetail (table)
Purchasing PurchaseOrderHeader (table)
Purchasing ShipMethod (table)
Purchasing Vendor (table)
Purchasing VendorAddress (table)
Purchasing VendorContact (table)
Purchasing vVendor (view)
Sales (schema)
Sales ContactCreditCard (table)
Sales CountryRegionCurrency (table)
Sales CreditCard (table)
Sales Currency (table)
Sales CurrencyRate (table)
Sales Customer (table)
Sales CustomerAddress (table)
Sales Individual (table)
Sales IndividualSurveySchemaCollection (xml schema collection)
Sales SalesOrderDetail (table)
Sales SalesOrderHeader (table)
Sales SalesOrderHeaderSalesReason (table)
Sales SalesPerson (table)
Sales SalesPersonQuotaHistory (table)
Sales SalesReason (table)
Sales SalesTaxRate (table)
Sales SalesTerritory (table)
Sales SalesTerritoryHistory (table)
Sales ShoppingCartItem (table)
Sales SpecialOffer (table)
Sales SpecialOfferProduct (table)
Sales Store (table)
Sales StoreContact (table)
Sales StoreSurveySchemaCollection (xml schema collection)
Sales vIndividualCustomer (view)
Sales vIndividualDemographics (view)
Sales vSalesPerson (view)
Sales vSalesPersonSalesByFiscalYears (view)
Sales vStoreWithDemographics (view)
dbo ErrorLog (table)
dbo uspPrintError (procedure)
HumanResources uspUpdateEmployeeHireInfo (procedure)
HumanResources uspUpdateEmployeeLogin (procedure)
HumanResources uspUpdateEmployeePersonalInfo (procedure)
Production WorkOrder (table)
Purchasing PurchaseOrderDetail (table)
Purchasing PurchaseOrderHeader (table)
Purchasing Vendor (table)
Sales SalesOrderDetail (table)
Sales SalesOrderHeader (table)
Sales Store (table)
public node (table)
Database Objects AdventureWorks
Database Objects OpenNMS
Database Objects Oracle Demo Schema
SnippetsAndTemplates
WikiMarkup
WikiMarkup-Pictures
WikiMarkup-Tables
public applications (table)
public ifservices (table)
dbo AccountNumber (type)
dbo AWBuildVersion (table)
dbo DatabaseLog (table)
dbo ErrorLog (table)
dbo Flag (type)
dbo Name (type)
dbo NameStyle (type)
dbo OrderNumber (type)
dbo Phone (type)
dbo ufnGetAccountingEndDate (function)
dbo ufnGetAccountingStartDate (function)
dbo ufnGetContactInformation (function)
dbo ufnGetDocumentStatusText (function)
dbo ufnGetProductDealerPrice (function)
dbo ufnGetProductListPrice (function)
dbo ufnGetProductStandardCost (function)
dbo ufnGetPurchaseOrderStatusText (function)
dbo ufnGetSalesOrderStatusText (function)
dbo ufnGetStock (function)
dbo ufnLeadingZeros (function)
dbo uspGetBillOfMaterials (procedure)
dbo uspGetEmployeeManagers (procedure)
dbo uspGetManagerEmployees (procedure)
dbo uspGetWhereUsedProductID (procedure)
dbo uspLogError (procedure)
dbo uspPrintError (procedure)
ddlDatabaseTriggerLog (database trigger)
HumanResources (schema)
HumanResources Department (table)
HumanResources Employee (table)
HumanResources EmployeeAddress (table)
HumanResources EmployeeDepartmentHistory (table)
HumanResources EmployeePayHistory (table)
HumanResources HRResumeSchemaCollection (xml schema collection)
HumanResources JobCandidate (table)
HumanResources Shift (table)
HumanResources uspUpdateEmployeeHireInfo (procedure)
HumanResources uspUpdateEmployeeLogin (procedure)
HumanResources uspUpdateEmployeePersonalInfo (procedure)
HumanResources vEmployee (view)
HumanResources vEmployeeDepartment (view)
HumanResources vEmployeeDepartmentHistory (view)
HumanResources vJobCandidate (view)
HumanResources vJobCandidateEducation (view)
HumanResources vJobCandidateEmployment (view)
Person (schema)
Person AdditionalContactInfoSchemaCollection (xml schema collection)
Person Address (table)
Person AddressType (table)
Person Contact (table)
Person ContactType (table)
Person CountryRegion (table)
Person StateProvince (table)
Person vAdditionalContactInfo (view)
Person vStateProvinceCountryRegion (view)
Production (schema)
Production BillOfMaterials (table)
Production Culture (table)
Production Document (table)
Production Illustration (table)
Production Location (table)
Production ManuInstructionsSchemaCollection (xml schema collection)
Production Product (table)
Production ProductCategory (table)
Production ProductCostHistory (table)
Production ProductDescription (table)
Production ProductDescriptionSchemaCollection (xml schema collection)
Production ProductDocument (table)
Production ProductInventory (table)
Production ProductListPriceHistory (table)
Production ProductModel (table)
Production ProductModelIllustration (table)
Production ProductModelProductDescriptionCulture (table)
Production ProductPhoto (table)
Production ProductProductPhoto (table)
Production ProductReview (table)
Production ProductSubcategory (table)
Production ScrapReason (table)
Production TransactionHistory (table)
Production TransactionHistoryArchive (table)
Production UnitMeasure (table)
Production vProductAndDescription (view)
Production vProductModelCatalogDescription (view)
Production vProductModelInstructions (view)
Production WorkOrder (table)
Production WorkOrderRouting (table)
Purchasing (schema)
Purchasing ProductVendor (table)
Purchasing PurchaseOrderDetail (table)
Purchasing PurchaseOrderHeader (table)
Purchasing ShipMethod (table)
Purchasing Vendor (table)
Purchasing VendorAddress (table)
Purchasing VendorContact (table)
Purchasing vVendor (view)
Sales (schema)
Sales ContactCreditCard (table)
Sales CountryRegionCurrency (table)
Sales CreditCard (table)
Sales Currency (table)
Sales CurrencyRate (table)
Sales Customer (table)
Sales CustomerAddress (table)
Sales Individual (table)
Sales IndividualSurveySchemaCollection (xml schema collection)
Sales SalesOrderDetail (table)
Sales SalesOrderHeader (table)
Sales SalesOrderHeaderSalesReason (table)
Sales SalesPerson (table)
Sales SalesPersonQuotaHistory (table)
Sales SalesReason (table)
Sales SalesTaxRate (table)
Sales SalesTerritory (table)
Sales SalesTerritoryHistory (table)
Sales ShoppingCartItem (table)
Sales SpecialOffer (table)
Sales SpecialOfferProduct (table)
Sales Store (table)
Sales StoreContact (table)
Sales StoreSurveySchemaCollection (xml schema collection)
Sales vIndividualCustomer (view)
Sales vIndividualDemographics (view)
Sales vSalesPerson (view)
Sales vSalesPersonSalesByFiscalYears (view)
Sales vStoreWithDemographics (view)
(10)
»
IX ORDER_EVENT_TYP (type)
»
Database Objects AdventureWorks
»
public application_service_map (table)
[X]
»
SH SUPPLEMENTARY_DEMOGRAPHICS (table)
»
public vulnnxtid (sequence)
»
OE PRODUCT_INFORMATION_TYP (type)
»
Main Page
»
public iprouteinterface (table)
»
dbo uspLogError (procedure)
»
OE BOMBAY_INVENTORY (view)
»
IX ORDER_EVENT_TYP (type)
»
Database Objects AdventureWorks
»
public application_service_map (table)
wikibot
¶
Table
public.application_service_map
Columns
¶
Column
Data Type
Nullable
Default
Description
appid
integer
null
ifserviceid
integer
null
Indexes
¶
Index
Type
Columns
appid_idx
appid
appid_ifserviceid_idex
appid, ifserviceid
ifserviceid_idx
ifserviceid
Foreign Keys
¶
Relation
Column
Referenced Column
public.applications
appid
id
public.ifservices
ifserviceid
id
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.