ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
Sales_(schema)
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Schema''' | Sales |- valign="top" | '''Description''' | Contains objects related to customers, sales orders, and sales territories. |} === Source === {{{{<nowiki> CREATE SCHEMA Sales AUTHORIZATION dbo </nowiki>}}}} === 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 == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''schema''' | Sales |- valign="top" | '''Description''' | Contains objects related to customers, sales orders, and sales territories. |- |} {{{{<nowiki> CREATE SCHEMA Sales AUTHORIZATION dbo </nowiki>}}}} {| 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]] |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.