Difference between revisions of "Sales (schema)"

From dbscript Online Help
Jump to: navigation, search
Line 16: Line 16:
 
|-
 
|-
 
| '''schema
 
| '''schema
−
| .Sales
+
| Sales
 
|- valign="top"
 
|- valign="top"
  
Line 32: Line 32:
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 
| '''Referencing Object
 
| '''Referencing Object
−
| '''Object Type
 
−
| '''Reference Type
 
  
 
|-
 
|-
 +
| Schema
 +
| Table
 
| [[Sales.ContactCreditCard_(table)|Sales.ContactCreditCard]]
 
| [[Sales.ContactCreditCard_(table)|Sales.ContactCreditCard]]
 +
 +
|-
 +
| Schema
 
| Table
 
| Table
 +
| [[Sales.CountryRegionCurrency_(table)|Sales.CountryRegionCurrency]]
 +
 +
|-
 
| Schema
 
| Schema
 +
| Table
 +
| [[Sales.CreditCard_(table)|Sales.CreditCard]]
 +
 
|-
 
|-
−
| [[Sales.CountryRegionCurrency_(table)|Sales.CountryRegionCurrency]]
+
| Schema
 
| Table
 
| Table
 +
| [[Sales.Currency_(table)|Sales.Currency]]
 +
 +
|-
 
| Schema
 
| Schema
 +
| Table
 +
| [[Sales.CurrencyRate_(table)|Sales.CurrencyRate]]
 +
 
|-
 
|-
−
| [[Sales.CreditCard_(table)|Sales.CreditCard]]
+
| Schema
 
| Table
 
| Table
 +
| [[Sales.Customer_(table)|Sales.Customer]]
 +
 +
|-
 
| Schema
 
| Schema
 +
| Table
 +
| [[Sales.CustomerAddress_(table)|Sales.CustomerAddress]]
 +
 
|-
 
|-
−
| [[Sales.Currency_(table)|Sales.Currency]]
+
| Schema
 
| Table
 
| Table
 +
| [[Sales.Individual_(table)|Sales.Individual]]
 +
 +
|-
 
| Schema
 
| Schema
 +
| Table
 +
| [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
 +
 
|-
 
|-
−
| [[Sales.CurrencyRate_(table)|Sales.CurrencyRate]]
+
| Schema
 
| Table
 
| Table
 +
| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 +
 +
|-
 
| Schema
 
| Schema
 +
| Table
 +
| [[Sales.SalesOrderHeaderSalesReason_(table)|Sales.SalesOrderHeaderSalesReason]]
 +
 
|-
 
|-
−
| [[Sales.Customer_(table)|Sales.Customer]]
+
| Schema
 
| Table
 
| Table
 +
| [[Sales.SalesPerson_(table)|Sales.SalesPerson]]
 +
 +
|-
 
| Schema
 
| Schema
 +
| Table
 +
| [[Sales.SalesPersonQuotaHistory_(table)|Sales.SalesPersonQuotaHistory]]
 +
 
|-
 
|-
−
| [[Sales.CustomerAddress_(table)|Sales.CustomerAddress]]
+
| Schema
 
| Table
 
| Table
 +
| [[Sales.SalesReason_(table)|Sales.SalesReason]]
 +
 +
|-
 
| Schema
 
| Schema
 +
| Table
 +
| [[Sales.SalesTaxRate_(table)|Sales.SalesTaxRate]]
 +
 
|-
 
|-
−
| [[Sales.Individual_(table)|Sales.Individual]]
+
| Schema
 
| Table
 
| Table
 +
| [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]]
 +
 +
|-
 
| Schema
 
| Schema
 +
| Table
 +
| [[Sales.SalesTerritoryHistory_(table)|Sales.SalesTerritoryHistory]]
 +
 
|-
 
|-
−
| [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
 
−
| Table
 
 
| Schema
 
| Schema
−
|-
 
−
| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 
 
| Table
 
| Table
−
| Schema
+
| [[Sales.ShoppingCartItem_(table)|Sales.ShoppingCartItem]]
 +
 
 
|-
 
|-
−
| [[Sales.SalesOrderHeaderSalesReason_(table)|Sales.SalesOrderHeaderSalesReason]]
 
−
| Table
 
 
| Schema
 
| Schema
−
|-
 
−
| [[Sales.SalesPerson_(table)|Sales.SalesPerson]]
 
 
| Table
 
| Table
−
| Schema
+
| [[Sales.SpecialOffer_(table)|Sales.SpecialOffer]]
 +
 
 
|-
 
|-
−
| [[Sales.SalesPersonQuotaHistory_(table)|Sales.SalesPersonQuotaHistory]]
 
−
| Table
 
 
| Schema
 
| Schema
−
|-
 
−
| [[Sales.SalesReason_(table)|Sales.SalesReason]]
 
 
| Table
 
| Table
−
| Schema
+
| [[Sales.SpecialOfferProduct_(table)|Sales.SpecialOfferProduct]]
 +
 
 
|-
 
|-
−
| [[Sales.SalesTaxRate_(table)|Sales.SalesTaxRate]]
 
−
| Table
 
 
| Schema
 
| Schema
−
|-
 
−
| [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]]
 
 
| Table
 
| Table
−
| Schema
+
| [[Sales.Store_(table)|Sales.Store]]
 +
 
 
|-
 
|-
−
| [[Sales.SalesTerritoryHistory_(table)|Sales.SalesTerritoryHistory]]
 
−
| Table
 
 
| Schema
 
| Schema
−
|-
 
−
| [[Sales.ShoppingCartItem_(table)|Sales.ShoppingCartItem]]
 
 
| Table
 
| Table
−
| Schema
+
| [[Sales.StoreContact_(table)|Sales.StoreContact]]
 +
 
 
|-
 
|-
−
| [[Sales.SpecialOffer_(table)|Sales.SpecialOffer]]
 
−
| Table
 
 
| Schema
 
| Schema
 +
| View
 +
| [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]]
 +
 
|-
 
|-
−
| [[Sales.SpecialOfferProduct_(table)|Sales.SpecialOfferProduct]]
 
−
| Table
 
 
| Schema
 
| Schema
 +
| View
 +
| [[Sales.vIndividualDemographics_(view)|Sales.vIndividualDemographics]]
 +
 
|-
 
|-
−
| [[Sales.Store_(table)|Sales.Store]]
 
−
| Table
 
 
| Schema
 
| Schema
 +
| View
 +
| [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]]
 +
 
|-
 
|-
−
| [[Sales.StoreContact_(table)|Sales.StoreContact]]
 
−
| Table
 
 
| Schema
 
| Schema
−
|-
 
−
| [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]]
 
 
| View
 
| View
−
| Schema
+
| [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]]
 +
 
 
|-
 
|-
−
| [[Sales.vIndividualDemographics_(view)|Sales.vIndividualDemographics]]
 
−
| View
 
 
| Schema
 
| Schema
−
|-
 
−
| [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]]
 
 
| View
 
| View
−
| Schema
+
| [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
 +
 
 
|-
 
|-
−
| [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]]
 
−
| View
 
 
| Schema
 
| Schema
 +
| XML Schema Collection
 +
| [[Sales.IndividualSurveySchemaCollection_(xml_schema_collection)|Sales.IndividualSurveySchemaCollection]]
 +
 
|-
 
|-
−
| [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
 
−
| View
 
 
| Schema
 
| Schema
−
|-
 
−
| [[Sales.IndividualSurveySchemaCollection_(xml_schema_collection)|Sales.IndividualSurveySchemaCollection]]
 
 
| XML Schema Collection
 
| XML Schema Collection
−
| Schema
 
−
|-
 
 
| [[Sales.StoreSurveySchemaCollection_(xml_schema_collection)|Sales.StoreSurveySchemaCollection]]
 
| [[Sales.StoreSurveySchemaCollection_(xml_schema_collection)|Sales.StoreSurveySchemaCollection]]
−
| XML Schema Collection
+
 
−
| Schema
 
 
|}
 
|}

Revision as of 06:38, 30 November 2009

wikibot

schema .Sales 
CREATE SCHEMA Sales AUTHORIZATION dbo

automatically generated

schema Sales
Description Contains objects related to customers, sales orders, and sales territories. 
CREATE SCHEMA Sales AUTHORIZATION dbo


Reference Type Object Type Referencing Object
Schema Table Sales.ContactCreditCard
Schema Table Sales.CountryRegionCurrency
Schema Table Sales.CreditCard
Schema Table Sales.Currency
Schema Table Sales.CurrencyRate
Schema Table Sales.Customer
Schema Table Sales.CustomerAddress
Schema Table Sales.Individual
Schema Table Sales.SalesOrderDetail
Schema Table Sales.SalesOrderHeader
Schema Table Sales.SalesOrderHeaderSalesReason
Schema Table Sales.SalesPerson
Schema Table Sales.SalesPersonQuotaHistory
Schema Table Sales.SalesReason
Schema Table Sales.SalesTaxRate
Schema Table Sales.SalesTerritory
Schema Table Sales.SalesTerritoryHistory
Schema Table Sales.ShoppingCartItem
Schema Table Sales.SpecialOffer
Schema Table Sales.SpecialOfferProduct
Schema Table Sales.Store
Schema Table Sales.StoreContact
Schema View Sales.vIndividualCustomer
Schema View Sales.vIndividualDemographics
Schema View Sales.vSalesPerson
Schema View Sales.vSalesPersonSalesByFiscalYears
Schema View Sales.vStoreWithDemographics
Schema XML Schema Collection Sales.IndividualSurveySchemaCollection
Schema XML Schema Collection Sales.StoreSurveySchemaCollection
Retrieved from "http://dbshelp.devio.at/index.php?title=Sales_(schema)&oldid=1688"