Difference between revisions of "Sales (schema)"

From dbscript Online Help
Jump to: navigation, search
 
(7 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
−
| '''schema
+
| '''Schema
−
| .Sales
+
| Sales
−
|-
+
|- valign="top"
 +
| '''Description
 +
| Contains objects related to customers, sales orders, and sales territories.
 
|}
 
|}
  
 +
=== Source ===
 
<pre>
 
<pre>
 
CREATE SCHEMA Sales AUTHORIZATION dbo
 
CREATE SCHEMA Sales AUTHORIZATION dbo
 
</pre>
 
</pre>
 +
 +
=== Dependencies ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Sales.ContactCreditCard_(table)|Sales.ContactCreditCard]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Sales.CountryRegionCurrency_(table)|Sales.CountryRegionCurrency]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Sales.CreditCard_(table)|Sales.CreditCard]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Sales.Currency_(table)|Sales.Currency]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Sales.CurrencyRate_(table)|Sales.CurrencyRate]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Sales.Customer_(table)|Sales.Customer]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Sales.CustomerAddress_(table)|Sales.CustomerAddress]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Sales.Individual_(table)|Sales.Individual]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Sales.SalesOrderHeaderSalesReason_(table)|Sales.SalesOrderHeaderSalesReason]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Sales.SalesPerson_(table)|Sales.SalesPerson]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Sales.SalesPersonQuotaHistory_(table)|Sales.SalesPersonQuotaHistory]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Sales.SalesReason_(table)|Sales.SalesReason]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Sales.SalesTaxRate_(table)|Sales.SalesTaxRate]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Sales.SalesTerritoryHistory_(table)|Sales.SalesTerritoryHistory]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Sales.ShoppingCartItem_(table)|Sales.ShoppingCartItem]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Sales.SpecialOffer_(table)|Sales.SpecialOffer]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Sales.SpecialOfferProduct_(table)|Sales.SpecialOfferProduct]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Sales.Store_(table)|Sales.Store]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Sales.StoreContact_(table)|Sales.StoreContact]]
 +
 +
|- valign="top"
 +
| Schema
 +
| View
 +
| [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]]
 +
 +
|- valign="top"
 +
| Schema
 +
| View
 +
| [[Sales.vIndividualDemographics_(view)|Sales.vIndividualDemographics]]
 +
 +
|- valign="top"
 +
| Schema
 +
| View
 +
| [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]]
 +
 +
|- valign="top"
 +
| Schema
 +
| View
 +
| [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]]
 +
 +
|- valign="top"
 +
| Schema
 +
| View
 +
| [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
 +
 +
|- valign="top"
 +
| Schema
 +
| XML Schema Collection
 +
| [[Sales.IndividualSurveySchemaCollection_(xml schema collection)|Sales.IndividualSurveySchemaCollection]]
 +
 +
|- valign="top"
 +
| Schema
 +
| XML Schema Collection
 +
| [[Sales.StoreSurveySchemaCollection_(xml schema collection)|Sales.StoreSurveySchemaCollection]]
 +
 +
|}
 +
  
 
== automatically generated ==
 
== automatically generated ==
Line 17: Line 175:
 
|-
 
|-
 
| '''schema
 
| '''schema
−
| .Sales
+
| Sales
−
|-
+
|- valign="top"
−
 
 
 
| '''Description
 
| '''Description
 
| Contains objects related to customers, sales orders, and sales territories.
 
| Contains objects related to customers, sales orders, and sales territories.
 
|-
 
|-
−
 
 
|}
 
|}
  
Line 29: Line 185:
 
CREATE SCHEMA Sales AUTHORIZATION dbo
 
CREATE SCHEMA Sales AUTHORIZATION dbo
 
</pre>
 
</pre>
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[Sales.ContactCreditCard_(table)|Sales.ContactCreditCard]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[Sales.CountryRegionCurrency_(table)|Sales.CountryRegionCurrency]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[Sales.CreditCard_(table)|Sales.CreditCard]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[Sales.Currency_(table)|Sales.Currency]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[Sales.CurrencyRate_(table)|Sales.CurrencyRate]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[Sales.Customer_(table)|Sales.Customer]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[Sales.CustomerAddress_(table)|Sales.CustomerAddress]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[Sales.Individual_(table)|Sales.Individual]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[Sales.SalesOrderHeaderSalesReason_(table)|Sales.SalesOrderHeaderSalesReason]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[Sales.SalesPerson_(table)|Sales.SalesPerson]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[Sales.SalesPersonQuotaHistory_(table)|Sales.SalesPersonQuotaHistory]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[Sales.SalesReason_(table)|Sales.SalesReason]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[Sales.SalesTaxRate_(table)|Sales.SalesTaxRate]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[Sales.SalesTerritoryHistory_(table)|Sales.SalesTerritoryHistory]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[Sales.ShoppingCartItem_(table)|Sales.ShoppingCartItem]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[Sales.SpecialOffer_(table)|Sales.SpecialOffer]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[Sales.SpecialOfferProduct_(table)|Sales.SpecialOfferProduct]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[Sales.Store_(table)|Sales.Store]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[Sales.StoreContact_(table)|Sales.StoreContact]]
 +
 +
|-
 +
| Schema
 +
| View
 +
| [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]]
 +
 +
|-
 +
| Schema
 +
| View
 +
| [[Sales.vIndividualDemographics_(view)|Sales.vIndividualDemographics]]
 +
 +
|-
 +
| Schema
 +
| View
 +
| [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]]
 +
 +
|-
 +
| Schema
 +
| View
 +
| [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]]
 +
 +
|-
 +
| Schema
 +
| View
 +
| [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
 +
 +
|-
 +
| Schema
 +
| XML Schema Collection
 +
| [[Sales.IndividualSurveySchemaCollection_(xml_schema_collection)|Sales.IndividualSurveySchemaCollection]]
 +
 +
|-
 +
| Schema
 +
| XML Schema Collection
 +
| [[Sales.StoreSurveySchemaCollection_(xml_schema_collection)|Sales.StoreSurveySchemaCollection]]
 +
 +
|}

Latest revision as of 23:15, 23 June 2010

wikibot[edit]

Schema Sales
Description Contains objects related to customers, sales orders, and sales territories.

Source[edit]

CREATE SCHEMA Sales AUTHORIZATION dbo

Dependencies[edit]

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


automatically generated[edit]

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=2573"