schema icon 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