| Object |
HumanResources.EmployeePayHistory |
schema/table |
MS_Description |
Employee pay history. |
| Object |
HumanResources.EmployeePayHistory.BusinessEntityID |
schema/table/column |
MS_Description |
Employee identification number. Foreign key to Employee.BusinessEntityID. |
| Object |
HumanResources.EmployeePayHistory.RateChangeDate |
schema/table/column |
MS_Description |
Date the change in pay is effective |
| Object |
HumanResources.EmployeePayHistory.Rate |
schema/table/column |
MS_Description |
Salary hourly rate. |
| Object |
HumanResources.EmployeePayHistory.PayFrequency |
schema/table/column |
MS_Description |
1 = Salary received monthly, 2 = Salary received biweekly |
| Object |
HumanResources.EmployeePayHistory.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Sales.FK_SalesTerritoryHistory_SalesPerson_BusinessEntityID.FK_SalesTerritoryHistory_SalesPerson_BusinessEntityID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing SalesPerson.SalesPersonID. |
| Object |
Person.PK_PhoneNumberType_PhoneNumberTypeID.PK_PhoneNumberType_PhoneNumberTypeID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.CK_SalesOrderHeader_Freight.CK_SalesOrderHeader_Freight |
schema/table/check_constraint |
MS_Description |
Check constraint [Freight] >= (0.00) |
| Object |
HumanResources.DF_EmployeePayHistory_ModifiedDate.DF_EmployeePayHistory_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Sales.FK_SalesTerritoryHistory_SalesTerritory_TerritoryID.FK_SalesTerritoryHistory_SalesTerritory_TerritoryID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing SalesTerritory.TerritoryID. |
| Object |
Production.PK_Product_ProductID.PK_Product_ProductID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.SalesOrderHeaderSalesReason |
schema/table |
MS_Description |
Cross-reference table mapping sales orders to sales reason codes. |
| Object |
Sales.SalesOrderHeaderSalesReason.SalesOrderID |
schema/table/column |
MS_Description |
Primary key. Foreign key to SalesOrderHeader.SalesOrderID. |
| Object |
Sales.SalesOrderHeaderSalesReason.SalesReasonID |
schema/table/column |
MS_Description |
Primary key. Foreign key to SalesReason.SalesReasonID. |
| Object |
Sales.SalesOrderHeaderSalesReason.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
HumanResources.CK_EmployeePayHistory_PayFrequency.CK_EmployeePayHistory_PayFrequency |
schema/table/check_constraint |
MS_Description |
Check constraint [PayFrequency]=(3) OR [PayFrequency]=(2) OR [PayFrequency]=(1) |
| Object |
Sales.FK_ShoppingCartItem_Product_ProductID.FK_ShoppingCartItem_Product_ProductID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Product.ProductID. |
| Object |
Production.PK_ProductCategory_ProductCategoryID.PK_ProductCategory_ProductCategoryID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesOrderHeaderSalesReason_ModifiedDate.DF_SalesOrderHeaderSalesReason_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
HumanResources.CK_EmployeePayHistory_Rate.CK_EmployeePayHistory_Rate |
schema/table/check_constraint |
MS_Description |
Check constraint [Rate] >= (6.50) AND [Rate] <= (200.00) |
| Object |
Sales.FK_SpecialOfferProduct_Product_ProductID.FK_SpecialOfferProduct_Product_ProductID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Product.ProductID. |
| Object |
Production.PK_ProductCostHistory_ProductID_StartDate.PK_ProductCostHistory_ProductID_StartDate |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.SalesPerson |
schema/table |
MS_Description |
Sales representative current information. |
| Object |
Sales.SalesPerson.BusinessEntityID |
schema/table/column |
MS_Description |
Primary key for SalesPerson records. Foreign key to Employee.BusinessEntityID |
| Object |
Sales.SalesPerson.TerritoryID |
schema/table/column |
MS_Description |
Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID. |
| Object |
Sales.SalesPerson.SalesQuota |
schema/table/column |
MS_Description |
Projected yearly sales. |
| Object |
Sales.SalesPerson.Bonus |
schema/table/column |
MS_Description |
Bonus due if quota is met. |
| Object |
Sales.SalesPerson.CommissionPct |
schema/table/column |
MS_Description |
Commision percent received per sale. |
| Object |
Sales.SalesPerson.SalesYTD |
schema/table/column |
MS_Description |
Sales total year to date. |
| Object |
Sales.SalesPerson.SalesLastYear |
schema/table/column |
MS_Description |
Sales total of previous year. |
| Object |
Sales.SalesPerson.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Sales.SalesPerson.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.Illustration |
schema/table |
MS_Description |
Bicycle assembly diagrams. |
| Object |
Production.Illustration.IllustrationID |
schema/table/column |
MS_Description |
Primary key for Illustration records. |
| Object |
Production.Illustration.Diagram |
schema/table/column |
MS_Description |
Illustrations used in manufacturing instructions. Stored as XML. |
| Object |
Production.Illustration.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Sales.FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID.FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing SpecialOffer.SpecialOfferID. |
| Object |
Production.PK_ProductDescription_ProductDescriptionID.PK_ProductDescription_ProductDescriptionID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesPerson_Bonus.DF_SalesPerson_Bonus |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0.0 |
| Object |
Production.DF_Illustration_ModifiedDate.DF_Illustration_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Person.FK_StateProvince_CountryRegion_CountryRegionCode.FK_StateProvince_CountryRegion_CountryRegionCode |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing CountryRegion.CountryRegionCode. |
| Object |
Production.PK_ProductDocument_ProductID_DocumentNode.PK_ProductDocument_ProductID_DocumentNode |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesPerson_CommissionPct.DF_SalesPerson_CommissionPct |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0.0 |
| Object |
HumanResources.JobCandidate |
schema/table |
MS_Description |
Résumés submitted to Human Resources by job applicants. |
| Object |
HumanResources.JobCandidate.JobCandidateID |
schema/table/column |
MS_Description |
Primary key for JobCandidate records. |
| Object |
HumanResources.JobCandidate.BusinessEntityID |
schema/table/column |
MS_Description |
Employee identification number if applicant was hired. Foreign key to Employee.BusinessEntityID. |
| Object |
HumanResources.JobCandidate.Resume |
schema/table/column |
MS_Description |
Résumé in XML format. |
| Object |
HumanResources.JobCandidate.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Person.FK_StateProvince_SalesTerritory_TerritoryID.FK_StateProvince_SalesTerritory_TerritoryID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing SalesTerritory.TerritoryID. |
| Object |
Production.PK_ProductInventory_ProductID_LocationID.PK_ProductInventory_ProductID_LocationID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesPerson_SalesYTD.DF_SalesPerson_SalesYTD |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0.0 |
| Object |
HumanResources.DF_JobCandidate_ModifiedDate.DF_JobCandidate_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Sales.FK_Store_BusinessEntity_BusinessEntityID.FK_Store_BusinessEntity_BusinessEntityID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing BusinessEntity.BusinessEntityID |
| Object |
Production.PK_ProductListPriceHistory_ProductID_StartDate.PK_ProductListPriceHistory_ProductID_StartDate |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesPerson_SalesLastYear.DF_SalesPerson_SalesLastYear |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0.0 |
| Object |
Production.Location |
schema/table |
MS_Description |
Product inventory and manufacturing locations. |
| Object |
Production.Location.LocationID |
schema/table/column |
MS_Description |
Primary key for Location records. |
| Object |
Production.Location.Name |
schema/table/column |
MS_Description |
Location description. |
| Object |
Production.Location.CostRate |
schema/table/column |
MS_Description |
Standard hourly cost of the manufacturing location. |
| Object |
Production.Location.Availability |
schema/table/column |
MS_Description |
Work capacity (in hours) of the manufacturing location. |
| Object |
Production.Location.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Sales.FK_Store_SalesPerson_SalesPersonID.FK_Store_SalesPerson_SalesPersonID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing SalesPerson.SalesPersonID |
| Object |
Production.PK_ProductModel_ProductModelID.PK_ProductModel_ProductModelID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesPerson_rowguid.DF_SalesPerson_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
Production.DF_Location_CostRate.DF_Location_CostRate |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0.0 |
| Object |
Production.FK_TransactionHistory_Product_ProductID.FK_TransactionHistory_Product_ProductID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Product.ProductID. |
| Object |
Production.PK_ProductModelIllustration_ProductModelID_IllustrationID.PK_ProductModelIllustration_ProductModelID_IllustrationID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesPerson_ModifiedDate.DF_SalesPerson_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.DF_Location_Availability.DF_Location_Availability |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0.00 |
| Object |
Purchasing.FK_Vendor_BusinessEntity_BusinessEntityID.FK_Vendor_BusinessEntity_BusinessEntityID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing BusinessEntity.BusinessEntityID |
| Object |
Production.PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID.PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.CK_SalesPerson_SalesQuota.CK_SalesPerson_SalesQuota |
schema/table/check_constraint |
MS_Description |
Check constraint [SalesQuota] > (0.00) |
| Object |
Production.DF_Location_ModifiedDate.DF_Location_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.FK_WorkOrder_Product_ProductID.FK_WorkOrder_Product_ProductID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Product.ProductID. |
| Object |
Production.PK_ProductPhoto_ProductPhotoID.PK_ProductPhoto_ProductPhotoID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.CK_SalesPerson_Bonus.CK_SalesPerson_Bonus |
schema/table/check_constraint |
MS_Description |
Check constraint [Bonus] >= (0.00) |
| Object |
Production.CK_Location_CostRate.CK_Location_CostRate |
schema/table/check_constraint |
MS_Description |
Check constraint [CostRate] >= (0.00) |
| Object |
Production.FK_WorkOrder_ScrapReason_ScrapReasonID.FK_WorkOrder_ScrapReason_ScrapReasonID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing ScrapReason.ScrapReasonID. |
| Object |
Production.PK_ProductProductPhoto_ProductID_ProductPhotoID.PK_ProductProductPhoto_ProductID_ProductPhotoID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.CK_SalesPerson_CommissionPct.CK_SalesPerson_CommissionPct |
schema/table/check_constraint |
MS_Description |
Check constraint [CommissionPct] >= (0.00) |
| Object |
Production.CK_Location_Availability.CK_Location_Availability |
schema/table/check_constraint |
MS_Description |
Check constraint [Availability] >= (0.00) |
| Object |
Production.FK_WorkOrderRouting_Location_LocationID.FK_WorkOrderRouting_Location_LocationID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Location.LocationID. |
| Object |
Production.PK_ProductReview_ProductReviewID.PK_ProductReview_ProductReviewID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.CK_SalesPerson_SalesYTD.CK_SalesPerson_SalesYTD |
schema/table/check_constraint |
MS_Description |
Check constraint [SalesYTD] >= (0.00) |
| Object |
Person.Password |
schema/table |
MS_Description |
One way hashed authentication information |
| Object |
Person.Password.PasswordHash |
schema/table/column |
MS_Description |
Password for the e-mail account. |
| Object |
Person.Password.PasswordSalt |
schema/table/column |
MS_Description |
Random value concatenated with the password string before the password is hashed. |
| Object |
Person.Password.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Person.Password.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.FK_WorkOrderRouting_WorkOrder_WorkOrderID.FK_WorkOrderRouting_WorkOrder_WorkOrderID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing WorkOrder.WorkOrderID. |
| Object |
Production.PK_ProductSubcategory_ProductSubcategoryID.PK_ProductSubcategory_ProductSubcategoryID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.CK_SalesPerson_SalesLastYear.CK_SalesPerson_SalesLastYear |
schema/table/check_constraint |
MS_Description |
Check constraint [SalesLastYear] >= (0.00) |
| Object |
Person.DF_Password_rowguid.DF_Password_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
HumanResources.dEmployee.dEmployee |
schema/table/sql_trigger |
MS_Description |
INSTEAD OF DELETE trigger which keeps Employees from being deleted. |
| Object |
Purchasing.PK_ProductVendor_ProductID_BusinessEntityID.PK_ProductVendor_ProductID_BusinessEntityID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.SalesPersonQuotaHistory |
schema/table |
MS_Description |
Sales performance tracking. |
| Object |
Sales.SalesPersonQuotaHistory.BusinessEntityID |
schema/table/column |
MS_Description |
Sales person identification number. Foreign key to SalesPerson.BusinessEntityID. |
| Object |
Sales.SalesPersonQuotaHistory.QuotaDate |
schema/table/column |
MS_Description |
Sales quota date. |
| Object |
Sales.SalesPersonQuotaHistory.SalesQuota |
schema/table/column |
MS_Description |
Sales quota amount. |
| Object |
Sales.SalesPersonQuotaHistory.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Sales.SalesPersonQuotaHistory.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Person.DF_Password_ModifiedDate.DF_Password_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Person.iuPerson.iuPerson |
schema/table/sql_trigger |
MS_Description |
AFTER INSERT, UPDATE trigger inserting Individual only if the Customer does not exist in the Store table and setting the ModifiedDate column in the Person table to the current date. |
| Object |
Purchasing.PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID.PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesPersonQuotaHistory_rowguid.DF_SalesPersonQuotaHistory_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
Person.Person |
schema/table |
MS_Description |
Human beings involved with AdventureWorks: employees, customer contacts, and vendor contacts. |
| Object |
Person.Person.BusinessEntityID |
schema/table/column |
MS_Description |
Primary key for Person records. |
| Object |
Person.Person.PersonType |
schema/table/column |
MS_Description |
Primary type of person: SC = Store Contact, IN = Individual (retail) customer, SP = Sales person, EM = Employee (non-sales), VC = Vendor contact, GC = General contact |
| Object |
Person.Person.NameStyle |
schema/table/column |
MS_Description |
0 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (last name, first name) order. |
| Object |
Person.Person.Title |
schema/table/column |
MS_Description |
A courtesy title. For example, Mr. or Ms. |
| Object |
Person.Person.FirstName |
schema/table/column |
MS_Description |
First name of the person. |
| Object |
Person.Person.MiddleName |
schema/table/column |
MS_Description |
Middle name or middle initial of the person. |
| Object |
Person.Person.LastName |
schema/table/column |
MS_Description |
Last name of the person. |
| Object |
Person.Person.Suffix |
schema/table/column |
MS_Description |
Surname suffix. For example, Sr. or Jr. |
| Object |
Person.Person.EmailPromotion |
schema/table/column |
MS_Description |
0 = Contact does not wish to receive e-mail promotions, 1 = Contact does wish to receive e-mail promotions from AdventureWorks, 2 = Contact does wish to receive e-mail promotions from AdventureWorks and selected partners. |
| Object |
Person.Person.AdditionalContactInfo |
schema/table/column |
MS_Description |
Additional contact information about the person stored in xml format. |
| Object |
Person.Person.Demographics |
schema/table/column |
MS_Description |
Personal information such as hobbies, and income collected from online shoppers. Used for sales analysis. |
| Object |
Person.Person.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Person.Person.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Purchasing.iPurchaseOrderDetail.iPurchaseOrderDetail |
schema/table/sql_trigger |
MS_Description |
AFTER INSERT trigger that inserts a row in the TransactionHistory table and updates the PurchaseOrderHeader.SubTotal column. |
| Object |
Purchasing.PK_PurchaseOrderHeader_PurchaseOrderID.PK_PurchaseOrderHeader_PurchaseOrderID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesPersonQuotaHistory_ModifiedDate.DF_SalesPersonQuotaHistory_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Person.DF_Person_NameStyle.DF_Person_NameStyle |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0 |
| Object |
Purchasing.uPurchaseOrderDetail.uPurchaseOrderDetail |
schema/table/sql_trigger |
MS_Description |
AFTER UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in PurchaseOrderDetail and updates the PurchaseOrderHeader.SubTotal column. |
| Object |
Sales.PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID.PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.CK_SalesPersonQuotaHistory_SalesQuota.CK_SalesPersonQuotaHistory_SalesQuota |
schema/table/check_constraint |
MS_Description |
Check constraint [SalesQuota] > (0.00) |
| Object |
Person.DF_Person_EmailPromotion.DF_Person_EmailPromotion |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0 |
| Object |
Purchasing.uPurchaseOrderHeader.uPurchaseOrderHeader |
schema/table/sql_trigger |
MS_Description |
AFTER UPDATE trigger that updates the RevisionNumber and ModifiedDate columns in the PurchaseOrderHeader table. |
| Object |
Sales.PK_SalesOrderHeader_SalesOrderID.PK_SalesOrderHeader_SalesOrderID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.SalesReason |
schema/table |
MS_Description |
Lookup table of customer purchase reasons. |
| Object |
Sales.SalesReason.SalesReasonID |
schema/table/column |
MS_Description |
Primary key for SalesReason records. |
| Object |
Sales.SalesReason.Name |
schema/table/column |
MS_Description |
Sales reason description. |
| Object |
Sales.SalesReason.ReasonType |
schema/table/column |
MS_Description |
Category the sales reason belongs to. |
| Object |
Sales.SalesReason.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Person.DF_Person_rowguid.DF_Person_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
Sales.iduSalesOrderDetail.iduSalesOrderDetail |
schema/table/sql_trigger |
MS_Description |
AFTER INSERT, DELETE, UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in SalesOrderDetail and updates the SalesOrderHeader.SubTotal column. |
| Object |
Sales.PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID.PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesReason_ModifiedDate.DF_SalesReason_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Person.DF_Person_ModifiedDate.DF_Person_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Sales.uSalesOrderHeader.uSalesOrderHeader |
schema/table/sql_trigger |
MS_Description |
AFTER UPDATE trigger that updates the RevisionNumber and ModifiedDate columns in the SalesOrderHeader table.Updates the SalesYTD column in the SalesPerson and SalesTerritory tables. |
| Object |
Sales.PK_SalesPerson_BusinessEntityID.PK_SalesPerson_BusinessEntityID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.SalesTaxRate |
schema/table |
MS_Description |
Tax rate lookup table. |
| Object |
Sales.SalesTaxRate.SalesTaxRateID |
schema/table/column |
MS_Description |
Primary key for SalesTaxRate records. |
| Object |
Sales.SalesTaxRate.StateProvinceID |
schema/table/column |
MS_Description |
State, province, or country/region the sales tax applies to. |
| Object |
Sales.SalesTaxRate.TaxType |
schema/table/column |
MS_Description |
1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions. |
| Object |
Sales.SalesTaxRate.TaxRate |
schema/table/column |
MS_Description |
Tax rate amount. |
| Object |
Sales.SalesTaxRate.Name |
schema/table/column |
MS_Description |
Tax rate description. |
| Object |
Sales.SalesTaxRate.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Sales.SalesTaxRate.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Person.CK_Person_EmailPromotion.CK_Person_EmailPromotion |
schema/table/check_constraint |
MS_Description |
Check constraint [EmailPromotion] >= (0) AND [EmailPromotion] <= (2) |
| Object |
Purchasing.dVendor.dVendor |
schema/table/sql_trigger |
MS_Description |
INSTEAD OF DELETE trigger which keeps Vendors from being deleted. |
| Object |
Sales.PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate.PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesTaxRate_TaxRate.DF_SalesTaxRate_TaxRate |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0.0 |
| Object |
Person.CK_Person_PersonType.CK_Person_PersonType |
schema/table/check_constraint |
MS_Description |
Check constraint [PersonType] is one of SC, VC, IN, EM or SP. |
| Object |
Production.iWorkOrder.iWorkOrder |
schema/table/sql_trigger |
MS_Description |
AFTER INSERT trigger that inserts a row in the TransactionHistory table. |
| Object |
Sales.PK_SalesReason_SalesReasonID.PK_SalesReason_SalesReasonID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesTaxRate_rowguid.DF_SalesTaxRate_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
Sales.PersonCreditCard |
schema/table |
MS_Description |
Cross-reference table mapping people to their credit card information in the CreditCard table. |
| Object |
Sales.PersonCreditCard.BusinessEntityID |
schema/table/column |
MS_Description |
Business entity identification number. Foreign key to Person.BusinessEntityID. |
| Object |
Sales.PersonCreditCard.CreditCardID |
schema/table/column |
MS_Description |
Credit card identification number. Foreign key to CreditCard.CreditCardID. |
| Object |
Sales.PersonCreditCard.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.uWorkOrder.uWorkOrder |
schema/table/sql_trigger |
MS_Description |
AFTER UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in the WorkOrder table. |
| Object |
Sales.PK_SalesTaxRate_SalesTaxRateID.PK_SalesTaxRate_SalesTaxRateID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesTaxRate_ModifiedDate.DF_SalesTaxRate_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Sales.DF_PersonCreditCard_ModifiedDate.DF_PersonCreditCard_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Interface |
Person.vAdditionalContactInfo |
schema/view |
MS_Description |
Displays the contact name and content from each element in the xml column AdditionalContactInfo for that person. |
| Object |
Sales.PK_SalesTerritory_TerritoryID.PK_SalesTerritory_TerritoryID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.CK_SalesTaxRate_TaxType.CK_SalesTaxRate_TaxType |
schema/table/check_constraint |
MS_Description |
Check constraint [TaxType] BETWEEN (1) AND (3) |
| Object |
Person.PersonPhone |
schema/table |
MS_Description |
Telephone number and type of a person. |
| Object |
Person.PersonPhone.BusinessEntityID |
schema/table/column |
MS_Description |
Business entity identification number. Foreign key to Person.BusinessEntityID. |
| Object |
Person.PersonPhone.PhoneNumber |
schema/table/column |
MS_Description |
Telephone number identification number. |
| Object |
Person.PersonPhone.PhoneNumberTypeID |
schema/table/column |
MS_Description |
Kind of phone number. Foreign key to PhoneNumberType.PhoneNumberTypeID. |
| Object |
Person.PersonPhone.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Interface |
HumanResources.vEmployee |
schema/view |
MS_Description |
Employee names and addresses. |
| Object |
Sales.PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID.PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.SalesTerritory |
schema/table |
MS_Description |
Sales territory lookup table. |
| Object |
Sales.SalesTerritory.TerritoryID |
schema/table/column |
MS_Description |
Primary key for SalesTerritory records. |
| Object |
Sales.SalesTerritory.Name |
schema/table/column |
MS_Description |
Sales territory description |
| Object |
Sales.SalesTerritory.CountryRegionCode |
schema/table/column |
MS_Description |
ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode. |
| Object |
Sales.SalesTerritory.Group |
schema/table/column |
MS_Description |
Geographic area to which the sales territory belong. |
| Object |
Sales.SalesTerritory.SalesYTD |
schema/table/column |
MS_Description |
Sales in the territory year to date. |
| Object |
Sales.SalesTerritory.SalesLastYear |
schema/table/column |
MS_Description |
Sales in the territory the previous year. |
| Object |
Sales.SalesTerritory.CostYTD |
schema/table/column |
MS_Description |
Business costs in the territory year to date. |
| Object |
Sales.SalesTerritory.CostLastYear |
schema/table/column |
MS_Description |
Business costs in the territory the previous year. |
| Object |
Sales.SalesTerritory.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Sales.SalesTerritory.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Person.DF_PersonPhone_ModifiedDate.DF_PersonPhone_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Interface |
HumanResources.vEmployeeDepartment |
schema/view |
MS_Description |
Returns employee name, title, and current department. |
| Object |
Production.PK_ScrapReason_ScrapReasonID.PK_ScrapReason_ScrapReasonID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesTerritory_SalesYTD.DF_SalesTerritory_SalesYTD |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0.0 |
| Object |
Person.PhoneNumberType |
schema/table |
MS_Description |
Type of phone number of a person. |
| Object |
Person.PhoneNumberType.PhoneNumberTypeID |
schema/table/column |
MS_Description |
Primary key for telephone number type records. |
| Object |
Person.PhoneNumberType.Name |
schema/table/column |
MS_Description |
Name of the telephone number type |
| Object |
Person.PhoneNumberType.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Interface |
HumanResources.vEmployeeDepartmentHistory |
schema/view |
MS_Description |
Returns employee name and current and previous departments. |
| Object |
HumanResources.PK_Shift_ShiftID.PK_Shift_ShiftID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesTerritory_SalesLastYear.DF_SalesTerritory_SalesLastYear |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0.0 |
| Object |
Person.DF_PhoneNumberType_ModifiedDate.DF_PhoneNumberType_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Interface |
Sales.vIndividualCustomer |
schema/view |
MS_Description |
Individual customers (names and addresses) that purchase Adventure Works Cycles products online. |
| Object |
Purchasing.PK_ShipMethod_ShipMethodID.PK_ShipMethod_ShipMethodID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesTerritory_CostYTD.DF_SalesTerritory_CostYTD |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0.0 |
| Object |
Production.Product |
schema/table |
MS_Description |
Products sold or used in the manfacturing of sold products. |
| Object |
Production.Product.ProductID |
schema/table/column |
MS_Description |
Primary key for Product records. |
| Object |
Production.Product.Name |
schema/table/column |
MS_Description |
Name of the product. |
| Object |
Production.Product.ProductNumber |
schema/table/column |
MS_Description |
Unique product identification number. |
| Object |
Production.Product.MakeFlag |
schema/table/column |
MS_Description |
0 = Product is purchased, 1 = Product is manufactured in-house. |
| Object |
Production.Product.FinishedGoodsFlag |
schema/table/column |
MS_Description |
0 = Product is not a salable item. 1 = Product is salable. |
| Object |
Production.Product.Color |
schema/table/column |
MS_Description |
Product color. |
| Object |
Production.Product.SafetyStockLevel |
schema/table/column |
MS_Description |
Minimum inventory quantity. |
| Object |
Production.Product.ReorderPoint |
schema/table/column |
MS_Description |
Inventory level that triggers a purchase order or work order. |
| Object |
Production.Product.StandardCost |
schema/table/column |
MS_Description |
Standard cost of the product. |
| Object |
Production.Product.ListPrice |
schema/table/column |
MS_Description |
Selling price. |
| Object |
Production.Product.Size |
schema/table/column |
MS_Description |
Product size. |
| Object |
Production.Product.SizeUnitMeasureCode |
schema/table/column |
MS_Description |
Unit of measure for Size column. |
| Object |
Production.Product.WeightUnitMeasureCode |
schema/table/column |
MS_Description |
Unit of measure for Weight column. |
| Object |
Production.Product.Weight |
schema/table/column |
MS_Description |
Product weight. |
| Object |
Production.Product.DaysToManufacture |
schema/table/column |
MS_Description |
Number of days required to manufacture the product. |
| Object |
Production.Product.ProductLine |
schema/table/column |
MS_Description |
R = Road, M = Mountain, T = Touring, S = Standard |
| Object |
Production.Product.Class |
schema/table/column |
MS_Description |
H = High, M = Medium, L = Low |
| Object |
Production.Product.Style |
schema/table/column |
MS_Description |
W = Womens, M = Mens, U = Universal |
| Object |
Production.Product.ProductSubcategoryID |
schema/table/column |
MS_Description |
Product is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID. |
| Object |
Production.Product.ProductModelID |
schema/table/column |
MS_Description |
Product is a member of this product model. Foreign key to ProductModel.ProductModelID. |
| Object |
Production.Product.SellStartDate |
schema/table/column |
MS_Description |
Date the product was available for sale. |
| Object |
Production.Product.SellEndDate |
schema/table/column |
MS_Description |
Date the product was no longer available for sale. |
| Object |
Production.Product.DiscontinuedDate |
schema/table/column |
MS_Description |
Date the product was discontinued. |
| Object |
Production.Product.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Production.Product.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Interface |
Sales.vPersonDemographics |
schema/view |
MS_Description |
Displays the content from each element in the xml column Demographics for each customer in the Person.Person table. |
| Object |
Sales.PK_ShoppingCartItem_ShoppingCartItemID.PK_ShoppingCartItem_ShoppingCartItemID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesTerritory_CostLastYear.DF_SalesTerritory_CostLastYear |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0.0 |
| Object |
Production.DF_Product_MakeFlag.DF_Product_MakeFlag |
schema/table/default_constraint |
MS_Description |
Default constraint value of 1 |
| Interface |
HumanResources.vJobCandidate |
schema/view |
MS_Description |
Job candidate names and resumes. |
| Object |
Sales.PK_SpecialOffer_SpecialOfferID.PK_SpecialOffer_SpecialOfferID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesTerritory_rowguid.DF_SalesTerritory_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
Production.DF_Product_FinishedGoodsFlag.DF_Product_FinishedGoodsFlag |
schema/table/default_constraint |
MS_Description |
Default constraint value of 1 |
| Interface |
HumanResources.vJobCandidateEmployment |
schema/view |
MS_Description |
Displays the content from each employement history related element in the xml column Resume in the HumanResources.JobCandidate table. The content has been localized into French, Simplified Chinese and Thai. Some data may not display correctly unless supplemental language support is installed. |
| Object |
Sales.PK_SpecialOfferProduct_SpecialOfferID_ProductID.PK_SpecialOfferProduct_SpecialOfferID_ProductID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesTerritory_ModifiedDate.DF_SalesTerritory_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.DF_Product_rowguid.DF_Product_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Interface |
HumanResources.vJobCandidateEducation |
schema/view |
MS_Description |
Displays the content from each education related element in the xml column Resume in the HumanResources.JobCandidate table. The content has been localized into French, Simplified Chinese and Thai. Some data may not display correctly unless supplemental language support is installed. |
| Object |
Person.PK_StateProvince_StateProvinceID.PK_StateProvince_StateProvinceID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.CK_SalesTerritory_SalesYTD.CK_SalesTerritory_SalesYTD |
schema/table/check_constraint |
MS_Description |
Check constraint [SalesYTD] >= (0.00) |
| Object |
Production.DF_Product_ModifiedDate.DF_Product_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Interface |
Production.vProductAndDescription |
schema/view |
MS_Description |
Product names and descriptions. Product descriptions are provided in multiple languages. |
| Object |
Sales.PK_Store_BusinessEntityID.PK_Store_BusinessEntityID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.CK_SalesTerritory_SalesLastYear.CK_SalesTerritory_SalesLastYear |
schema/table/check_constraint |
MS_Description |
Check constraint [SalesLastYear] >= (0.00) |
| Object |
Production.CK_Product_SafetyStockLevel.CK_Product_SafetyStockLevel |
schema/table/check_constraint |
MS_Description |
Check constraint [SafetyStockLevel] > (0) |
| Interface |
Production.vProductModelCatalogDescription |
schema/view |
MS_Description |
Displays the content from each element in the xml column CatalogDescription for each product in the Production.ProductModel table that has catalog data. |
| Object |
Production.PK_TransactionHistory_TransactionID.PK_TransactionHistory_TransactionID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.CK_SalesTerritory_CostYTD.CK_SalesTerritory_CostYTD |
schema/table/check_constraint |
MS_Description |
Check constraint [CostYTD] >= (0.00) |
| Object |
Production.CK_Product_ReorderPoint.CK_Product_ReorderPoint |
schema/table/check_constraint |
MS_Description |
Check constraint [ReorderPoint] > (0) |
| Interface |
Production.vProductModelInstructions |
schema/view |
MS_Description |
Displays the content from each element in the xml column Instructions for each product in the Production.ProductModel table that has manufacturing instructions. |
| Object |
Production.PK_TransactionHistoryArchive_TransactionID.PK_TransactionHistoryArchive_TransactionID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.CK_SalesTerritory_CostLastYear.CK_SalesTerritory_CostLastYear |
schema/table/check_constraint |
MS_Description |
Check constraint [CostLastYear] >= (0.00) |
| Object |
Production.CK_Product_StandardCost.CK_Product_StandardCost |
schema/table/check_constraint |
MS_Description |
Check constraint [SafetyStockLevel] > (0) |
| Interface |
Sales.vSalesPerson |
schema/view |
MS_Description |
Sales representiatives (names and addresses) and their sales-related information. |
| Object |
Production.PK_UnitMeasure_UnitMeasureCode.PK_UnitMeasure_UnitMeasureCode |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.SalesTerritoryHistory |
schema/table |
MS_Description |
Sales representative transfers to other sales territories. |
| Object |
Sales.SalesTerritoryHistory.BusinessEntityID |
schema/table/column |
MS_Description |
Primary key. The sales rep. Foreign key to SalesPerson.BusinessEntityID. |
| Object |
Sales.SalesTerritoryHistory.TerritoryID |
schema/table/column |
MS_Description |
Primary key. Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID. |
| Object |
Sales.SalesTerritoryHistory.StartDate |
schema/table/column |
MS_Description |
Primary key. Date the sales representive started work in the territory. |
| Object |
Sales.SalesTerritoryHistory.EndDate |
schema/table/column |
MS_Description |
Date the sales representative left work in the territory. |
| Object |
Sales.SalesTerritoryHistory.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Sales.SalesTerritoryHistory.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.CK_Product_ListPrice.CK_Product_ListPrice |
schema/table/check_constraint |
MS_Description |
Check constraint [ListPrice] >= (0.00) |
| Interface |
Sales.vSalesPersonSalesByFiscalYears |
schema/view |
MS_Description |
Uses PIVOT to return aggregated sales information for each sales representative. |
| Object |
Purchasing.PK_Vendor_BusinessEntityID.PK_Vendor_BusinessEntityID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesTerritoryHistory_rowguid.DF_SalesTerritoryHistory_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
Production.CK_Product_Weight.CK_Product_Weight |
schema/table/check_constraint |
MS_Description |
Check constraint [Weight] > (0.00) |
| Interface |
Person.vStateProvinceCountryRegion |
schema/view |
MS_Description |
Joins StateProvince table with CountryRegion table. |
| Object |
Production.PK_WorkOrder_WorkOrderID.PK_WorkOrder_WorkOrderID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesTerritoryHistory_ModifiedDate.DF_SalesTerritoryHistory_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.CK_Product_DaysToManufacture.CK_Product_DaysToManufacture |
schema/table/check_constraint |
MS_Description |
Check constraint [DaysToManufacture] >= (0) |
| Interface |
Sales.vStoreWithDemographics |
schema/view |
MS_Description |
Stores (including demographics) that sell Adventure Works Cycles products to consumers. |
| Object |
Production.PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence.PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.CK_SalesTerritoryHistory_EndDate.CK_SalesTerritoryHistory_EndDate |
schema/table/check_constraint |
MS_Description |
Check constraint [EndDate] >= [StartDate] OR [EndDate] IS NULL |
| Object |
Production.CK_Product_ProductLine.CK_Product_ProductLine |
schema/table/check_constraint |
MS_Description |
Check constraint [ProductLine]='r' OR [ProductLine]='m' OR [ProductLine]='t' OR [ProductLine]='s' OR [ProductLine]='R' OR [ProductLine]='M' OR [ProductLine]='T' OR [ProductLine]='S' OR [ProductLine] IS NULL |
| Interface |
Sales.vStoreWithContacts |
schema/view |
MS_Description |
Stores (including store contacts) that sell Adventure Works Cycles products to consumers. |
| Object |
Production.ScrapReason |
schema/table |
MS_Description |
Manufacturing failure reasons lookup table. |
| Object |
Production.ScrapReason.ScrapReasonID |
schema/table/column |
MS_Description |
Primary key for ScrapReason records. |
| Object |
Production.ScrapReason.Name |
schema/table/column |
MS_Description |
Failure description. |
| Object |
Production.ScrapReason.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.CK_Product_Class.CK_Product_Class |
schema/table/check_constraint |
MS_Description |
Check constraint [Class]='h' OR [Class]='m' OR [Class]='l' OR [Class]='H' OR [Class]='M' OR [Class]='L' OR [Class] IS NULL |
| Interface |
Sales.vStoreWithAddresses |
schema/view |
MS_Description |
Stores (including store addresses) that sell Adventure Works Cycles products to consumers. |
| Object |
Production.DF_ScrapReason_ModifiedDate.DF_ScrapReason_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.CK_Product_Style.CK_Product_Style |
schema/table/check_constraint |
MS_Description |
Check constraint [Style]='u' OR [Style]='m' OR [Style]='w' OR [Style]='U' OR [Style]='M' OR [Style]='W' OR [Style] IS NULL |
| Interface |
Purchasing.vVendorWithContacts |
schema/view |
MS_Description |
Vendor (company) names and the names of vendor employees to contact. |
| Object |
HumanResources.Shift |
schema/table |
MS_Description |
Work shift lookup table. |
| Object |
HumanResources.Shift.ShiftID |
schema/table/column |
MS_Description |
Primary key for Shift records. |
| Object |
HumanResources.Shift.Name |
schema/table/column |
MS_Description |
Shift description. |
| Object |
HumanResources.Shift.StartTime |
schema/table/column |
MS_Description |
Shift start time. |
| Object |
HumanResources.Shift.EndTime |
schema/table/column |
MS_Description |
Shift end time. |
| Object |
HumanResources.Shift.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.CK_Product_SellEndDate.CK_Product_SellEndDate |
schema/table/check_constraint |
MS_Description |
Check constraint [SellEndDate] >= [SellStartDate] OR [SellEndDate] IS NULL |
| Interface |
Purchasing.vVendorWithAddresses |
schema/view |
MS_Description |
Vendor (company) names and addresses . |
| Object |
HumanResources.DF_Shift_ModifiedDate.DF_Shift_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.ProductCategory |
schema/table |
MS_Description |
High-level product categorization. |
| Object |
Production.ProductCategory.ProductCategoryID |
schema/table/column |
MS_Description |
Primary key for ProductCategory records. |
| Object |
Production.ProductCategory.Name |
schema/table/column |
MS_Description |
Category description. |
| Object |
Production.ProductCategory.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Production.ProductCategory.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Interface |
dbo.ufnGetAccountingStartDate |
schema/function |
MS_Description |
Scalar function used in the uSalesOrderHeader trigger to set the ending account date. |
| Object |
Purchasing.ShipMethod |
schema/table |
MS_Description |
Shipping company lookup table. |
| Object |
Purchasing.ShipMethod.ShipMethodID |
schema/table/column |
MS_Description |
Primary key for ShipMethod records. |
| Object |
Purchasing.ShipMethod.Name |
schema/table/column |
MS_Description |
Shipping company name. |
| Object |
Purchasing.ShipMethod.ShipBase |
schema/table/column |
MS_Description |
Minimum shipping charge. |
| Object |
Purchasing.ShipMethod.ShipRate |
schema/table/column |
MS_Description |
Shipping charge per pound. |
| Object |
Purchasing.ShipMethod.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Purchasing.ShipMethod.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.DF_ProductCategory_rowguid.DF_ProductCategory_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID()() |
| Interface |
dbo.ufnGetAccountingEndDate |
schema/function |
MS_Description |
Scalar function used in the uSalesOrderHeader trigger to set the starting account date. |
| Object |
Purchasing.DF_ShipMethod_ShipBase.DF_ShipMethod_ShipBase |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0.0 |
| Object |
Production.DF_ProductCategory_ModifiedDate.DF_ProductCategory_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Interface |
dbo.ufnGetContactInformation |
schema/function |
MS_Description |
Table value function returning the first name, last name, job title and contact type for a given contact. |
| Object |
Purchasing.DF_ShipMethod_ShipRate.DF_ShipMethod_ShipRate |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0.0 |
| Object |
Production.ProductCostHistory |
schema/table |
MS_Description |
Changes in the cost of a product over time. |
| Object |
Production.ProductCostHistory.ProductID |
schema/table/column |
MS_Description |
Product identification number. Foreign key to Product.ProductID |
| Object |
Production.ProductCostHistory.StartDate |
schema/table/column |
MS_Description |
Product cost start date. |
| Object |
Production.ProductCostHistory.EndDate |
schema/table/column |
MS_Description |
Product cost end date. |
| Object |
Production.ProductCostHistory.StandardCost |
schema/table/column |
MS_Description |
Standard cost of the product. |
| Object |
Production.ProductCostHistory.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Interface |
dbo.ufnGetProductDealerPrice |
schema/function |
MS_Description |
Scalar function returning the dealer price for a given product on a particular order date. |
| Object |
Purchasing.DF_ShipMethod_rowguid.DF_ShipMethod_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
Production.DF_ProductCostHistory_ModifiedDate.DF_ProductCostHistory_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Interface |
dbo.ufnGetProductListPrice |
schema/function |
MS_Description |
Scalar function returning the list price for a given product on a particular order date. |
| Object |
Purchasing.DF_ShipMethod_ModifiedDate.DF_ShipMethod_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.CK_ProductCostHistory_EndDate.CK_ProductCostHistory_EndDate |
schema/table/check_constraint |
MS_Description |
Check constraint [EndDate] >= [StartDate] OR [EndDate] IS NULL |
| Interface |
dbo.ufnGetProductStandardCost |
schema/function |
MS_Description |
Scalar function returning the standard cost for a given product on a particular order date. |
| Object |
Purchasing.CK_ShipMethod_ShipBase.CK_ShipMethod_ShipBase |
schema/table/check_constraint |
MS_Description |
Check constraint [ShipBase] > (0.00) |
| Object |
Production.CK_ProductCostHistory_StandardCost.CK_ProductCostHistory_StandardCost |
schema/table/check_constraint |
MS_Description |
Check constraint [StandardCost] >= (0.00) |
| Interface |
dbo.ufnGetStock |
schema/function |
MS_Description |
Scalar function returning the quantity of inventory in LocationID 6 (Miscellaneous Storage)for a specified ProductID. |
| Object |
Purchasing.CK_ShipMethod_ShipRate.CK_ShipMethod_ShipRate |
schema/table/check_constraint |
MS_Description |
Check constraint [ShipRate] > (0.00) |
| Object |
Production.ProductDescription |
schema/table |
MS_Description |
Product descriptions in several languages. |
| Object |
Production.ProductDescription.ProductDescriptionID |
schema/table/column |
MS_Description |
Primary key for ProductDescription records. |
| Object |
Production.ProductDescription.Description |
schema/table/column |
MS_Description |
Description of the product. |
| Object |
Production.ProductDescription.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Production.ProductDescription.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Interface |
dbo.ufnGetDocumentStatusText |
schema/function |
MS_Description |
Scalar function returning the text representation of the Status column in the Document table. |
| Object |
Sales.ShoppingCartItem |
schema/table |
MS_Description |
Contains online customer orders until the order is submitted or cancelled. |
| Object |
Sales.ShoppingCartItem.ShoppingCartItemID |
schema/table/column |
MS_Description |
Primary key for ShoppingCartItem records. |
| Object |
Sales.ShoppingCartItem.ShoppingCartID |
schema/table/column |
MS_Description |
Shopping cart identification number. |
| Object |
Sales.ShoppingCartItem.Quantity |
schema/table/column |
MS_Description |
Product quantity ordered. |
| Object |
Sales.ShoppingCartItem.ProductID |
schema/table/column |
MS_Description |
Product ordered. Foreign key to Product.ProductID. |
| Object |
Sales.ShoppingCartItem.DateCreated |
schema/table/column |
MS_Description |
Date the time the record was created. |
| Object |
Sales.ShoppingCartItem.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.DF_ProductDescription_rowguid.DF_ProductDescription_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Interface |
dbo.ufnGetPurchaseOrderStatusText |
schema/function |
MS_Description |
Scalar function returning the text representation of the Status column in the PurchaseOrderHeader table. |
| Object |
Sales.DF_ShoppingCartItem_Quantity.DF_ShoppingCartItem_Quantity |
schema/table/default_constraint |
MS_Description |
Default constraint value of 1 |
| Object |
Production.DF_ProductDescription_ModifiedDate.DF_ProductDescription_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Interface |
dbo.ufnGetSalesOrderStatusText |
schema/function |
MS_Description |
Scalar function returning the text representation of the Status column in the SalesOrderHeader table. |
| Object |
Sales.DF_ShoppingCartItem_DateCreated.DF_ShoppingCartItem_DateCreated |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.ProductDocument |
schema/table |
MS_Description |
Cross-reference table mapping products to related product documents. |
| Object |
Production.ProductDocument.ProductID |
schema/table/column |
MS_Description |
Product identification number. Foreign key to Product.ProductID. |
| Object |
Production.ProductDocument.DocumentNode |
schema/table/column |
MS_Description |
Document identification number. Foreign key to Document.DocumentNode. |
| Object |
Production.ProductDocument.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Interface |
dbo.uspGetBillOfMaterials |
schema/procedure |
MS_Description |
Stored procedure using a recursive query to return a multi-level bill of material for the specified ProductID. |
| Interface |
dbo.uspGetBillOfMaterials |
schema/procedure |
Purpose |
SamplePurpose |
| Object |
Sales.DF_ShoppingCartItem_ModifiedDate.DF_ShoppingCartItem_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.DF_ProductDocument_ModifiedDate.DF_ProductDocument_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
dbo.DatabaseLog |
schema/table |
MS_Description |
Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog. |
| Object |
dbo.DatabaseLog.DatabaseLogID |
schema/table/column |
MS_Description |
Primary key for DatabaseLog records. |
| Object |
dbo.DatabaseLog.PostTime |
schema/table/column |
MS_Description |
The date and time the DDL change occurred. |
| Object |
dbo.DatabaseLog.DatabaseUser |
schema/table/column |
MS_Description |
The user who implemented the DDL change. |
| Object |
dbo.DatabaseLog.Event |
schema/table/column |
MS_Description |
The type of DDL statement that was executed. |
| Object |
dbo.DatabaseLog.Schema |
schema/table/column |
MS_Description |
The schema to which the changed object belongs. |
| Object |
dbo.DatabaseLog.Object |
schema/table/column |
MS_Description |
The object that was changed by the DDL statment. |
| Object |
dbo.DatabaseLog.TSQL |
schema/table/column |
MS_Description |
The exact Transact-SQL statement that was executed. |
| Object |
dbo.DatabaseLog.XmlEvent |
schema/table/column |
MS_Description |
The raw XML data generated by database trigger. |
| Interface |
dbo.uspGetEmployeeManagers |
schema/procedure |
MS_Description |
Stored procedure using a recursive query to return the direct and indirect managers of the specified employee. |
| Object |
Sales.CK_ShoppingCartItem_Quantity.CK_ShoppingCartItem_Quantity |
schema/table/check_constraint |
MS_Description |
Check constraint [Quantity] >= (1) |
| Object |
Production.ProductInventory |
schema/table |
MS_Description |
Product inventory information. |
| Object |
Production.ProductInventory.ProductID |
schema/table/column |
MS_Description |
Product identification number. Foreign key to Product.ProductID. |
| Object |
Production.ProductInventory.LocationID |
schema/table/column |
MS_Description |
Inventory location identification number. Foreign key to Location.LocationID. |
| Object |
Production.ProductInventory.Shelf |
schema/table/column |
MS_Description |
Storage compartment within an inventory location. |
| Object |
Production.ProductInventory.Bin |
schema/table/column |
MS_Description |
Storage container on a shelf in an inventory location. |
| Object |
Production.ProductInventory.Quantity |
schema/table/column |
MS_Description |
Quantity of products in the inventory location. |
| Object |
Production.ProductInventory.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Production.ProductInventory.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Interface |
dbo.uspGetManagerEmployees |
schema/procedure |
MS_Description |
Stored procedure using a recursive query to return the direct and indirect employees of the specified manager. |
| Object |
Sales.SpecialOffer |
schema/table |
MS_Description |
Sale discounts lookup table. |
| Object |
Sales.SpecialOffer.SpecialOfferID |
schema/table/column |
MS_Description |
Primary key for SpecialOffer records. |
| Object |
Sales.SpecialOffer.Description |
schema/table/column |
MS_Description |
Discount description. |
| Object |
Sales.SpecialOffer.DiscountPct |
schema/table/column |
MS_Description |
Discount precentage. |
| Object |
Sales.SpecialOffer.Type |
schema/table/column |
MS_Description |
Discount type category. |
| Object |
Sales.SpecialOffer.Category |
schema/table/column |
MS_Description |
Group the discount applies to such as Reseller or Customer. |
| Object |
Sales.SpecialOffer.StartDate |
schema/table/column |
MS_Description |
Discount start date. |
| Object |
Sales.SpecialOffer.EndDate |
schema/table/column |
MS_Description |
Discount end date. |
| Object |
Sales.SpecialOffer.MinQty |
schema/table/column |
MS_Description |
Minimum discount percent allowed. |
| Object |
Sales.SpecialOffer.MaxQty |
schema/table/column |
MS_Description |
Maximum discount percent allowed. |
| Object |
Sales.SpecialOffer.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Sales.SpecialOffer.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.DF_ProductInventory_Quantity.DF_ProductInventory_Quantity |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0 |
| Object |
dbo.ErrorLog |
schema/table |
MS_Description |
Audit table tracking errors in the the AdventureWorks database that are caught by the CATCH block of a TRY...CATCH construct. Data is inserted by stored procedure dbo.uspLogError when it is executed from inside the CATCH block of a TRY...CATCH construct. |
| Object |
dbo.ErrorLog.ErrorLogID |
schema/table/column |
MS_Description |
Primary key for ErrorLog records. |
| Object |
dbo.ErrorLog.ErrorTime |
schema/table/column |
MS_Description |
The date and time at which the error occurred. |
| Object |
dbo.ErrorLog.UserName |
schema/table/column |
MS_Description |
The user who executed the batch in which the error occurred. |
| Object |
dbo.ErrorLog.ErrorNumber |
schema/table/column |
MS_Description |
The error number of the error that occurred. |
| Object |
dbo.ErrorLog.ErrorSeverity |
schema/table/column |
MS_Description |
The severity of the error that occurred. |
| Object |
dbo.ErrorLog.ErrorState |
schema/table/column |
MS_Description |
The state number of the error that occurred. |
| Object |
dbo.ErrorLog.ErrorProcedure |
schema/table/column |
MS_Description |
The name of the stored procedure or trigger where the error occurred. |
| Object |
dbo.ErrorLog.ErrorLine |
schema/table/column |
MS_Description |
The line number at which the error occurred. |
| Object |
dbo.ErrorLog.ErrorMessage |
schema/table/column |
MS_Description |
The message text of the error that occurred. |
| Interface |
dbo.uspGetWhereUsedProductID |
schema/procedure |
MS_Description |
Stored procedure using a recursive query to return all components or assemblies that directly or indirectly use the specified ProductID. |
| Object |
Sales.DF_SpecialOffer_DiscountPct.DF_SpecialOffer_DiscountPct |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0.0 |
| Object |
Production.DF_ProductInventory_rowguid.DF_ProductInventory_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
dbo.DF_ErrorLog_ErrorTime.DF_ErrorLog_ErrorTime |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Interface |
HumanResources.uspUpdateEmployeeHireInfo |
schema/procedure |
MS_Description |
Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters. |
| Object |
Person.FK_Address_StateProvince_StateProvinceID.FK_Address_StateProvince_StateProvinceID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing StateProvince.StateProvinceID. |
| Object |
Sales.DF_SpecialOffer_MinQty.DF_SpecialOffer_MinQty |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0.0 |
| Object |
Production.DF_ProductInventory_ModifiedDate.DF_ProductInventory_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
dbo.PK_ErrorLog_ErrorLogID.PK_ErrorLog_ErrorLogID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Interface |
HumanResources.uspUpdateEmployeeLogin |
schema/procedure |
MS_Description |
Updates the Employee table with the values specified in the input parameters for the given BusinessEntityID. |
| Object |
Production.FK_BillOfMaterials_Product_ProductAssemblyID.FK_BillOfMaterials_Product_ProductAssemblyID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Product.ProductAssemblyID. |
| Object |
Sales.DF_SpecialOffer_rowguid.DF_SpecialOffer_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
Production.CK_ProductInventory_Shelf.CK_ProductInventory_Shelf |
schema/table/check_constraint |
MS_Description |
Check constraint [Shelf] like '[A-Za-z]' OR [Shelf]='N/A' |
| Interface |
dbo.uspPrintError |
schema/procedure |
MS_Description |
Prints error information about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without printing any error information. |
| Interface |
HumanResources.uspUpdateEmployeePersonalInfo |
schema/procedure |
MS_Description |
Updates the Employee table with the values specified in the input parameters for the given EmployeeID. |
| Object |
Production.FK_BillOfMaterials_Product_ComponentID.FK_BillOfMaterials_Product_ComponentID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Product.ComponentID. |
| Object |
Sales.DF_SpecialOffer_ModifiedDate.DF_SpecialOffer_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.CK_ProductInventory_Bin.CK_ProductInventory_Bin |
schema/table/check_constraint |
MS_Description |
Check constraint [Bin] BETWEEN (0) AND (100) |
| Interface |
dbo.uspLogError |
schema/procedure |
MS_Description |
Logs error information in the ErrorLog table about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without inserting error information. |
| Object |
Production.FK_BillOfMaterials_UnitMeasure_UnitMeasureCode.FK_BillOfMaterials_UnitMeasure_UnitMeasureCode |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing UnitMeasure.UnitMeasureCode. |
| Object |
Sales.CK_SpecialOffer_EndDate.CK_SpecialOffer_EndDate |
schema/table/check_constraint |
MS_Description |
Check constraint [EndDate] >= [StartDate] |
| Object |
Production.ProductListPriceHistory |
schema/table |
MS_Description |
Changes in the list price of a product over time. |
| Object |
Production.ProductListPriceHistory.ProductID |
schema/table/column |
MS_Description |
Product identification number. Foreign key to Product.ProductID |
| Object |
Production.ProductListPriceHistory.StartDate |
schema/table/column |
MS_Description |
List price start date. |
| Object |
Production.ProductListPriceHistory.EndDate |
schema/table/column |
MS_Description |
List price end date |
| Object |
Production.ProductListPriceHistory.ListPrice |
schema/table/column |
MS_Description |
Product list price. |
| Object |
Production.ProductListPriceHistory.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Interface |
dbo.ufnLeadingZeros |
schema/function |
MS_Description |
Scalar function used by the Sales.Customer table to help set the account number. |
| Object |
Person.FK_BusinessEntityAddress_Address_AddressID.FK_BusinessEntityAddress_Address_AddressID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Address.AddressID. |
| Object |
Sales.CK_SpecialOffer_DiscountPct.CK_SpecialOffer_DiscountPct |
schema/table/check_constraint |
MS_Description |
Check constraint [DiscountPct] >= (0.00) |
| Object |
Production.DF_ProductListPriceHistory_ModifiedDate.DF_ProductListPriceHistory_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Person.Address |
schema/table |
MS_Description |
Street address information for customers, employees, and vendors. |
| Object |
Person.Address.AddressID |
schema/table/column |
MS_Description |
Primary key for Address records. |
| Object |
Person.Address.AddressLine1 |
schema/table/column |
MS_Description |
First street address line. |
| Object |
Person.Address.AddressLine2 |
schema/table/column |
MS_Description |
Second street address line. |
| Object |
Person.Address.City |
schema/table/column |
MS_Description |
Name of the city. |
| Object |
Person.Address.StateProvinceID |
schema/table/column |
MS_Description |
Unique identification number for the state or province. Foreign key to StateProvince table. |
| Object |
Person.Address.PostalCode |
schema/table/column |
MS_Description |
Postal code for the street address. |
| Object |
Person.Address.SpatialLocation |
schema/table/column |
MS_Description |
Latitude and longitude of this address. |
| Object |
Person.Address.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Person.Address.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Person.FK_BusinessEntityAddress_AddressType_AddressTypeID.FK_BusinessEntityAddress_AddressType_AddressTypeID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing AddressType.AddressTypeID. |
| Object |
Sales.CK_SpecialOffer_MinQty.CK_SpecialOffer_MinQty |
schema/table/check_constraint |
MS_Description |
Check constraint [MinQty] >= (0) |
| Object |
Production.CK_ProductListPriceHistory_EndDate.CK_ProductListPriceHistory_EndDate |
schema/table/check_constraint |
MS_Description |
Check constraint [EndDate] >= [StartDate] OR [EndDate] IS NULL |
| Object |
Person.DF_Address_rowguid.DF_Address_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
Person.FK_BusinessEntityAddress_BusinessEntity_BusinessEntityID.FK_BusinessEntityAddress_BusinessEntity_BusinessEntityID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing BusinessEntity.BusinessEntityID. |
| Object |
Sales.CK_SpecialOffer_MaxQty.CK_SpecialOffer_MaxQty |
schema/table/check_constraint |
MS_Description |
Check constraint [MaxQty] >= (0) |
| Object |
Production.CK_ProductListPriceHistory_ListPrice.CK_ProductListPriceHistory_ListPrice |
schema/table/check_constraint |
MS_Description |
Check constraint [ListPrice] > (0.00) |
| Object |
Person.DF_Address_ModifiedDate.DF_Address_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Person.FK_BusinessEntityContact_Person_PersonID.FK_BusinessEntityContact_Person_PersonID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Person.BusinessEntityID. |
| Object |
Sales.SpecialOfferProduct |
schema/table |
MS_Description |
Cross-reference table mapping products to special offer discounts. |
| Object |
Sales.SpecialOfferProduct.SpecialOfferID |
schema/table/column |
MS_Description |
Primary key for SpecialOfferProduct records. |
| Object |
Sales.SpecialOfferProduct.ProductID |
schema/table/column |
MS_Description |
Product identification number. Foreign key to Product.ProductID. |
| Object |
Sales.SpecialOfferProduct.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Sales.SpecialOfferProduct.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.ProductModel |
schema/table |
MS_Description |
Product model classification. |
| Object |
Production.ProductModel.ProductModelID |
schema/table/column |
MS_Description |
Primary key for ProductModel records. |
| Object |
Production.ProductModel.Name |
schema/table/column |
MS_Description |
Product model description. |
| Object |
Production.ProductModel.CatalogDescription |
schema/table/column |
MS_Description |
Detailed product catalog information in xml format. |
| Object |
Production.ProductModel.Instructions |
schema/table/column |
MS_Description |
Manufacturing instructions in xml format. |
| Object |
Production.ProductModel.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Production.ProductModel.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Person.AddressType |
schema/table |
MS_Description |
Types of addresses stored in the Address table. |
| Object |
Person.AddressType.AddressTypeID |
schema/table/column |
MS_Description |
Primary key for AddressType records. |
| Object |
Person.AddressType.Name |
schema/table/column |
MS_Description |
Address type description. For example, Billing, Home, or Shipping. |
| Object |
Person.AddressType.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Person.AddressType.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Person.FK_BusinessEntityContact_ContactType_ContactTypeID.FK_BusinessEntityContact_ContactType_ContactTypeID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing ContactType.ContactTypeID. |
| Object |
Sales.DF_SpecialOfferProduct_rowguid.DF_SpecialOfferProduct_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
Production.DF_ProductModel_rowguid.DF_ProductModel_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
Person.DF_AddressType_rowguid.DF_AddressType_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
Person.FK_BusinessEntityContact_BusinessEntity_BusinessEntityID.FK_BusinessEntityContact_BusinessEntity_BusinessEntityID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing BusinessEntity.BusinessEntityID. |
| Object |
Sales.DF_SpecialOfferProduct_ModifiedDate.DF_SpecialOfferProduct_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.DF_ProductModel_ModifiedDate.DF_ProductModel_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Person.DF_AddressType_ModifiedDate.DF_AddressType_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Sales.FK_CountryRegionCurrency_CountryRegion_CountryRegionCode.FK_CountryRegionCurrency_CountryRegion_CountryRegionCode |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing CountryRegion.CountryRegionCode. |
| Object |
Person.StateProvince |
schema/table |
MS_Description |
State and province lookup table. |
| Object |
Person.StateProvince.StateProvinceID |
schema/table/column |
MS_Description |
Primary key for StateProvince records. |
| Object |
Person.StateProvince.StateProvinceCode |
schema/table/column |
MS_Description |
ISO standard state or province code. |
| Object |
Person.StateProvince.CountryRegionCode |
schema/table/column |
MS_Description |
ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode. |
| Object |
Person.StateProvince.IsOnlyStateProvinceFlag |
schema/table/column |
MS_Description |
0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode. |
| Object |
Person.StateProvince.Name |
schema/table/column |
MS_Description |
State or province description. |
| Object |
Person.StateProvince.TerritoryID |
schema/table/column |
MS_Description |
ID of the territory in which the state or province is located. Foreign key to SalesTerritory.SalesTerritoryID. |
| Object |
Person.StateProvince.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Person.StateProvince.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.ProductModelIllustration |
schema/table |
MS_Description |
Cross-reference table mapping product models and illustrations. |
| Object |
Production.ProductModelIllustration.ProductModelID |
schema/table/column |
MS_Description |
Primary key. Foreign key to ProductModel.ProductModelID. |
| Object |
Production.ProductModelIllustration.IllustrationID |
schema/table/column |
MS_Description |
Primary key. Foreign key to Illustration.IllustrationID. |
| Object |
Production.ProductModelIllustration.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
dbo.AWBuildVersion |
schema/table |
MS_Description |
Current version number of the AdventureWorks 2016 sample database. |
| Object |
dbo.AWBuildVersion.SystemInformationID |
schema/table/column |
MS_Description |
Primary key for AWBuildVersion records. |
| Object |
dbo.AWBuildVersion.Database Version |
schema/table/column |
MS_Description |
Version number of the database in 9.yy.mm.dd.00 format. |
| Object |
dbo.AWBuildVersion.VersionDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
dbo.AWBuildVersion.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Sales.FK_CountryRegionCurrency_Currency_CurrencyCode.FK_CountryRegionCurrency_Currency_CurrencyCode |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Currency.CurrencyCode. |
| Object |
Person.DF_StateProvince_IsOnlyStateProvinceFlag.DF_StateProvince_IsOnlyStateProvinceFlag |
schema/table/default_constraint |
MS_Description |
Default constraint value of 1 (TRUE) |
| Object |
Production.DF_ProductModelIllustration_ModifiedDate.DF_ProductModelIllustration_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
dbo.DF_AWBuildVersion_ModifiedDate.DF_AWBuildVersion_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Sales.FK_CurrencyRate_Currency_FromCurrencyCode.FK_CurrencyRate_Currency_FromCurrencyCode |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Currency.FromCurrencyCode. |
| Object |
Person.DF_StateProvince_rowguid.DF_StateProvince_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
Production.ProductModelProductDescriptionCulture |
schema/table |
MS_Description |
Cross-reference table mapping product descriptions and the language the description is written in. |
| Object |
Production.ProductModelProductDescriptionCulture.ProductModelID |
schema/table/column |
MS_Description |
Primary key. Foreign key to ProductModel.ProductModelID. |
| Object |
Production.ProductModelProductDescriptionCulture.ProductDescriptionID |
schema/table/column |
MS_Description |
Primary key. Foreign key to ProductDescription.ProductDescriptionID. |
| Object |
Production.ProductModelProductDescriptionCulture.CultureID |
schema/table/column |
MS_Description |
Culture identification number. Foreign key to Culture.CultureID. |
| Object |
Production.ProductModelProductDescriptionCulture.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.BillOfMaterials |
schema/table |
MS_Description |
Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components. |
| Object |
Production.BillOfMaterials.BillOfMaterialsID |
schema/table/column |
MS_Description |
Primary key for BillOfMaterials records. |
| Object |
Production.BillOfMaterials.ProductAssemblyID |
schema/table/column |
MS_Description |
Parent product identification number. Foreign key to Product.ProductID. |
| Object |
Production.BillOfMaterials.ComponentID |
schema/table/column |
MS_Description |
Component identification number. Foreign key to Product.ProductID. |
| Object |
Production.BillOfMaterials.StartDate |
schema/table/column |
MS_Description |
Date the component started being used in the assembly item. |
| Object |
Production.BillOfMaterials.EndDate |
schema/table/column |
MS_Description |
Date the component stopped being used in the assembly item. |
| Object |
Production.BillOfMaterials.UnitMeasureCode |
schema/table/column |
MS_Description |
Standard code identifying the unit of measure for the quantity. |
| Object |
Production.BillOfMaterials.BOMLevel |
schema/table/column |
MS_Description |
Indicates the depth the component is from its parent (AssemblyID). |
| Object |
Production.BillOfMaterials.PerAssemblyQty |
schema/table/column |
MS_Description |
Quantity of the component needed to create the assembly. |
| Object |
Production.BillOfMaterials.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Sales.FK_CurrencyRate_Currency_ToCurrencyCode.FK_CurrencyRate_Currency_ToCurrencyCode |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Currency.ToCurrencyCode. |
| Object |
Person.DF_StateProvince_ModifiedDate.DF_StateProvince_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.DF_ProductModelProductDescriptionCulture_ModifiedDate.DF_ProductModelProductDescriptionCulture_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.DF_BillOfMaterials_StartDate.DF_BillOfMaterials_StartDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Sales.FK_Customer_Person_PersonID.FK_Customer_Person_PersonID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Person.BusinessEntityID. |
| Object |
Sales.Store |
schema/table |
MS_Description |
Customers (resellers) of Adventure Works products. |
| Object |
Sales.Store.BusinessEntityID |
schema/table/column |
MS_Description |
Primary key. Foreign key to Customer.BusinessEntityID. |
| Object |
Sales.Store.Name |
schema/table/column |
MS_Description |
Name of the store. |
| Object |
Sales.Store.SalesPersonID |
schema/table/column |
MS_Description |
ID of the sales person assigned to the customer. Foreign key to SalesPerson.BusinessEntityID. |
| Object |
Sales.Store.Demographics |
schema/table/column |
MS_Description |
Demographic informationg about the store such as the number of employees, annual sales and store type. |
| Object |
Sales.Store.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Sales.Store.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.ProductPhoto |
schema/table |
MS_Description |
Product images. |
| Object |
Production.ProductPhoto.ProductPhotoID |
schema/table/column |
MS_Description |
Primary key for ProductPhoto records. |
| Object |
Production.ProductPhoto.ThumbNailPhoto |
schema/table/column |
MS_Description |
Small image of the product. |
| Object |
Production.ProductPhoto.ThumbnailPhotoFileName |
schema/table/column |
MS_Description |
Small image file name. |
| Object |
Production.ProductPhoto.LargePhoto |
schema/table/column |
MS_Description |
Large image of the product. |
| Object |
Production.ProductPhoto.LargePhotoFileName |
schema/table/column |
MS_Description |
Large image file name. |
| Object |
Production.ProductPhoto.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.DF_BillOfMaterials_PerAssemblyQty.DF_BillOfMaterials_PerAssemblyQty |
schema/table/default_constraint |
MS_Description |
Default constraint value of 1.0 |
| Object |
Sales.FK_Customer_Store_StoreID.FK_Customer_Store_StoreID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Store.BusinessEntityID. |
| Object |
Sales.DF_Store_rowguid.DF_Store_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
Production.DF_ProductPhoto_ModifiedDate.DF_ProductPhoto_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.DF_BillOfMaterials_ModifiedDate.DF_BillOfMaterials_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Sales.FK_Customer_SalesTerritory_TerritoryID.FK_Customer_SalesTerritory_TerritoryID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing SalesTerritory.TerritoryID. |
| Object |
Sales.DF_Store_ModifiedDate.DF_Store_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.ProductProductPhoto |
schema/table |
MS_Description |
Cross-reference table mapping products and product photos. |
| Object |
Production.ProductProductPhoto.ProductID |
schema/table/column |
MS_Description |
Product identification number. Foreign key to Product.ProductID. |
| Object |
Production.ProductProductPhoto.ProductPhotoID |
schema/table/column |
MS_Description |
Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID. |
| Object |
Production.ProductProductPhoto.Primary |
schema/table/column |
MS_Description |
0 = Photo is not the principal image. 1 = Photo is the principal image. |
| Object |
Production.ProductProductPhoto.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.CK_BillOfMaterials_EndDate.CK_BillOfMaterials_EndDate |
schema/table/check_constraint |
MS_Description |
Check constraint EndDate] > [StartDate] OR [EndDate] IS NULL |
| Object |
Production.FK_Document_Employee_Owner.FK_Document_Employee_Owner |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Employee.BusinessEntityID. |
| Object |
Production.TransactionHistory |
schema/table |
MS_Description |
Record of each purchase order, sales order, or work order transaction year to date. |
| Object |
Production.TransactionHistory.TransactionID |
schema/table/column |
MS_Description |
Primary key for TransactionHistory records. |
| Object |
Production.TransactionHistory.ProductID |
schema/table/column |
MS_Description |
Product identification number. Foreign key to Product.ProductID. |
| Object |
Production.TransactionHistory.ReferenceOrderID |
schema/table/column |
MS_Description |
Purchase order, sales order, or work order identification number. |
| Object |
Production.TransactionHistory.ReferenceOrderLineID |
schema/table/column |
MS_Description |
Line number associated with the purchase order, sales order, or work order. |
| Object |
Production.TransactionHistory.TransactionDate |
schema/table/column |
MS_Description |
Date and time of the transaction. |
| Object |
Production.TransactionHistory.TransactionType |
schema/table/column |
MS_Description |
W = WorkOrder, S = SalesOrder, P = PurchaseOrder |
| Object |
Production.TransactionHistory.Quantity |
schema/table/column |
MS_Description |
Product quantity. |
| Object |
Production.TransactionHistory.ActualCost |
schema/table/column |
MS_Description |
Product cost. |
| Object |
Production.TransactionHistory.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.DF_ProductProductPhoto_Primary.DF_ProductProductPhoto_Primary |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0 (FALSE) |
| Object |
Production.CK_BillOfMaterials_ProductAssemblyID.CK_BillOfMaterials_ProductAssemblyID |
schema/table/check_constraint |
MS_Description |
Check constraint [ProductAssemblyID] <> [ComponentID] |
| Object |
Person.FK_EmailAddress_Person_BusinessEntityID.FK_EmailAddress_Person_BusinessEntityID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Person.BusinessEntityID. |
| Object |
Production.DF_TransactionHistory_ReferenceOrderLineID.DF_TransactionHistory_ReferenceOrderLineID |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0 |
| Object |
Production.DF_ProductProductPhoto_ModifiedDate.DF_ProductProductPhoto_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.CK_BillOfMaterials_BOMLevel.CK_BillOfMaterials_BOMLevel |
schema/table/check_constraint |
MS_Description |
Check constraint [ProductAssemblyID] IS NULL AND [BOMLevel] = (0) AND [PerAssemblyQty] = (1) OR [ProductAssemblyID] IS NOT NULL AND [BOMLevel] >= (1) |
| Interface |
dbo.Usp_MyStoredProc |
schema/procedure |
Purpose |
Purpose of Usp_MyStoredProc |
| Object |
HumanResources.FK_Employee_Person_BusinessEntityID.FK_Employee_Person_BusinessEntityID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Person.BusinessEntityID. |
| Object |
Production.DF_TransactionHistory_TransactionDate.DF_TransactionHistory_TransactionDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.ProductReview |
schema/table |
MS_Description |
Customer reviews of products they have purchased. |
| Object |
Production.ProductReview.ProductReviewID |
schema/table/column |
MS_Description |
Primary key for ProductReview records. |
| Object |
Production.ProductReview.ProductID |
schema/table/column |
MS_Description |
Product identification number. Foreign key to Product.ProductID. |
| Object |
Production.ProductReview.ReviewerName |
schema/table/column |
MS_Description |
Name of the reviewer. |
| Object |
Production.ProductReview.ReviewDate |
schema/table/column |
MS_Description |
Date review was submitted. |
| Object |
Production.ProductReview.EmailAddress |
schema/table/column |
MS_Description |
Reviewer's e-mail address. |
| Object |
Production.ProductReview.Rating |
schema/table/column |
MS_Description |
Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating. |
| Object |
Production.ProductReview.Comments |
schema/table/column |
MS_Description |
Reviewer's comments |
| Object |
Production.ProductReview.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.CK_BillOfMaterials_PerAssemblyQty.CK_BillOfMaterials_PerAssemblyQty |
schema/table/check_constraint |
MS_Description |
Check constraint [PerAssemblyQty] >= (1.00) |
| Object |
HumanResources.FK_EmployeeDepartmentHistory_Department_DepartmentID.FK_EmployeeDepartmentHistory_Department_DepartmentID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Department.DepartmentID. |
| Object |
Production.DF_TransactionHistory_ModifiedDate.DF_TransactionHistory_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.DF_ProductReview_ReviewDate.DF_ProductReview_ReviewDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Person.BusinessEntity |
schema/table |
MS_Description |
Source of the ID that connects vendors, customers, and employees with address and contact information. |
| Object |
Person.BusinessEntity.BusinessEntityID |
schema/table/column |
MS_Description |
Primary key for all customers, vendors, and employees. |
| Object |
Person.BusinessEntity.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Person.BusinessEntity.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
HumanResources.FK_EmployeeDepartmentHistory_Employee_BusinessEntityID.FK_EmployeeDepartmentHistory_Employee_BusinessEntityID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Employee.EmployeeID. |
| Object |
Production.CK_TransactionHistory_TransactionType.CK_TransactionHistory_TransactionType |
schema/table/check_constraint |
MS_Description |
Check constraint [TransactionType]='p' OR [TransactionType]='s' OR [TransactionType]='w' OR [TransactionType]='P' OR [TransactionType]='S' OR [TransactionType]='W') |
| Object |
Production.DF_ProductReview_ModifiedDate.DF_ProductReview_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Person.DF_BusinessEntity_rowguid.DF_BusinessEntity_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
HumanResources.FK_EmployeeDepartmentHistory_Shift_ShiftID.FK_EmployeeDepartmentHistory_Shift_ShiftID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Shift.ShiftID |
| Object |
Production.TransactionHistoryArchive |
schema/table |
MS_Description |
Transactions for previous years. |
| Object |
Production.TransactionHistoryArchive.TransactionID |
schema/table/column |
MS_Description |
Primary key for TransactionHistoryArchive records. |
| Object |
Production.TransactionHistoryArchive.ProductID |
schema/table/column |
MS_Description |
Product identification number. Foreign key to Product.ProductID. |
| Object |
Production.TransactionHistoryArchive.ReferenceOrderID |
schema/table/column |
MS_Description |
Purchase order, sales order, or work order identification number. |
| Object |
Production.TransactionHistoryArchive.ReferenceOrderLineID |
schema/table/column |
MS_Description |
Line number associated with the purchase order, sales order, or work order. |
| Object |
Production.TransactionHistoryArchive.TransactionDate |
schema/table/column |
MS_Description |
Date and time of the transaction. |
| Object |
Production.TransactionHistoryArchive.TransactionType |
schema/table/column |
MS_Description |
W = Work Order, S = Sales Order, P = Purchase Order |
| Object |
Production.TransactionHistoryArchive.Quantity |
schema/table/column |
MS_Description |
Product quantity. |
| Object |
Production.TransactionHistoryArchive.ActualCost |
schema/table/column |
MS_Description |
Product cost. |
| Object |
Production.TransactionHistoryArchive.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.CK_ProductReview_Rating.CK_ProductReview_Rating |
schema/table/check_constraint |
MS_Description |
Check constraint [Rating] BETWEEN (1) AND (5) |
| Object |
Person.DF_BusinessEntity_ModifiedDate.DF_BusinessEntity_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
HumanResources.FK_EmployeePayHistory_Employee_BusinessEntityID.FK_EmployeePayHistory_Employee_BusinessEntityID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Employee.EmployeeID. |
| Object |
Production.DF_TransactionHistoryArchive_ReferenceOrderLineID.DF_TransactionHistoryArchive_ReferenceOrderLineID |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0 |
| Object |
Production.ProductSubcategory |
schema/table |
MS_Description |
Product subcategories. See ProductCategory table. |
| Object |
Production.ProductSubcategory.ProductSubcategoryID |
schema/table/column |
MS_Description |
Primary key for ProductSubcategory records. |
| Object |
Production.ProductSubcategory.ProductCategoryID |
schema/table/column |
MS_Description |
Product category identification number. Foreign key to ProductCategory.ProductCategoryID. |
| Object |
Production.ProductSubcategory.Name |
schema/table/column |
MS_Description |
Subcategory description. |
| Object |
Production.ProductSubcategory.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Production.ProductSubcategory.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Person.BusinessEntityAddress |
schema/table |
MS_Description |
Cross-reference table mapping customers, vendors, and employees to their addresses. |
| Object |
Person.BusinessEntityAddress.BusinessEntityID |
schema/table/column |
MS_Description |
Primary key. Foreign key to BusinessEntity.BusinessEntityID. |
| Object |
Person.BusinessEntityAddress.AddressID |
schema/table/column |
MS_Description |
Primary key. Foreign key to Address.AddressID. |
| Object |
Person.BusinessEntityAddress.AddressTypeID |
schema/table/column |
MS_Description |
Primary key. Foreign key to AddressType.AddressTypeID. |
| Object |
Person.BusinessEntityAddress.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Person.BusinessEntityAddress.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
HumanResources.FK_JobCandidate_Employee_BusinessEntityID.FK_JobCandidate_Employee_BusinessEntityID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Employee.EmployeeID. |
| Object |
Production.DF_TransactionHistoryArchive_TransactionDate.DF_TransactionHistoryArchive_TransactionDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.DF_ProductSubcategory_rowguid.DF_ProductSubcategory_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
Person.DF_BusinessEntityAddress_rowguid.DF_BusinessEntityAddress_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
Person.FK_Password_Person_BusinessEntityID.FK_Password_Person_BusinessEntityID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Person.BusinessEntityID. |
| Object |
Production.DF_TransactionHistoryArchive_ModifiedDate.DF_TransactionHistoryArchive_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.DF_ProductSubcategory_ModifiedDate.DF_ProductSubcategory_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Person.DF_BusinessEntityAddress_ModifiedDate.DF_BusinessEntityAddress_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Person.FK_Person_BusinessEntity_BusinessEntityID.FK_Person_BusinessEntity_BusinessEntityID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing BusinessEntity.BusinessEntityID. |
| Object |
Production.CK_TransactionHistoryArchive_TransactionType.CK_TransactionHistoryArchive_TransactionType |
schema/table/check_constraint |
MS_Description |
Check constraint [TransactionType]='p' OR [TransactionType]='s' OR [TransactionType]='w' OR [TransactionType]='P' OR [TransactionType]='S' OR [TransactionType]='W' |
| Object |
Purchasing.ProductVendor |
schema/table |
MS_Description |
Cross-reference table mapping vendors with the products they supply. |
| Object |
Purchasing.ProductVendor.ProductID |
schema/table/column |
MS_Description |
Primary key. Foreign key to Product.ProductID. |
| Object |
Purchasing.ProductVendor.BusinessEntityID |
schema/table/column |
MS_Description |
Primary key. Foreign key to Vendor.BusinessEntityID. |
| Object |
Purchasing.ProductVendor.AverageLeadTime |
schema/table/column |
MS_Description |
The average span of time (in days) between placing an order with the vendor and receiving the purchased product. |
| Object |
Purchasing.ProductVendor.StandardPrice |
schema/table/column |
MS_Description |
The vendor's usual selling price. |
| Object |
Purchasing.ProductVendor.LastReceiptCost |
schema/table/column |
MS_Description |
The selling price when last purchased. |
| Object |
Purchasing.ProductVendor.LastReceiptDate |
schema/table/column |
MS_Description |
Date the product was last received by the vendor. |
| Object |
Purchasing.ProductVendor.MinOrderQty |
schema/table/column |
MS_Description |
The maximum quantity that should be ordered. |
| Object |
Purchasing.ProductVendor.MaxOrderQty |
schema/table/column |
MS_Description |
The minimum quantity that should be ordered. |
| Object |
Purchasing.ProductVendor.OnOrderQty |
schema/table/column |
MS_Description |
The quantity currently on order. |
| Object |
Purchasing.ProductVendor.UnitMeasureCode |
schema/table/column |
MS_Description |
The product's unit of measure. |
| Object |
Purchasing.ProductVendor.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Person.BusinessEntityContact |
schema/table |
MS_Description |
Cross-reference table mapping stores, vendors, and employees to people |
| Object |
Person.BusinessEntityContact.BusinessEntityID |
schema/table/column |
MS_Description |
Primary key. Foreign key to BusinessEntity.BusinessEntityID. |
| Object |
Person.BusinessEntityContact.PersonID |
schema/table/column |
MS_Description |
Primary key. Foreign key to Person.BusinessEntityID. |
| Object |
Person.BusinessEntityContact.ContactTypeID |
schema/table/column |
MS_Description |
Primary key. Foreign key to ContactType.ContactTypeID. |
| Object |
Person.BusinessEntityContact.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Person.BusinessEntityContact.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Sales.FK_PersonCreditCard_Person_BusinessEntityID.FK_PersonCreditCard_Person_BusinessEntityID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Person.BusinessEntityID. |
| Object |
Production.UnitMeasure |
schema/table |
MS_Description |
Unit of measure lookup table. |
| Object |
Production.UnitMeasure.UnitMeasureCode |
schema/table/column |
MS_Description |
Primary key. |
| Object |
Production.UnitMeasure.Name |
schema/table/column |
MS_Description |
Unit of measure description. |
| Object |
Production.UnitMeasure.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Purchasing.DF_ProductVendor_ModifiedDate.DF_ProductVendor_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Person.DF_BusinessEntityContact_rowguid.DF_BusinessEntityContact_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
Sales.FK_PersonCreditCard_CreditCard_CreditCardID.FK_PersonCreditCard_CreditCard_CreditCardID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing CreditCard.CreditCardID. |
| Object |
Production.DF_UnitMeasure_ModifiedDate.DF_UnitMeasure_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Purchasing.CK_ProductVendor_AverageLeadTime.CK_ProductVendor_AverageLeadTime |
schema/table/check_constraint |
MS_Description |
Check constraint [AverageLeadTime] >= (1) |
| Object |
Person.DF_BusinessEntityContact_ModifiedDate.DF_BusinessEntityContact_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Person.FK_PersonPhone_Person_BusinessEntityID.FK_PersonPhone_Person_BusinessEntityID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Person.BusinessEntityID. |
| Object |
Purchasing.Vendor |
schema/table |
MS_Description |
Companies from whom Adventure Works Cycles purchases parts or other goods. |
| Object |
Purchasing.Vendor.BusinessEntityID |
schema/table/column |
MS_Description |
Primary key for Vendor records. Foreign key to BusinessEntity.BusinessEntityID |
| Object |
Purchasing.Vendor.AccountNumber |
schema/table/column |
MS_Description |
Vendor account (identification) number. |
| Object |
Purchasing.Vendor.Name |
schema/table/column |
MS_Description |
Company name. |
| Object |
Purchasing.Vendor.CreditRating |
schema/table/column |
MS_Description |
1 = Superior, 2 = Excellent, 3 = Above average, 4 = Average, 5 = Below average |
| Object |
Purchasing.Vendor.PreferredVendorStatus |
schema/table/column |
MS_Description |
0 = Do not use if another vendor is available. 1 = Preferred over other vendors supplying the same product. |
| Object |
Purchasing.Vendor.ActiveFlag |
schema/table/column |
MS_Description |
0 = Vendor no longer used. 1 = Vendor is actively used. |
| Object |
Purchasing.Vendor.PurchasingWebServiceURL |
schema/table/column |
MS_Description |
Vendor URL. |
| Object |
Purchasing.Vendor.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Purchasing.CK_ProductVendor_StandardPrice.CK_ProductVendor_StandardPrice |
schema/table/check_constraint |
MS_Description |
Check constraint [StandardPrice] > (0.00) |
| Object |
Person.ContactType |
schema/table |
MS_Description |
Lookup table containing the types of business entity contacts. |
| Object |
Person.ContactType.ContactTypeID |
schema/table/column |
MS_Description |
Primary key for ContactType records. |
| Object |
Person.ContactType.Name |
schema/table/column |
MS_Description |
Contact type description. |
| Object |
Person.ContactType.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Person.FK_PersonPhone_PhoneNumberType_PhoneNumberTypeID.FK_PersonPhone_PhoneNumberType_PhoneNumberTypeID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing PhoneNumberType.PhoneNumberTypeID. |
| Object |
Purchasing.DF_Vendor_PreferredVendorStatus.DF_Vendor_PreferredVendorStatus |
schema/table/default_constraint |
MS_Description |
Default constraint value of 1 (TRUE) |
| Object |
Purchasing.CK_ProductVendor_LastReceiptCost.CK_ProductVendor_LastReceiptCost |
schema/table/check_constraint |
MS_Description |
Check constraint [LastReceiptCost] > (0.00) |
| Object |
Person.DF_ContactType_ModifiedDate.DF_ContactType_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.FK_Product_UnitMeasure_SizeUnitMeasureCode.FK_Product_UnitMeasure_SizeUnitMeasureCode |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing UnitMeasure.UnitMeasureCode. |
| Object |
Purchasing.DF_Vendor_ActiveFlag.DF_Vendor_ActiveFlag |
schema/table/default_constraint |
MS_Description |
Default constraint value of 1 (TRUE) |
| Object |
Purchasing.CK_ProductVendor_MinOrderQty.CK_ProductVendor_MinOrderQty |
schema/table/check_constraint |
MS_Description |
Check constraint [MinOrderQty] >= (1) |
| Object |
Sales.CountryRegionCurrency |
schema/table |
MS_Description |
Cross-reference table mapping ISO currency codes to a country or region. |
| Object |
Sales.CountryRegionCurrency.CountryRegionCode |
schema/table/column |
MS_Description |
ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode. |
| Object |
Sales.CountryRegionCurrency.CurrencyCode |
schema/table/column |
MS_Description |
ISO standard currency code. Foreign key to Currency.CurrencyCode. |
| Object |
Sales.CountryRegionCurrency.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.FK_Product_UnitMeasure_WeightUnitMeasureCode.FK_Product_UnitMeasure_WeightUnitMeasureCode |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing UnitMeasure.UnitMeasureCode. |
| Object |
Purchasing.DF_Vendor_ModifiedDate.DF_Vendor_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Purchasing.CK_ProductVendor_MaxOrderQty.CK_ProductVendor_MaxOrderQty |
schema/table/check_constraint |
MS_Description |
Check constraint [MaxOrderQty] >= (1) |
| Object |
Sales.DF_CountryRegionCurrency_ModifiedDate.DF_CountryRegionCurrency_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.FK_Product_ProductModel_ProductModelID.FK_Product_ProductModel_ProductModelID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing ProductModel.ProductModelID. |
| Object |
Purchasing.CK_Vendor_CreditRating.CK_Vendor_CreditRating |
schema/table/check_constraint |
MS_Description |
Check constraint [CreditRating] BETWEEN (1) AND (5) |
| Object |
Purchasing.CK_ProductVendor_OnOrderQty.CK_ProductVendor_OnOrderQty |
schema/table/check_constraint |
MS_Description |
Check constraint [OnOrderQty] >= (0) |
| Object |
Person.CountryRegion |
schema/table |
MS_Description |
Lookup table containing the ISO standard codes for countries and regions. |
| Object |
Person.CountryRegion.CountryRegionCode |
schema/table/column |
MS_Description |
ISO standard code for countries and regions. |
| Object |
Person.CountryRegion.Name |
schema/table/column |
MS_Description |
Country or region name. |
| Object |
Person.CountryRegion.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.FK_Product_ProductSubcategory_ProductSubcategoryID.FK_Product_ProductSubcategory_ProductSubcategoryID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing ProductSubcategory.ProductSubcategoryID. |
| Object |
Production.WorkOrder |
schema/table |
MS_Description |
Manufacturing work orders. |
| Object |
Production.WorkOrder.WorkOrderID |
schema/table/column |
MS_Description |
Primary key for WorkOrder records. |
| Object |
Production.WorkOrder.ProductID |
schema/table/column |
MS_Description |
Product identification number. Foreign key to Product.ProductID. |
| Object |
Production.WorkOrder.OrderQty |
schema/table/column |
MS_Description |
Product quantity to build. |
| Object |
Production.WorkOrder.StockedQty |
schema/table/column |
MS_Description |
Quantity built and put in inventory. |
| Object |
Production.WorkOrder.ScrappedQty |
schema/table/column |
MS_Description |
Quantity that failed inspection. |
| Object |
Production.WorkOrder.StartDate |
schema/table/column |
MS_Description |
Work order start date. |
| Object |
Production.WorkOrder.EndDate |
schema/table/column |
MS_Description |
Work order end date. |
| Object |
Production.WorkOrder.DueDate |
schema/table/column |
MS_Description |
Work order due date. |
| Object |
Production.WorkOrder.ScrapReasonID |
schema/table/column |
MS_Description |
Reason for inspection failure. |
| Object |
Production.WorkOrder.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Purchasing.PurchaseOrderDetail |
schema/table |
MS_Description |
Individual products associated with a specific purchase order. See PurchaseOrderHeader. |
| Object |
Purchasing.PurchaseOrderDetail.PurchaseOrderID |
schema/table/column |
MS_Description |
Primary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID. |
| Object |
Purchasing.PurchaseOrderDetail.PurchaseOrderDetailID |
schema/table/column |
MS_Description |
Primary key. One line number per purchased product. |
| Object |
Purchasing.PurchaseOrderDetail.DueDate |
schema/table/column |
MS_Description |
Date the product is expected to be received. |
| Object |
Purchasing.PurchaseOrderDetail.OrderQty |
schema/table/column |
MS_Description |
Quantity ordered. |
| Object |
Purchasing.PurchaseOrderDetail.ProductID |
schema/table/column |
MS_Description |
Product identification number. Foreign key to Product.ProductID. |
| Object |
Purchasing.PurchaseOrderDetail.UnitPrice |
schema/table/column |
MS_Description |
Vendor's selling price of a single product. |
| Object |
Purchasing.PurchaseOrderDetail.LineTotal |
schema/table/column |
MS_Description |
Per product subtotal. Computed as OrderQty * UnitPrice. |
| Object |
Purchasing.PurchaseOrderDetail.ReceivedQty |
schema/table/column |
MS_Description |
Quantity actually received from the vendor. |
| Object |
Purchasing.PurchaseOrderDetail.RejectedQty |
schema/table/column |
MS_Description |
Quantity rejected during inspection. |
| Object |
Purchasing.PurchaseOrderDetail.StockedQty |
schema/table/column |
MS_Description |
Quantity accepted into inventory. Computed as ReceivedQty - RejectedQty. |
| Object |
Purchasing.PurchaseOrderDetail.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Person.DF_CountryRegion_ModifiedDate.DF_CountryRegion_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.FK_ProductCostHistory_Product_ProductID.FK_ProductCostHistory_Product_ProductID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Product.ProductID. |
| Object |
Production.DF_WorkOrder_ModifiedDate.DF_WorkOrder_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Purchasing.DF_PurchaseOrderDetail_ModifiedDate.DF_PurchaseOrderDetail_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Sales.CreditCard |
schema/table |
MS_Description |
Customer credit card information. |
| Object |
Sales.CreditCard.CreditCardID |
schema/table/column |
MS_Description |
Primary key for CreditCard records. |
| Object |
Sales.CreditCard.CardType |
schema/table/column |
MS_Description |
Credit card name. |
| Object |
Sales.CreditCard.CardNumber |
schema/table/column |
MS_Description |
Credit card number. |
| Object |
Sales.CreditCard.ExpMonth |
schema/table/column |
MS_Description |
Credit card expiration month. |
| Object |
Sales.CreditCard.ExpYear |
schema/table/column |
MS_Description |
Credit card expiration year. |
| Object |
Sales.CreditCard.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.FK_ProductDocument_Product_ProductID.FK_ProductDocument_Product_ProductID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Product.ProductID. |
| Object |
Production.CK_WorkOrder_OrderQty.CK_WorkOrder_OrderQty |
schema/table/check_constraint |
MS_Description |
Check constraint [OrderQty] > (0) |
| Object |
Purchasing.CK_PurchaseOrderDetail_OrderQty.CK_PurchaseOrderDetail_OrderQty |
schema/table/check_constraint |
MS_Description |
Check constraint [OrderQty] > (0) |
| Object |
Sales.DF_CreditCard_ModifiedDate.DF_CreditCard_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.FK_ProductDocument_Document_DocumentNode.FK_ProductDocument_Document_DocumentNode |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Document.DocumentNode. |
| Object |
Production.CK_WorkOrder_ScrappedQty.CK_WorkOrder_ScrappedQty |
schema/table/check_constraint |
MS_Description |
Check constraint [ScrappedQty] >= (0) |
| Object |
Purchasing.CK_PurchaseOrderDetail_UnitPrice.CK_PurchaseOrderDetail_UnitPrice |
schema/table/check_constraint |
MS_Description |
Check constraint [UnitPrice] >= (0.00) |
| Object |
Production.Culture |
schema/table |
MS_Description |
Lookup table containing the languages in which some AdventureWorks data is stored. |
| Object |
Production.Culture.CultureID |
schema/table/column |
MS_Description |
Primary key for Culture records. |
| Object |
Production.Culture.Name |
schema/table/column |
MS_Description |
Culture description. |
| Object |
Production.Culture.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.FK_ProductInventory_Location_LocationID.FK_ProductInventory_Location_LocationID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Location.LocationID. |
| Object |
Production.CK_WorkOrder_EndDate.CK_WorkOrder_EndDate |
schema/table/check_constraint |
MS_Description |
Check constraint [EndDate] >= [StartDate] OR [EndDate] IS NULL |
| Object |
Purchasing.CK_PurchaseOrderDetail_ReceivedQty.CK_PurchaseOrderDetail_ReceivedQty |
schema/table/check_constraint |
MS_Description |
Check constraint [ReceivedQty] >= (0.00) |
| Object |
Production.DF_Culture_ModifiedDate.DF_Culture_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.FK_ProductInventory_Product_ProductID.FK_ProductInventory_Product_ProductID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Product.ProductID. |
| Object |
Production.WorkOrderRouting |
schema/table |
MS_Description |
Work order details. |
| Object |
Production.WorkOrderRouting.WorkOrderID |
schema/table/column |
MS_Description |
Primary key. Foreign key to WorkOrder.WorkOrderID. |
| Object |
Production.WorkOrderRouting.ProductID |
schema/table/column |
MS_Description |
Primary key. Foreign key to Product.ProductID. |
| Object |
Production.WorkOrderRouting.OperationSequence |
schema/table/column |
MS_Description |
Primary key. Indicates the manufacturing process sequence. |
| Object |
Production.WorkOrderRouting.LocationID |
schema/table/column |
MS_Description |
Manufacturing location where the part is processed. Foreign key to Location.LocationID. |
| Object |
Production.WorkOrderRouting.ScheduledStartDate |
schema/table/column |
MS_Description |
Planned manufacturing start date. |
| Object |
Production.WorkOrderRouting.ScheduledEndDate |
schema/table/column |
MS_Description |
Planned manufacturing end date. |
| Object |
Production.WorkOrderRouting.ActualStartDate |
schema/table/column |
MS_Description |
Actual start date. |
| Object |
Production.WorkOrderRouting.ActualEndDate |
schema/table/column |
MS_Description |
Actual end date. |
| Object |
Production.WorkOrderRouting.ActualResourceHrs |
schema/table/column |
MS_Description |
Number of manufacturing hours used. |
| Object |
Production.WorkOrderRouting.PlannedCost |
schema/table/column |
MS_Description |
Estimated manufacturing cost. |
| Object |
Production.WorkOrderRouting.ActualCost |
schema/table/column |
MS_Description |
Actual manufacturing cost. |
| Object |
Production.WorkOrderRouting.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Purchasing.CK_PurchaseOrderDetail_RejectedQty.CK_PurchaseOrderDetail_RejectedQty |
schema/table/check_constraint |
MS_Description |
Check constraint [RejectedQty] >= (0.00) |
| Object |
Sales.Currency |
schema/table |
MS_Description |
Lookup table containing standard ISO currencies. |
| Object |
Sales.Currency.CurrencyCode |
schema/table/column |
MS_Description |
The ISO code for the Currency. |
| Object |
Sales.Currency.Name |
schema/table/column |
MS_Description |
Currency name. |
| Object |
Sales.Currency.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.FK_ProductListPriceHistory_Product_ProductID.FK_ProductListPriceHistory_Product_ProductID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Product.ProductID. |
| Object |
Production.DF_WorkOrderRouting_ModifiedDate.DF_WorkOrderRouting_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Purchasing.PurchaseOrderHeader |
schema/table |
MS_Description |
General purchase order information. See PurchaseOrderDetail. |
| Object |
Purchasing.PurchaseOrderHeader.PurchaseOrderID |
schema/table/column |
MS_Description |
Primary key. |
| Object |
Purchasing.PurchaseOrderHeader.RevisionNumber |
schema/table/column |
MS_Description |
Incremental number to track changes to the purchase order over time. |
| Object |
Purchasing.PurchaseOrderHeader.Status |
schema/table/column |
MS_Description |
Order current status. 1 = Pending; 2 = Approved; 3 = Rejected; 4 = Complete |
| Object |
Purchasing.PurchaseOrderHeader.EmployeeID |
schema/table/column |
MS_Description |
Employee who created the purchase order. Foreign key to Employee.BusinessEntityID. |
| Object |
Purchasing.PurchaseOrderHeader.VendorID |
schema/table/column |
MS_Description |
Vendor with whom the purchase order is placed. Foreign key to Vendor.BusinessEntityID. |
| Object |
Purchasing.PurchaseOrderHeader.ShipMethodID |
schema/table/column |
MS_Description |
Shipping method. Foreign key to ShipMethod.ShipMethodID. |
| Object |
Purchasing.PurchaseOrderHeader.OrderDate |
schema/table/column |
MS_Description |
Purchase order creation date. |
| Object |
Purchasing.PurchaseOrderHeader.ShipDate |
schema/table/column |
MS_Description |
Estimated shipment date from the vendor. |
| Object |
Purchasing.PurchaseOrderHeader.SubTotal |
schema/table/column |
MS_Description |
Purchase order subtotal. Computed as SUM(PurchaseOrderDetail.LineTotal)for the appropriate PurchaseOrderID. |
| Object |
Purchasing.PurchaseOrderHeader.TaxAmt |
schema/table/column |
MS_Description |
Tax amount. |
| Object |
Purchasing.PurchaseOrderHeader.Freight |
schema/table/column |
MS_Description |
Shipping cost. |
| Object |
Purchasing.PurchaseOrderHeader.TotalDue |
schema/table/column |
MS_Description |
Total due to vendor. Computed as Subtotal + TaxAmt + Freight. |
| Object |
Purchasing.PurchaseOrderHeader.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Sales.DF_Currency_ModifiedDate.DF_Currency_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.FK_ProductModelIllustration_ProductModel_ProductModelID.FK_ProductModelIllustration_ProductModel_ProductModelID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing ProductModel.ProductModelID. |
| Object |
Production.CK_WorkOrderRouting_ScheduledEndDate.CK_WorkOrderRouting_ScheduledEndDate |
schema/table/check_constraint |
MS_Description |
Check constraint [ScheduledEndDate] >= [ScheduledStartDate] |
| Object |
Purchasing.DF_PurchaseOrderHeader_RevisionNumber.DF_PurchaseOrderHeader_RevisionNumber |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0 |
| Object |
Sales.CurrencyRate |
schema/table |
MS_Description |
Currency exchange rates. |
| Object |
Sales.CurrencyRate.CurrencyRateID |
schema/table/column |
MS_Description |
Primary key for CurrencyRate records. |
| Object |
Sales.CurrencyRate.CurrencyRateDate |
schema/table/column |
MS_Description |
Date and time the exchange rate was obtained. |
| Object |
Sales.CurrencyRate.FromCurrencyCode |
schema/table/column |
MS_Description |
Exchange rate was converted from this currency code. |
| Object |
Sales.CurrencyRate.ToCurrencyCode |
schema/table/column |
MS_Description |
Exchange rate was converted to this currency code. |
| Object |
Sales.CurrencyRate.AverageRate |
schema/table/column |
MS_Description |
Average exchange rate for the day. |
| Object |
Sales.CurrencyRate.EndOfDayRate |
schema/table/column |
MS_Description |
Final exchange rate for the day. |
| Object |
Sales.CurrencyRate.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.FK_ProductModelIllustration_Illustration_IllustrationID.FK_ProductModelIllustration_Illustration_IllustrationID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Illustration.IllustrationID. |
| Object |
Production.CK_WorkOrderRouting_ActualEndDate.CK_WorkOrderRouting_ActualEndDate |
schema/table/check_constraint |
MS_Description |
Check constraint [ActualEndDate] >= [ActualStartDate] OR [ActualEndDate] IS NULL OR [ActualStartDate] IS NULL |
| Object |
Purchasing.DF_PurchaseOrderHeader_Status.DF_PurchaseOrderHeader_Status |
schema/table/default_constraint |
MS_Description |
Default constraint value of 1 |
| Object |
Sales.DF_CurrencyRate_ModifiedDate.DF_CurrencyRate_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID.FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing ProductDescription.ProductDescriptionID. |
| Object |
Production.CK_WorkOrderRouting_ActualResourceHrs.CK_WorkOrderRouting_ActualResourceHrs |
schema/table/check_constraint |
MS_Description |
Check constraint [ActualResourceHrs] >= (0.0000) |
| Object |
Purchasing.DF_PurchaseOrderHeader_OrderDate.DF_PurchaseOrderHeader_OrderDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Sales.Customer |
schema/table |
MS_Description |
Current customer information. Also see the Person and Store tables. |
| Object |
Sales.Customer.CustomerID |
schema/table/column |
MS_Description |
Primary key. |
| Object |
Sales.Customer.PersonID |
schema/table/column |
MS_Description |
Foreign key to Person.BusinessEntityID |
| Object |
Sales.Customer.StoreID |
schema/table/column |
MS_Description |
Foreign key to Store.BusinessEntityID |
| Object |
Sales.Customer.TerritoryID |
schema/table/column |
MS_Description |
ID of the territory in which the customer is located. Foreign key to SalesTerritory.SalesTerritoryID. |
| Object |
Sales.Customer.AccountNumber |
schema/table/column |
MS_Description |
Unique number identifying the customer assigned by the accounting system. |
| Object |
Sales.Customer.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Sales.Customer.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.FK_ProductModelProductDescriptionCulture_Culture_CultureID.FK_ProductModelProductDescriptionCulture_Culture_CultureID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Culture.CultureID. |
| Object |
Production.CK_WorkOrderRouting_PlannedCost.CK_WorkOrderRouting_PlannedCost |
schema/table/check_constraint |
MS_Description |
Check constraint [PlannedCost] > (0.00) |
| Object |
Purchasing.DF_PurchaseOrderHeader_SubTotal.DF_PurchaseOrderHeader_SubTotal |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0.0 |
| Object |
Sales.DF_Customer_rowguid.DF_Customer_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
Production.FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID.FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing ProductModel.ProductModelID. |
| Object |
Production.CK_WorkOrderRouting_ActualCost.CK_WorkOrderRouting_ActualCost |
schema/table/check_constraint |
MS_Description |
Check constraint [ActualCost] > (0.00) |
| Object |
Purchasing.DF_PurchaseOrderHeader_TaxAmt.DF_PurchaseOrderHeader_TaxAmt |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0.0 |
| Object |
Sales.DF_Customer_ModifiedDate.DF_Customer_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.FK_ProductProductPhoto_Product_ProductID.FK_ProductProductPhoto_Product_ProductID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Product.ProductID. |
| Object |
Person.PK_Address_AddressID.PK_Address_AddressID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Purchasing.DF_PurchaseOrderHeader_Freight.DF_PurchaseOrderHeader_Freight |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0.0 |
| Object |
HumanResources.Department |
schema/table |
MS_Description |
Lookup table containing the departments within the Adventure Works Cycles company. |
| Object |
HumanResources.Department.DepartmentID |
schema/table/column |
MS_Description |
Primary key for Department records. |
| Object |
HumanResources.Department.Name |
schema/table/column |
MS_Description |
Name of the department. |
| Object |
HumanResources.Department.GroupName |
schema/table/column |
MS_Description |
Name of the group to which the department belongs. |
| Object |
HumanResources.Department.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.FK_ProductProductPhoto_ProductPhoto_ProductPhotoID.FK_ProductProductPhoto_ProductPhoto_ProductPhotoID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing ProductPhoto.ProductPhotoID. |
| Object |
Person.PK_AddressType_AddressTypeID.PK_AddressType_AddressTypeID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Purchasing.DF_PurchaseOrderHeader_ModifiedDate.DF_PurchaseOrderHeader_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
HumanResources.DF_Department_ModifiedDate.DF_Department_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Production.FK_ProductReview_Product_ProductID.FK_ProductReview_Product_ProductID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Product.ProductID. |
| Object |
dbo.PK_AWBuildVersion_SystemInformationID.PK_AWBuildVersion_SystemInformationID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Purchasing.CK_PurchaseOrderHeader_Status.CK_PurchaseOrderHeader_Status |
schema/table/check_constraint |
MS_Description |
Check constraint [Status] BETWEEN (1) AND (4) |
| Object |
Production.Document |
schema/table |
MS_Description |
Product maintenance documents. |
| Object |
Production.Document.DocumentNode |
schema/table/column |
MS_Description |
Primary key for Document records. |
| Object |
Production.Document.DocumentLevel |
schema/table/column |
MS_Description |
Depth in the document hierarchy. |
| Object |
Production.Document.Title |
schema/table/column |
MS_Description |
Title of the document. |
| Object |
Production.Document.Owner |
schema/table/column |
MS_Description |
Employee who controls the document. Foreign key to Employee.BusinessEntityID |
| Object |
Production.Document.FolderFlag |
schema/table/column |
MS_Description |
0 = This is a folder, 1 = This is a document. |
| Object |
Production.Document.FileName |
schema/table/column |
MS_Description |
File name of the document |
| Object |
Production.Document.FileExtension |
schema/table/column |
MS_Description |
File extension indicating the document type. For example, .doc or .txt. |
| Object |
Production.Document.Revision |
schema/table/column |
MS_Description |
Revision number of the document. |
| Object |
Production.Document.ChangeNumber |
schema/table/column |
MS_Description |
Engineering change approval number. |
| Object |
Production.Document.Status |
schema/table/column |
MS_Description |
1 = Pending approval, 2 = Approved, 3 = Obsolete |
| Object |
Production.Document.DocumentSummary |
schema/table/column |
MS_Description |
Document abstract. |
| Object |
Production.Document.Document |
schema/table/column |
MS_Description |
Complete document. |
| Object |
Production.Document.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Required for FileStream. |
| Object |
Production.Document.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.FK_ProductSubcategory_ProductCategory_ProductCategoryID.FK_ProductSubcategory_ProductCategory_ProductCategoryID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing ProductCategory.ProductCategoryID. |
| Object |
Production.PK_BillOfMaterials_BillOfMaterialsID.PK_BillOfMaterials_BillOfMaterialsID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Purchasing.CK_PurchaseOrderHeader_ShipDate.CK_PurchaseOrderHeader_ShipDate |
schema/table/check_constraint |
MS_Description |
Check constraint [ShipDate] >= [OrderDate] OR [ShipDate] IS NULL |
| Object |
Purchasing.FK_ProductVendor_Product_ProductID.FK_ProductVendor_Product_ProductID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Product.ProductID. |
| Object |
Person.PK_BusinessEntity_BusinessEntityID.PK_BusinessEntity_BusinessEntityID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Purchasing.CK_PurchaseOrderHeader_SubTotal.CK_PurchaseOrderHeader_SubTotal |
schema/table/check_constraint |
MS_Description |
Check constraint [SubTotal] >= (0.00) |
| Object |
Purchasing.FK_ProductVendor_UnitMeasure_UnitMeasureCode.FK_ProductVendor_UnitMeasure_UnitMeasureCode |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing UnitMeasure.UnitMeasureCode. |
| Object |
Person.PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID.PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Purchasing.CK_PurchaseOrderHeader_TaxAmt.CK_PurchaseOrderHeader_TaxAmt |
schema/table/check_constraint |
MS_Description |
Check constraint [TaxAmt] >= (0.00) |
| Object |
Production.DF_Document_ChangeNumber.DF_Document_ChangeNumber |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0 |
| Object |
Purchasing.FK_ProductVendor_Vendor_BusinessEntityID.FK_ProductVendor_Vendor_BusinessEntityID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Vendor.BusinessEntityID. |
| Object |
Person.PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID.PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Purchasing.CK_PurchaseOrderHeader_Freight.CK_PurchaseOrderHeader_Freight |
schema/table/check_constraint |
MS_Description |
Check constraint [Freight] >= (0.00) |
| Object |
Production.DF_Document_rowguid.DF_Document_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
Purchasing.FK_PurchaseOrderDetail_Product_ProductID.FK_PurchaseOrderDetail_Product_ProductID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Product.ProductID. |
| Object |
Person.PK_ContactType_ContactTypeID.PK_ContactType_ContactTypeID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.SalesOrderDetail |
schema/table |
MS_Description |
Individual products associated with a specific sales order. See SalesOrderHeader. |
| Object |
Sales.SalesOrderDetail.SalesOrderID |
schema/table/column |
MS_Description |
Primary key. Foreign key to SalesOrderHeader.SalesOrderID. |
| Object |
Sales.SalesOrderDetail.SalesOrderDetailID |
schema/table/column |
MS_Description |
Primary key. One incremental unique number per product sold. |
| Object |
Sales.SalesOrderDetail.CarrierTrackingNumber |
schema/table/column |
MS_Description |
Shipment tracking number supplied by the shipper. |
| Object |
Sales.SalesOrderDetail.OrderQty |
schema/table/column |
MS_Description |
Quantity ordered per product. |
| Object |
Sales.SalesOrderDetail.ProductID |
schema/table/column |
MS_Description |
Product sold to customer. Foreign key to Product.ProductID. |
| Object |
Sales.SalesOrderDetail.SpecialOfferID |
schema/table/column |
MS_Description |
Promotional code. Foreign key to SpecialOffer.SpecialOfferID. |
| Object |
Sales.SalesOrderDetail.UnitPrice |
schema/table/column |
MS_Description |
Selling price of a single product. |
| Object |
Sales.SalesOrderDetail.UnitPriceDiscount |
schema/table/column |
MS_Description |
Discount amount. |
| Object |
Sales.SalesOrderDetail.LineTotal |
schema/table/column |
MS_Description |
Per product subtotal. Computed as UnitPrice * (1 - UnitPriceDiscount) * OrderQty. |
| Object |
Sales.SalesOrderDetail.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Sales.SalesOrderDetail.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Production.DF_Document_ModifiedDate.DF_Document_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Purchasing.FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID.FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing PurchaseOrderHeader.PurchaseOrderID. |
| Object |
Sales.PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode.PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesOrderDetail_UnitPriceDiscount.DF_SalesOrderDetail_UnitPriceDiscount |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0.0 |
| Object |
Production.CK_Document_Status.CK_Document_Status |
schema/table/check_constraint |
MS_Description |
Check constraint [Status] BETWEEN (1) AND (3) |
| Object |
Purchasing.FK_PurchaseOrderHeader_Employee_EmployeeID.FK_PurchaseOrderHeader_Employee_EmployeeID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Employee.EmployeeID. |
| Object |
Person.PK_CountryRegion_CountryRegionCode.PK_CountryRegion_CountryRegionCode |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesOrderDetail_rowguid.DF_SalesOrderDetail_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
Person.EmailAddress |
schema/table |
MS_Description |
Where to send a person email. |
| Object |
Person.EmailAddress.BusinessEntityID |
schema/table/column |
MS_Description |
Primary key. Person associated with this email address. Foreign key to Person.BusinessEntityID |
| Object |
Person.EmailAddress.EmailAddressID |
schema/table/column |
MS_Description |
Primary key. ID of this email address. |
| Object |
Person.EmailAddress.EmailAddress |
schema/table/column |
MS_Description |
E-mail address for the person. |
| Object |
Person.EmailAddress.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Person.EmailAddress.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Purchasing.FK_PurchaseOrderHeader_Vendor_VendorID.FK_PurchaseOrderHeader_Vendor_VendorID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Vendor.VendorID. |
| Object |
Sales.PK_CreditCard_CreditCardID.PK_CreditCard_CreditCardID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesOrderDetail_ModifiedDate.DF_SalesOrderDetail_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Person.DF_EmailAddress_rowguid.DF_EmailAddress_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
Purchasing.FK_PurchaseOrderHeader_ShipMethod_ShipMethodID.FK_PurchaseOrderHeader_ShipMethod_ShipMethodID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing ShipMethod.ShipMethodID. |
| Object |
Production.PK_Culture_CultureID.PK_Culture_CultureID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.CK_SalesOrderDetail_OrderQty.CK_SalesOrderDetail_OrderQty |
schema/table/check_constraint |
MS_Description |
Check constraint [OrderQty] > (0) |
| Object |
Person.DF_EmailAddress_ModifiedDate.DF_EmailAddress_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Sales.FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID.FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing SalesOrderHeader.PurchaseOrderID. |
| Object |
Sales.PK_Currency_CurrencyCode.PK_Currency_CurrencyCode |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.CK_SalesOrderDetail_UnitPrice.CK_SalesOrderDetail_UnitPrice |
schema/table/check_constraint |
MS_Description |
Check constraint [UnitPrice] >= (0.00) |
| Object |
HumanResources.Employee |
schema/table |
MS_Description |
Employee information such as salary, department, and title. |
| Object |
HumanResources.Employee.BusinessEntityID |
schema/table/column |
MS_Description |
Primary key for Employee records. Foreign key to BusinessEntity.BusinessEntityID. |
| Object |
HumanResources.Employee.NationalIDNumber |
schema/table/column |
MS_Description |
Unique national identification number such as a social security number. |
| Object |
HumanResources.Employee.LoginID |
schema/table/column |
MS_Description |
Network login. |
| Object |
HumanResources.Employee.OrganizationNode |
schema/table/column |
MS_Description |
Where the employee is located in corporate hierarchy. |
| Object |
HumanResources.Employee.OrganizationLevel |
schema/table/column |
MS_Description |
The depth of the employee in the corporate hierarchy. |
| Object |
HumanResources.Employee.JobTitle |
schema/table/column |
MS_Description |
Work title such as Buyer or Sales Representative. |
| Object |
HumanResources.Employee.BirthDate |
schema/table/column |
MS_Description |
Date of birth. |
| Object |
HumanResources.Employee.MaritalStatus |
schema/table/column |
MS_Description |
M = Married, S = Single |
| Object |
HumanResources.Employee.Gender |
schema/table/column |
MS_Description |
M = Male, F = Female |
| Object |
HumanResources.Employee.HireDate |
schema/table/column |
MS_Description |
Employee hired on this date. |
| Object |
HumanResources.Employee.SalariedFlag |
schema/table/column |
MS_Description |
Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining. |
| Object |
HumanResources.Employee.VacationHours |
schema/table/column |
MS_Description |
Number of available vacation hours. |
| Object |
HumanResources.Employee.SickLeaveHours |
schema/table/column |
MS_Description |
Number of available sick leave hours. |
| Object |
HumanResources.Employee.CurrentFlag |
schema/table/column |
MS_Description |
0 = Inactive, 1 = Active |
| Object |
HumanResources.Employee.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
HumanResources.Employee.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Sales.FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID.FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing SpecialOfferProduct.SpecialOfferIDProductID. |
| Object |
Sales.PK_CurrencyRate_CurrencyRateID.PK_CurrencyRate_CurrencyRateID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.CK_SalesOrderDetail_UnitPriceDiscount.CK_SalesOrderDetail_UnitPriceDiscount |
schema/table/check_constraint |
MS_Description |
Check constraint [UnitPriceDiscount] >= (0.00) |
| Object |
HumanResources.DF_Employee_SalariedFlag.DF_Employee_SalariedFlag |
schema/table/default_constraint |
MS_Description |
Default constraint value of 1 (TRUE) |
| Object |
Sales.FK_SalesOrderHeader_Address_BillToAddressID.FK_SalesOrderHeader_Address_BillToAddressID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Address.AddressID. |
| Object |
Sales.PK_Customer_CustomerID.PK_Customer_CustomerID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.SalesOrderHeader |
schema/table |
MS_Description |
General sales order information. |
| Object |
Sales.SalesOrderHeader.SalesOrderID |
schema/table/column |
MS_Description |
Primary key. |
| Object |
Sales.SalesOrderHeader.RevisionNumber |
schema/table/column |
MS_Description |
Incremental number to track changes to the sales order over time. |
| Object |
Sales.SalesOrderHeader.OrderDate |
schema/table/column |
MS_Description |
Dates the sales order was created. |
| Object |
Sales.SalesOrderHeader.DueDate |
schema/table/column |
MS_Description |
Date the order is due to the customer. |
| Object |
Sales.SalesOrderHeader.ShipDate |
schema/table/column |
MS_Description |
Date the order was shipped to the customer. |
| Object |
Sales.SalesOrderHeader.Status |
schema/table/column |
MS_Description |
Order current status. 1 = In process; 2 = Approved; 3 = Backordered; 4 = Rejected; 5 = Shipped; 6 = Cancelled |
| Object |
Sales.SalesOrderHeader.OnlineOrderFlag |
schema/table/column |
MS_Description |
0 = Order placed by sales person. 1 = Order placed online by customer. |
| Object |
Sales.SalesOrderHeader.SalesOrderNumber |
schema/table/column |
MS_Description |
Unique sales order identification number. |
| Object |
Sales.SalesOrderHeader.PurchaseOrderNumber |
schema/table/column |
MS_Description |
Customer purchase order number reference. |
| Object |
Sales.SalesOrderHeader.AccountNumber |
schema/table/column |
MS_Description |
Financial accounting number reference. |
| Object |
Sales.SalesOrderHeader.CustomerID |
schema/table/column |
MS_Description |
Customer identification number. Foreign key to Customer.BusinessEntityID. |
| Object |
Sales.SalesOrderHeader.SalesPersonID |
schema/table/column |
MS_Description |
Sales person who created the sales order. Foreign key to SalesPerson.BusinessEntityID. |
| Object |
Sales.SalesOrderHeader.TerritoryID |
schema/table/column |
MS_Description |
Territory in which the sale was made. Foreign key to SalesTerritory.SalesTerritoryID. |
| Object |
Sales.SalesOrderHeader.BillToAddressID |
schema/table/column |
MS_Description |
Customer billing address. Foreign key to Address.AddressID. |
| Object |
Sales.SalesOrderHeader.ShipToAddressID |
schema/table/column |
MS_Description |
Customer shipping address. Foreign key to Address.AddressID. |
| Object |
Sales.SalesOrderHeader.ShipMethodID |
schema/table/column |
MS_Description |
Shipping method. Foreign key to ShipMethod.ShipMethodID. |
| Object |
Sales.SalesOrderHeader.CreditCardID |
schema/table/column |
MS_Description |
Credit card identification number. Foreign key to CreditCard.CreditCardID. |
| Object |
Sales.SalesOrderHeader.CreditCardApprovalCode |
schema/table/column |
MS_Description |
Approval code provided by the credit card company. |
| Object |
Sales.SalesOrderHeader.CurrencyRateID |
schema/table/column |
MS_Description |
Currency exchange rate used. Foreign key to CurrencyRate.CurrencyRateID. |
| Object |
Sales.SalesOrderHeader.SubTotal |
schema/table/column |
MS_Description |
Sales subtotal. Computed as SUM(SalesOrderDetail.LineTotal)for the appropriate SalesOrderID. |
| Object |
Sales.SalesOrderHeader.TaxAmt |
schema/table/column |
MS_Description |
Tax amount. |
| Object |
Sales.SalesOrderHeader.Freight |
schema/table/column |
MS_Description |
Shipping cost. |
| Object |
Sales.SalesOrderHeader.TotalDue |
schema/table/column |
MS_Description |
Total due from customer. Computed as Subtotal + TaxAmt + Freight. |
| Object |
Sales.SalesOrderHeader.Comment |
schema/table/column |
MS_Description |
Sales representative comments. |
| Object |
Sales.SalesOrderHeader.rowguid |
schema/table/column |
MS_Description |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| Object |
Sales.SalesOrderHeader.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
HumanResources.DF_Employee_VacationHours.DF_Employee_VacationHours |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0 |
| Object |
Sales.FK_SalesOrderHeader_Address_ShipToAddressID.FK_SalesOrderHeader_Address_ShipToAddressID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Address.AddressID. |
| Object |
dbo.PK_DatabaseLog_DatabaseLogID.PK_DatabaseLog_DatabaseLogID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (nonclustered) constraint |
| Object |
Sales.DF_SalesOrderHeader_RevisionNumber.DF_SalesOrderHeader_RevisionNumber |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0 |
| Object |
HumanResources.DF_Employee_SickLeaveHours.DF_Employee_SickLeaveHours |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0 |
| Object |
Sales.FK_SalesOrderHeader_CreditCard_CreditCardID.FK_SalesOrderHeader_CreditCard_CreditCardID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing CreditCard.CreditCardID. |
| Object |
HumanResources.PK_Department_DepartmentID.PK_Department_DepartmentID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesOrderHeader_OrderDate.DF_SalesOrderHeader_OrderDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
HumanResources.DF_Employee_CurrentFlag.DF_Employee_CurrentFlag |
schema/table/default_constraint |
MS_Description |
Default constraint value of 1 |
| Object |
Sales.FK_SalesOrderHeader_CurrencyRate_CurrencyRateID.FK_SalesOrderHeader_CurrencyRate_CurrencyRateID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing CurrencyRate.CurrencyRateID. |
| Object |
Production.PK_Document_DocumentNode.PK_Document_DocumentNode |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesOrderHeader_Status.DF_SalesOrderHeader_Status |
schema/table/default_constraint |
MS_Description |
Default constraint value of 1 |
| Object |
HumanResources.DF_Employee_rowguid.DF_Employee_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
Sales.FK_SalesOrderHeader_Customer_CustomerID.FK_SalesOrderHeader_Customer_CustomerID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Customer.CustomerID. |
| Object |
Person.PK_EmailAddress_BusinessEntityID_EmailAddressID.PK_EmailAddress_BusinessEntityID_EmailAddressID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesOrderHeader_OnlineOrderFlag.DF_SalesOrderHeader_OnlineOrderFlag |
schema/table/default_constraint |
MS_Description |
Default constraint value of 1 (TRUE) |
| Object |
HumanResources.DF_Employee_ModifiedDate.DF_Employee_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Sales.FK_SalesOrderHeader_SalesPerson_SalesPersonID.FK_SalesOrderHeader_SalesPerson_SalesPersonID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing SalesPerson.SalesPersonID. |
| Object |
HumanResources.PK_Employee_BusinessEntityID.PK_Employee_BusinessEntityID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesOrderHeader_SubTotal.DF_SalesOrderHeader_SubTotal |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0.0 |
| Object |
HumanResources.CK_Employee_BirthDate.CK_Employee_BirthDate |
schema/table/check_constraint |
MS_Description |
Check constraint [BirthDate] >= '1930-01-01' AND [BirthDate] <= dateadd(year,(-18),GETDATE()) |
| Object |
Sales.FK_SalesOrderHeader_ShipMethod_ShipMethodID.FK_SalesOrderHeader_ShipMethod_ShipMethodID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing ShipMethod.ShipMethodID. |
| Object |
HumanResources.PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID.PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesOrderHeader_TaxAmt.DF_SalesOrderHeader_TaxAmt |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0.0 |
| Object |
HumanResources.CK_Employee_MaritalStatus.CK_Employee_MaritalStatus |
schema/table/check_constraint |
MS_Description |
Check constraint [MaritalStatus]='s' OR [MaritalStatus]='m' OR [MaritalStatus]='S' OR [MaritalStatus]='M' |
| Object |
Sales.FK_SalesOrderHeader_SalesTerritory_TerritoryID.FK_SalesOrderHeader_SalesTerritory_TerritoryID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing SalesTerritory.TerritoryID. |
| Object |
HumanResources.PK_EmployeePayHistory_BusinessEntityID_RateChangeDate.PK_EmployeePayHistory_BusinessEntityID_RateChangeDate |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesOrderHeader_Freight.DF_SalesOrderHeader_Freight |
schema/table/default_constraint |
MS_Description |
Default constraint value of 0.0 |
| Object |
HumanResources.CK_Employee_HireDate.CK_Employee_HireDate |
schema/table/check_constraint |
MS_Description |
Check constraint [HireDate] >= '1996-07-01' AND [HireDate] <= dateadd(day,(1),GETDATE()) |
| Object |
Sales.FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID.FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing SalesReason.SalesReasonID. |
| Object |
Production.PK_Illustration_IllustrationID.PK_Illustration_IllustrationID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesOrderHeader_rowguid.DF_SalesOrderHeader_rowguid |
schema/table/default_constraint |
MS_Description |
Default constraint value of NEWID() |
| Object |
HumanResources.CK_Employee_Gender.CK_Employee_Gender |
schema/table/check_constraint |
MS_Description |
Check constraint [Gender]='f' OR [Gender]='m' OR [Gender]='F' OR [Gender]='M' |
| Object |
Sales.FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID.FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing SalesOrderHeader.SalesOrderID. |
| Object |
HumanResources.PK_JobCandidate_JobCandidateID.PK_JobCandidate_JobCandidateID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.DF_SalesOrderHeader_ModifiedDate.DF_SalesOrderHeader_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
HumanResources.CK_Employee_VacationHours.CK_Employee_VacationHours |
schema/table/check_constraint |
MS_Description |
Check constraint [VacationHours] >= (-40) AND [VacationHours] <= (240) |
| Object |
Sales.FK_SalesPerson_Employee_BusinessEntityID.FK_SalesPerson_Employee_BusinessEntityID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing Employee.EmployeeID. |
| Object |
Production.PK_Location_LocationID.PK_Location_LocationID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.CK_SalesOrderHeader_Status.CK_SalesOrderHeader_Status |
schema/table/check_constraint |
MS_Description |
Check constraint [Status] BETWEEN (0) AND (8) |
| Object |
HumanResources.CK_Employee_SickLeaveHours.CK_Employee_SickLeaveHours |
schema/table/check_constraint |
MS_Description |
Check constraint [SickLeaveHours] >= (0) AND [SickLeaveHours] <= (120) |
| Object |
Sales.FK_SalesPerson_SalesTerritory_TerritoryID.FK_SalesPerson_SalesTerritory_TerritoryID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing SalesTerritory.TerritoryID. |
| Object |
Person.PK_Password_BusinessEntityID.PK_Password_BusinessEntityID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.CK_SalesOrderHeader_DueDate.CK_SalesOrderHeader_DueDate |
schema/table/check_constraint |
MS_Description |
Check constraint [DueDate] >= [OrderDate] |
| Object |
HumanResources.EmployeeDepartmentHistory |
schema/table |
MS_Description |
Employee department transfers. |
| Object |
HumanResources.EmployeeDepartmentHistory.BusinessEntityID |
schema/table/column |
MS_Description |
Employee identification number. Foreign key to Employee.BusinessEntityID. |
| Object |
HumanResources.EmployeeDepartmentHistory.DepartmentID |
schema/table/column |
MS_Description |
Department in which the employee worked including currently. Foreign key to Department.DepartmentID. |
| Object |
HumanResources.EmployeeDepartmentHistory.ShiftID |
schema/table/column |
MS_Description |
Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID. |
| Object |
HumanResources.EmployeeDepartmentHistory.StartDate |
schema/table/column |
MS_Description |
Date the employee started work in the department. |
| Object |
HumanResources.EmployeeDepartmentHistory.EndDate |
schema/table/column |
MS_Description |
Date the employee left the department. NULL = Current department. |
| Object |
HumanResources.EmployeeDepartmentHistory.ModifiedDate |
schema/table/column |
MS_Description |
Date and time the record was last updated. |
| Object |
Sales.FK_SalesPersonQuotaHistory_SalesPerson_BusinessEntityID.FK_SalesPersonQuotaHistory_SalesPerson_BusinessEntityID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing SalesPerson.SalesPersonID. |
| Object |
Person.PK_Person_BusinessEntityID.PK_Person_BusinessEntityID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.CK_SalesOrderHeader_ShipDate.CK_SalesOrderHeader_ShipDate |
schema/table/check_constraint |
MS_Description |
Check constraint [ShipDate] >= [OrderDate] OR [ShipDate] IS NULL |
| Object |
HumanResources.DF_EmployeeDepartmentHistory_ModifiedDate.DF_EmployeeDepartmentHistory_ModifiedDate |
schema/table/default_constraint |
MS_Description |
Default constraint value of GETDATE() |
| Object |
Sales.FK_SalesTaxRate_StateProvince_StateProvinceID.FK_SalesTaxRate_StateProvince_StateProvinceID |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing StateProvince.StateProvinceID. |
| Object |
Sales.PK_PersonCreditCard_BusinessEntityID_CreditCardID.PK_PersonCreditCard_BusinessEntityID_CreditCardID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.CK_SalesOrderHeader_SubTotal.CK_SalesOrderHeader_SubTotal |
schema/table/check_constraint |
MS_Description |
Check constraint [SubTotal] >= (0.00) |
| Object |
HumanResources.CK_EmployeeDepartmentHistory_EndDate.CK_EmployeeDepartmentHistory_EndDate |
schema/table/check_constraint |
MS_Description |
Check constraint [EndDate] >= [StartDate] OR [EndDate] IS NUL |
| Object |
Sales.FK_SalesTerritory_CountryRegion_CountryRegionCode.FK_SalesTerritory_CountryRegion_CountryRegionCode |
schema/table/foreign_key_constraint |
MS_Description |
Foreign key constraint referencing CountryRegion.CountryRegionCode. |
| Object |
Person.PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID.PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID |
schema/table/primary_key_constraint |
MS_Description |
Primary key (clustered) constraint |
| Object |
Sales.CK_SalesOrderHeader_TaxAmt.CK_SalesOrderHeader_TaxAmt |
schema/table/check_constraint |
MS_Description |
Check constraint [TaxAmt] >= (0.00) |
| Object |
HumanResources.EmployeePayHistory.PK_EmployeePayHistory_BusinessEntityID_RateChangeDate |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Sales.SalesOrderHeaderSalesReason.PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Sales.SalesPerson.PK_SalesPerson_BusinessEntityID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Sales.SalesPerson.AK_SalesPerson_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Production.Illustration.PK_Illustration_IllustrationID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
HumanResources.JobCandidate.PK_JobCandidate_JobCandidateID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
HumanResources.JobCandidate.IX_JobCandidate_BusinessEntityID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Production.Location.PK_Location_LocationID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Production.Location.AK_Location_Name |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Person.Password.PK_Password_BusinessEntityID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Sales.SalesPersonQuotaHistory.PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Sales.SalesPersonQuotaHistory.AK_SalesPersonQuotaHistory_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Person.Person.PK_Person_BusinessEntityID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Person.Person.AK_Person_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Person.Person.PXML_Person_AddContact |
schema/user_table/index |
MS_Description |
Primary XML index. |
| Object |
Person.Person.PXML_Person_Demographics |
schema/user_table/index |
MS_Description |
Primary XML index. |
| Object |
Person.Person.XMLPATH_Person_Demographics |
schema/user_table/index |
MS_Description |
Secondary XML index for path. |
| Object |
Person.Person.XMLPROPERTY_Person_Demographics |
schema/user_table/index |
MS_Description |
Secondary XML index for property. |
| Object |
Person.Person.XMLVALUE_Person_Demographics |
schema/user_table/index |
MS_Description |
Secondary XML index for value. |
| Object |
Sales.SalesReason.PK_SalesReason_SalesReasonID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Sales.SalesTaxRate.PK_SalesTaxRate_SalesTaxRateID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Sales.SalesTaxRate.AK_SalesTaxRate_StateProvinceID_TaxType |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Sales.SalesTaxRate.AK_SalesTaxRate_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Sales.PersonCreditCard.PK_PersonCreditCard_BusinessEntityID_CreditCardID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Person.PersonPhone.PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Person.PersonPhone.IX_PersonPhone_PhoneNumber |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Sales.SalesTerritory.PK_SalesTerritory_TerritoryID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Sales.SalesTerritory.AK_SalesTerritory_Name |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Sales.SalesTerritory.AK_SalesTerritory_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Person.PhoneNumberType.PK_PhoneNumberType_PhoneNumberTypeID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Production.Product.PK_Product_ProductID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Production.Product.AK_Product_ProductNumber |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Production.Product.AK_Product_Name |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Production.Product.AK_Product_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Production.vProductAndDescription.IX_vProductAndDescription |
schema/view/index |
MS_Description |
Clustered index on the view vProductAndDescription. |
| Object |
Sales.SalesTerritoryHistory.PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Sales.SalesTerritoryHistory.AK_SalesTerritoryHistory_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Person.vStateProvinceCountryRegion.IX_vStateProvinceCountryRegion |
schema/view/index |
MS_Description |
Clustered index on the view vStateProvinceCountryRegion. |
| Object |
Production.ScrapReason.PK_ScrapReason_ScrapReasonID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Production.ScrapReason.AK_ScrapReason_Name |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
HumanResources.Shift.PK_Shift_ShiftID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
HumanResources.Shift.AK_Shift_Name |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
HumanResources.Shift.AK_Shift_StartTime_EndTime |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Production.ProductCategory.PK_ProductCategory_ProductCategoryID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Production.ProductCategory.AK_ProductCategory_Name |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Production.ProductCategory.AK_ProductCategory_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Purchasing.ShipMethod.PK_ShipMethod_ShipMethodID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Purchasing.ShipMethod.AK_ShipMethod_Name |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Purchasing.ShipMethod.AK_ShipMethod_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Production.ProductCostHistory.PK_ProductCostHistory_ProductID_StartDate |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Production.ProductDescription.PK_ProductDescription_ProductDescriptionID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Production.ProductDescription.AK_ProductDescription_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Sales.ShoppingCartItem.PK_ShoppingCartItem_ShoppingCartItemID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Sales.ShoppingCartItem.IX_ShoppingCartItem_ShoppingCartID_ProductID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Production.ProductDocument.PK_ProductDocument_ProductID_DocumentNode |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
dbo.DatabaseLog.PK_DatabaseLog_DatabaseLogID |
schema/user_table/index |
MS_Description |
Nonclustered index created by a primary key constraint. |
| Object |
Production.ProductInventory.PK_ProductInventory_ProductID_LocationID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Sales.SpecialOffer.PK_SpecialOffer_SpecialOfferID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Sales.SpecialOffer.AK_SpecialOffer_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
dbo.ErrorLog.PK_ErrorLog_ErrorLogID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Production.ProductListPriceHistory.PK_ProductListPriceHistory_ProductID_StartDate |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Person.Address.PK_Address_AddressID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Person.Address.AK_Address_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Person.Address.IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Person.Address.IX_Address_StateProvinceID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Sales.SpecialOfferProduct.PK_SpecialOfferProduct_SpecialOfferID_ProductID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Sales.SpecialOfferProduct.AK_SpecialOfferProduct_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Sales.SpecialOfferProduct.IX_SpecialOfferProduct_ProductID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Production.ProductModel.PK_ProductModel_ProductModelID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Production.ProductModel.AK_ProductModel_Name |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Production.ProductModel.AK_ProductModel_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Production.ProductModel.PXML_ProductModel_CatalogDescription |
schema/user_table/index |
MS_Description |
Primary XML index. |
| Object |
Production.ProductModel.PXML_ProductModel_Instructions |
schema/user_table/index |
MS_Description |
Primary XML index. |
| Object |
Person.AddressType.PK_AddressType_AddressTypeID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Person.AddressType.AK_AddressType_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Person.AddressType.AK_AddressType_Name |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Person.StateProvince.PK_StateProvince_StateProvinceID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Person.StateProvince.AK_StateProvince_Name |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Person.StateProvince.AK_StateProvince_StateProvinceCode_CountryRegionCode |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Person.StateProvince.AK_StateProvince_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Production.ProductModelIllustration.PK_ProductModelIllustration_ProductModelID_IllustrationID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
dbo.AWBuildVersion.PK_AWBuildVersion_SystemInformationID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Production.ProductModelProductDescriptionCulture.PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Production.BillOfMaterials.AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate |
schema/user_table/index |
MS_Description |
Clustered index. |
| Object |
Production.BillOfMaterials.PK_BillOfMaterials_BillOfMaterialsID |
schema/user_table/index |
MS_Description |
Nonclustered index created by a primary key constraint. |
| Object |
Production.BillOfMaterials.IX_BillOfMaterials_UnitMeasureCode |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Sales.Store.PK_Store_BusinessEntityID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Sales.Store.AK_Store_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Sales.Store.IX_Store_SalesPersonID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Sales.Store.PXML_Store_Demographics |
schema/user_table/index |
MS_Description |
Primary XML index. |
| Object |
Production.ProductPhoto.PK_ProductPhoto_ProductPhotoID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Production.ProductProductPhoto.PK_ProductProductPhoto_ProductID_ProductPhotoID |
schema/user_table/index |
MS_Description |
Nonclustered index created by a primary key constraint. |
| Object |
Production.TransactionHistory.PK_TransactionHistory_TransactionID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Production.TransactionHistory.IX_TransactionHistory_ProductID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Production.TransactionHistory.IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Production.ProductReview.PK_ProductReview_ProductReviewID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Production.ProductReview.IX_ProductReview_ProductID_Name |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Person.BusinessEntity.PK_BusinessEntity_BusinessEntityID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Person.BusinessEntity.AK_BusinessEntity_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Production.TransactionHistoryArchive.PK_TransactionHistoryArchive_TransactionID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Production.TransactionHistoryArchive.IX_TransactionHistoryArchive_ProductID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Production.TransactionHistoryArchive.IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Production.ProductSubcategory.PK_ProductSubcategory_ProductSubcategoryID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Production.ProductSubcategory.AK_ProductSubcategory_Name |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Production.ProductSubcategory.AK_ProductSubcategory_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Person.BusinessEntityAddress.PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Person.BusinessEntityAddress.AK_BusinessEntityAddress_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Person.BusinessEntityAddress.IX_BusinessEntityAddress_AddressID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Person.BusinessEntityAddress.IX_BusinessEntityAddress_AddressTypeID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Purchasing.ProductVendor.PK_ProductVendor_ProductID_BusinessEntityID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Purchasing.ProductVendor.IX_ProductVendor_UnitMeasureCode |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Purchasing.ProductVendor.IX_ProductVendor_BusinessEntityID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Person.BusinessEntityContact.PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Person.BusinessEntityContact.AK_BusinessEntityContact_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Person.BusinessEntityContact.IX_BusinessEntityContact_PersonID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Person.BusinessEntityContact.IX_BusinessEntityContact_ContactTypeID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Production.UnitMeasure.PK_UnitMeasure_UnitMeasureCode |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Production.UnitMeasure.AK_UnitMeasure_Name |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Purchasing.Vendor.PK_Vendor_BusinessEntityID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Purchasing.Vendor.AK_Vendor_AccountNumber |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Person.ContactType.PK_ContactType_ContactTypeID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Person.ContactType.AK_ContactType_Name |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Sales.CountryRegionCurrency.PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Sales.CountryRegionCurrency.IX_CountryRegionCurrency_CurrencyCode |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Person.CountryRegion.PK_CountryRegion_CountryRegionCode |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Person.CountryRegion.AK_CountryRegion_Name |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Production.WorkOrder.PK_WorkOrder_WorkOrderID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Production.WorkOrder.IX_WorkOrder_ScrapReasonID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Production.WorkOrder.IX_WorkOrder_ProductID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Purchasing.PurchaseOrderDetail.PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Purchasing.PurchaseOrderDetail.IX_PurchaseOrderDetail_ProductID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Sales.CreditCard.PK_CreditCard_CreditCardID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Sales.CreditCard.AK_CreditCard_CardNumber |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Production.Culture.PK_Culture_CultureID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Production.Culture.AK_Culture_Name |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Production.WorkOrderRouting.PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Production.WorkOrderRouting.IX_WorkOrderRouting_ProductID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Sales.Currency.PK_Currency_CurrencyCode |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Sales.Currency.AK_Currency_Name |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Purchasing.PurchaseOrderHeader.PK_PurchaseOrderHeader_PurchaseOrderID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Purchasing.PurchaseOrderHeader.IX_PurchaseOrderHeader_VendorID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Purchasing.PurchaseOrderHeader.IX_PurchaseOrderHeader_EmployeeID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Sales.CurrencyRate.PK_CurrencyRate_CurrencyRateID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Sales.CurrencyRate.AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Sales.Customer.PK_Customer_CustomerID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Sales.Customer.AK_Customer_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Sales.Customer.AK_Customer_AccountNumber |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Sales.Customer.IX_Customer_TerritoryID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
HumanResources.Department.PK_Department_DepartmentID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
HumanResources.Department.AK_Department_Name |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Production.Document.PK_Document_DocumentNode |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Production.Document.AK_Document_DocumentLevel_DocumentNode |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Production.Document.AK_Document_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support FileStream. |
| Object |
Production.Document.IX_Document_FileName_Revision |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Sales.SalesOrderDetail.PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Sales.SalesOrderDetail.AK_SalesOrderDetail_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Sales.SalesOrderDetail.IX_SalesOrderDetail_ProductID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Person.EmailAddress.PK_EmailAddress_BusinessEntityID_EmailAddressID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Person.EmailAddress.IX_EmailAddress_EmailAddress |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
HumanResources.Employee.PK_Employee_BusinessEntityID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
HumanResources.Employee.IX_Employee_OrganizationNode |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
HumanResources.Employee.IX_Employee_OrganizationLevel_OrganizationNode |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
HumanResources.Employee.AK_Employee_LoginID |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
HumanResources.Employee.AK_Employee_NationalIDNumber |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
HumanResources.Employee.AK_Employee_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Sales.SalesOrderHeader.PK_SalesOrderHeader_SalesOrderID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
Sales.SalesOrderHeader.AK_SalesOrderHeader_rowguid |
schema/user_table/index |
MS_Description |
Unique nonclustered index. Used to support replication samples. |
| Object |
Sales.SalesOrderHeader.AK_SalesOrderHeader_SalesOrderNumber |
schema/user_table/index |
MS_Description |
Unique nonclustered index. |
| Object |
Sales.SalesOrderHeader.IX_SalesOrderHeader_CustomerID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
Sales.SalesOrderHeader.IX_SalesOrderHeader_SalesPersonID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
HumanResources.EmployeeDepartmentHistory.PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID |
schema/user_table/index |
MS_Description |
Clustered index created by a primary key constraint. |
| Object |
HumanResources.EmployeeDepartmentHistory.IX_EmployeeDepartmentHistory_DepartmentID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
HumanResources.EmployeeDepartmentHistory.IX_EmployeeDepartmentHistory_ShiftID |
schema/user_table/index |
MS_Description |
Nonclustered index. |
| Object |
dbo.ufnGetContactInformation.@PersonID |
schema/sql_table_valued_function/parameter |
MS_Description |
Input parameter for the table value function ufnGetContactInformation. Enter a valid PersonID from the Person.Contact table. |
| Object |
dbo.ufnGetProductDealerPrice.@OrderDate |
schema/sql_scalar_function/parameter |
MS_Description |
Input parameter for the scalar function ufnGetProductDealerPrice. Enter a valid order date. |
| Object |
dbo.ufnGetProductDealerPrice.@ProductID |
schema/sql_scalar_function/parameter |
MS_Description |
Input parameter for the scalar function ufnGetProductDealerPrice. Enter a valid ProductID from the Production.Product table. |
| Object |
dbo.ufnGetProductListPrice.@OrderDate |
schema/sql_scalar_function/parameter |
MS_Description |
Input parameter for the scalar function ufnGetProductListPrice. Enter a valid order date. |
| Object |
dbo.ufnGetProductListPrice.@ProductID |
schema/sql_scalar_function/parameter |
MS_Description |
Input parameter for the scalar function ufnGetProductListPrice. Enter a valid ProductID from the Production.Product table. |
| Object |
dbo.ufnGetProductStandardCost.@OrderDate |
schema/sql_scalar_function/parameter |
MS_Description |
Input parameter for the scalar function ufnGetProductStandardCost. Enter a valid order date. |
| Object |
dbo.ufnGetProductStandardCost.@ProductID |
schema/sql_scalar_function/parameter |
MS_Description |
Input parameter for the scalar function ufnGetProductStandardCost. Enter a valid ProductID from the Production.Product table. |
| Object |
dbo.ufnGetStock.@ProductID |
schema/sql_scalar_function/parameter |
MS_Description |
Input parameter for the scalar function ufnGetStock. Enter a valid ProductID from the Production.ProductInventory table. |
| Object |
dbo.ufnGetDocumentStatusText.@Status |
schema/sql_scalar_function/parameter |
MS_Description |
Input parameter for the scalar function ufnGetDocumentStatusText. Enter a valid integer. |
| Object |
dbo.ufnGetPurchaseOrderStatusText.@Status |
schema/sql_scalar_function/parameter |
MS_Description |
Input parameter for the scalar function ufnGetPurchaseOrdertStatusText. Enter a valid integer. |
| Object |
dbo.ufnGetSalesOrderStatusText.@Status |
schema/sql_scalar_function/parameter |
MS_Description |
Input parameter for the scalar function ufnGetSalesOrderStatusText. Enter a valid integer. |
| Object |
dbo.uspGetBillOfMaterials.@CheckDate |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspGetBillOfMaterials used to eliminate components not used after that date. Enter a valid date. |
| Object |
dbo.uspGetBillOfMaterials.@StartProductID |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspGetBillOfMaterials. Enter a valid ProductID from the Production.Product table. |
| Object |
dbo.uspGetEmployeeManagers.@BusinessEntityID |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspGetEmployeeManagers. Enter a valid BusinessEntityID from the HumanResources.Employee table. |
| Object |
dbo.uspGetManagerEmployees.@BusinessEntityID |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspGetManagerEmployees. Enter a valid BusinessEntityID of the manager from the HumanResources.Employee table. |
| Object |
dbo.uspGetWhereUsedProductID.@CheckDate |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspGetWhereUsedProductID used to eliminate components not used after that date. Enter a valid date. |
| Object |
dbo.uspGetWhereUsedProductID.@StartProductID |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspGetWhereUsedProductID. Enter a valid ProductID from the Production.Product table. |
| Object |
HumanResources.uspUpdateEmployeeHireInfo.@BusinessEntityID |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a valid BusinessEntityID from the Employee table. |
| Object |
HumanResources.uspUpdateEmployeeHireInfo.@CurrentFlag |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the current flag for the employee. |
| Object |
HumanResources.uspUpdateEmployeeHireInfo.@HireDate |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a hire date for the employee. |
| Object |
HumanResources.uspUpdateEmployeeHireInfo.@JobTitle |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a title for the employee. |
| Object |
HumanResources.uspUpdateEmployeeHireInfo.@PayFrequency |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the pay frequency for the employee. |
| Object |
HumanResources.uspUpdateEmployeeHireInfo.@Rate |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the new rate for the employee. |
| Object |
HumanResources.uspUpdateEmployeeHireInfo.@RateChangeDate |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the date the rate changed for the employee. |
| Object |
HumanResources.uspUpdateEmployeeLogin.@BusinessEntityID |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspUpdateEmployeeLogin. Enter a valid EmployeeID from the Employee table. |
| Object |
HumanResources.uspUpdateEmployeeLogin.@CurrentFlag |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the current flag for the employee. |
| Object |
HumanResources.uspUpdateEmployeeLogin.@HireDate |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a hire date for the employee. |
| Object |
HumanResources.uspUpdateEmployeeLogin.@JobTitle |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a title for the employee. |
| Object |
HumanResources.uspUpdateEmployeeLogin.@LoginID |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a valid login for the employee. |
| Object |
HumanResources.uspUpdateEmployeeLogin.@OrganizationNode |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a valid ManagerID for the employee. |
| Object |
HumanResources.uspUpdateEmployeePersonalInfo.@BirthDate |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a birth date for the employee. |
| Object |
HumanResources.uspUpdateEmployeePersonalInfo.@BusinessEntityID |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspUpdateEmployeePersonalInfo. Enter a valid BusinessEntityID from the HumanResources.Employee table. |
| Object |
HumanResources.uspUpdateEmployeePersonalInfo.@Gender |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a gender for the employee. |
| Object |
HumanResources.uspUpdateEmployeePersonalInfo.@MaritalStatus |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a marital status for the employee. |
| Object |
HumanResources.uspUpdateEmployeePersonalInfo.@NationalIDNumber |
schema/sql_stored_procedure/parameter |
MS_Description |
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a national ID for the employee. |
| Object |
dbo.uspLogError.@ErrorLogID |
schema/sql_stored_procedure/parameter |
MS_Description |
Output parameter for the stored procedure uspLogError. Contains the ErrorLogID value corresponding to the row inserted by uspLogError in the ErrorLog table. |
| Object |
dbo.ufnLeadingZeros.@Value |
schema/sql_scalar_function/parameter |
MS_Description |
Input parameter for the scalar function ufnLeadingZeros. Enter a valid integer. |
| Object |
HumanResources |
schema |
MS_Description |
Contains objects related to employees and departments. |
| Object |
Person |
schema |
MS_Description |
Contains objects related to names and addresses of customers, vendors, and employees |
| Object |
Production |
schema |
MS_Description |
Contains objects related to products, inventory, and manufacturing. |
| Object |
Purchasing |
schema |
MS_Description |
Contains objects related to vendors and purchase orders. |
| Object |
Sales |
schema |
MS_Description |
Contains objects related to customers, sales orders, and sales territories. |
| Database |
CommonDBServer1 |
DataBase |
MS_Description |
AdventureWorks 2016 Sample OLTP Database |
| Object |
Person.AdditionalContactInfoSchemaCollection |
schema/xml_Schema_collection |
MS_Description |
Collection of XML schemas for the AdditionalContactInfo column in the Person.Contact table. |
| Object |
Person.IndividualSurveySchemaCollection |
schema/xml_Schema_collection |
MS_Description |
Collection of XML schemas for the Demographics column in the Person.Person table. |
| Object |
HumanResources.HRResumeSchemaCollection |
schema/xml_Schema_collection |
MS_Description |
Collection of XML schemas for the Resume column in the HumanResources.JobCandidate table. |
| Object |
Production.ProductDescriptionSchemaCollection |
schema/xml_Schema_collection |
MS_Description |
Collection of XML schemas for the CatalogDescription column in the Production.ProductModel table. |
| Object |
Production.ManuInstructionsSchemaCollection |
schema/xml_Schema_collection |
MS_Description |
Collection of XML schemas for the Instructions column in the Production.ProductModel table. |
| Object |
Sales.StoreSurveySchemaCollection |
schema/xml_Schema_collection |
MS_Description |
Collection of XML schemas for the Demographics column in the Sales.Store table. |
| Object |
PRIMARY |
dataspace |
MS_Description |
Primary filegroup for the AdventureWorks 2016 sample database. |