# Schema: Sales

## Properties

Name | Value
--- | ---
Name | Sales
ID | 9
Owner | dbo

## Extended Properties

Name | Value
--- | ---
MS_Description | Contains objects related to customers, sales orders, and sales territories.

## Permissions

No object level permissions defined.

## Objects

Name | Type
--- | ---
CK_SalesOrderDetail_OrderQty | CHECK constraint
CK_SalesOrderDetail_UnitPrice | CHECK constraint
CK_SalesOrderDetail_UnitPriceDiscount | CHECK constraint
CK_SalesOrderHeader_DueDate | CHECK constraint
CK_SalesOrderHeader_Freight | CHECK constraint
CK_SalesOrderHeader_ShipDate | CHECK constraint
CK_SalesOrderHeader_Status | CHECK constraint
CK_SalesOrderHeader_SubTotal | CHECK constraint
CK_SalesOrderHeader_TaxAmt | CHECK constraint
CK_SalesPerson_Bonus | CHECK constraint
CK_SalesPerson_CommissionPct | CHECK constraint
CK_SalesPerson_SalesLastYear | CHECK constraint
CK_SalesPerson_SalesQuota | CHECK constraint
CK_SalesPerson_SalesYTD | CHECK constraint
CK_SalesPersonQuotaHistory_SalesQuota | CHECK constraint
CK_SalesTaxRate_TaxType | CHECK constraint
CK_SalesTerritory_CostLastYear | CHECK constraint
CK_SalesTerritory_CostYTD | CHECK constraint
CK_SalesTerritory_SalesLastYear | CHECK constraint
CK_SalesTerritory_SalesYTD | CHECK constraint
CK_SalesTerritoryHistory_EndDate | CHECK constraint
CK_ShoppingCartItem_Quantity | CHECK constraint
CK_SpecialOffer_DiscountPct | CHECK constraint
CK_SpecialOffer_EndDate | CHECK constraint
CK_SpecialOffer_MaxQty | CHECK constraint
CK_SpecialOffer_MinQty | CHECK constraint
FK_CountryRegionCurrency_CountryRegion_CountryRegionCode | FOREIGN KEY constraint
FK_CountryRegionCurrency_Currency_CurrencyCode | FOREIGN KEY constraint
FK_CurrencyRate_Currency_FromCurrencyCode | FOREIGN KEY constraint
FK_CurrencyRate_Currency_ToCurrencyCode | FOREIGN KEY constraint
FK_Customer_Person_PersonID | FOREIGN KEY constraint
FK_Customer_SalesTerritory_TerritoryID | FOREIGN KEY constraint
FK_Customer_Store_StoreID | FOREIGN KEY constraint
FK_PersonCreditCard_CreditCard_CreditCardID | FOREIGN KEY constraint
FK_PersonCreditCard_Person_BusinessEntityID | FOREIGN KEY constraint
FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID | FOREIGN KEY constraint
FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID | FOREIGN KEY constraint
FK_SalesOrderHeader_Address_BillToAddressID | FOREIGN KEY constraint
FK_SalesOrderHeader_Address_ShipToAddressID | FOREIGN KEY constraint
FK_SalesOrderHeader_CreditCard_CreditCardID | FOREIGN KEY constraint
FK_SalesOrderHeader_CurrencyRate_CurrencyRateID | FOREIGN KEY constraint
FK_SalesOrderHeader_Customer_CustomerID | FOREIGN KEY constraint
FK_SalesOrderHeader_SalesPerson_SalesPersonID | FOREIGN KEY constraint
FK_SalesOrderHeader_SalesTerritory_TerritoryID | FOREIGN KEY constraint
FK_SalesOrderHeader_ShipMethod_ShipMethodID | FOREIGN KEY constraint
FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID | FOREIGN KEY constraint
FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID | FOREIGN KEY constraint
FK_SalesPerson_Employee_BusinessEntityID | FOREIGN KEY constraint
FK_SalesPerson_SalesTerritory_TerritoryID | FOREIGN KEY constraint
FK_SalesPersonQuotaHistory_SalesPerson_BusinessEntityID | FOREIGN KEY constraint
FK_SalesTaxRate_StateProvince_StateProvinceID | FOREIGN KEY constraint
FK_SalesTerritory_CountryRegion_CountryRegionCode | FOREIGN KEY constraint
FK_SalesTerritoryHistory_SalesPerson_BusinessEntityID | FOREIGN KEY constraint
FK_SalesTerritoryHistory_SalesTerritory_TerritoryID | FOREIGN KEY constraint
FK_ShoppingCartItem_Product_ProductID | FOREIGN KEY constraint
FK_SpecialOfferProduct_Product_ProductID | FOREIGN KEY constraint
FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID | FOREIGN KEY constraint
FK_Store_BusinessEntity_BusinessEntityID | FOREIGN KEY constraint
FK_Store_SalesPerson_SalesPersonID | FOREIGN KEY constraint
PK__mobiFT__3213E83F642DD430 | PRIMARY KEY constraint
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode | PRIMARY KEY constraint
PK_CreditCard_CreditCardID | PRIMARY KEY constraint
PK_Currency_CurrencyCode | PRIMARY KEY constraint
PK_CurrencyRate_CurrencyRateID | PRIMARY KEY constraint
PK_Customer_CustomerID | PRIMARY KEY constraint
PK_PersonCreditCard_BusinessEntityID_CreditCardID | PRIMARY KEY constraint
PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID | PRIMARY KEY constraint
PK_SalesOrderHeader_SalesOrderID | PRIMARY KEY constraint
PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID | PRIMARY KEY constraint
PK_SalesPerson_BusinessEntityID | PRIMARY KEY constraint
PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate | PRIMARY KEY constraint
PK_SalesReason_SalesReasonID | PRIMARY KEY constraint
PK_SalesTaxRate_SalesTaxRateID | PRIMARY KEY constraint
PK_SalesTerritory_TerritoryID | PRIMARY KEY constraint
PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID | PRIMARY KEY constraint
PK_ShoppingCartItem_ShoppingCartItemID | PRIMARY KEY constraint
PK_SpecialOffer_SpecialOfferID | PRIMARY KEY constraint
PK_SpecialOfferProduct_SpecialOfferID_ProductID | PRIMARY KEY constraint
PK_Store_BusinessEntityID | PRIMARY KEY constraint
ufn_SalesByStore | SQL inline table-valued function
iduSalesOrderDetail | SQL DML trigger
uSalesOrderHeader | SQL DML trigger
CountryRegionCurrency | Table (user-defined)
CreditCard | Table (user-defined)
Currency | Table (user-defined)
CurrencyRate | Table (user-defined)
Customer | Table (user-defined)
mobiFT | Table (user-defined)
PersonCreditCard | Table (user-defined)
SalesOrderDetail | Table (user-defined)
SalesOrderHeader | Table (user-defined)
SalesOrderHeaderSalesReason | Table (user-defined)
SalesPerson | Table (user-defined)
SalesPersonQuotaHistory | Table (user-defined)
SalesReason | Table (user-defined)
SalesTaxRate | Table (user-defined)
SalesTerritory | Table (user-defined)
SalesTerritoryHistory | Table (user-defined)
ShoppingCartItem | Table (user-defined)
SpecialOffer | Table (user-defined)
SpecialOfferProduct | Table (user-defined)
Store | Table (user-defined)
mobiFTView | View
vIndividualCustomer | View
vPersonDemographics | View
vSalesPerson | View
vSalesPersonSalesByFiscalYears | View
vStoreWithAddresses | View
vStoreWithContacts | View
vStoreWithDemographics | View
StoreSurveySchemaCollection | XML Schema Collection

## SQL

Script
CREATE SCHEMA [Sales] AUTHORIZATION [dbo] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Contains objects related to customers, sales orders, and sales territories.' , @level0type=N'SCHEMA',@level0name=N'Sales'

#### See also

List of Schemas