Latest revision |
Your text |
Line 1: |
Line 1: |
| == wikibot == | | == 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 ===
| |
− | <pre>
| |
− | CREATE SCHEMA Sales AUTHORIZATION dbo
| |
− | </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 ==
| |
| | | |
| {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |
| |- | | |- |
| | '''schema | | | '''schema |
− | | Sales | + | | .Sales |
− | |- valign="top"
| |
− | | '''Description
| |
− | | Contains objects related to customers, sales orders, and sales territories.
| |
| |- | | |- |
| |} | | |} |
Line 185: |
Line 11: |
| 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]]
| |
− |
| |
− | |}
| |