AdvantureWroks2019

Tables (71)

AWBuildVersion

  • SystemInformationID — tinyint — Primary key — NOT NULL — Primary key for AWBuildVersion records.
  • Database — Version — NOT NULL
  • VersionDate — datetime — NOT NULL — Date and time the record was last updated.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

Address

  • AddressID — int — Primary key — NOT NULL — Primary key for Address records.
  • AddressLine1 — nvarchar(60) — NOT NULL — First street address line.
  • AddressLine2 — nvarchar(60) — Second street address line.
  • City — nvarchar(30) — NOT NULL — Name of the city.
  • StateProvinceID — int — Foreign key → StateProvince.StateProvinceID — NOT NULL — Unique identification number for the state or province. Foreign key to StateProvince table.
  • PostalCode — nvarchar(15) — NOT NULL — Postal code for the street address.
  • SpatialLocation — geography — Latitude and longitude of this address.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

AddressType

  • AddressTypeID — int — Primary key — NOT NULL — Primary key for AddressType records.
  • Name — dbo.Name — NOT NULL — Address type description. For example, Billing, Home, or Shipping.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

BillOfMaterials

  • BillOfMaterialsID — int — Primary key — NOT NULL — Primary key for BillOfMaterials records.
  • ProductAssemblyID — int — Foreign key → Product.ProductID — Parent product identification number. Foreign key to Product.ProductID.
  • ComponentID — int — Foreign key → Product.ProductID — NOT NULL — Component identification number. Foreign key to Product.ProductID.
  • StartDate — datetime — NOT NULL — Date the component started being used in the assembly item.
  • EndDate — datetime — Date the component stopped being used in the assembly item.
  • UnitMeasureCode — nchar(3) — Foreign key — NOT NULL — Standard code identifying the unit of measure for the quantity.
  • BOMLevel — smallint — NOT NULL — Indicates the depth the component is from its parent (AssemblyID).
  • PerAssemblyQty — decimal(8, 2) — NOT NULL — Quantity of the component needed to create the assembly.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

BusinessEntity

  • BusinessEntityID — int — Primary key — NOT NULL — Primary key for all customers, vendors, and employees.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

BusinessEntityAddress

  • AddressID — int — Foreign key → Address.AddressID — NOT NULL — Primary key. Foreign key to Address.AddressID.
  • AddressTypeID — int — Foreign key → AddressType.AddressTypeID — NOT NULL — Primary key. Foreign key to AddressType.AddressTypeID.
  • BusinessEntityID — int — Foreign key → BusinessEntity.BusinessEntityID — NOT NULL — Primary key. Foreign key to BusinessEntity.BusinessEntityID.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

BusinessEntityContact

  • BusinessEntityID — int — Foreign key → BusinessEntity.BusinessEntityID — NOT NULL — Primary key. Foreign key to BusinessEntity.BusinessEntityID.
  • ContactTypeID — int — Foreign key → ContactType.ContactTypeID — NOT NULL — Primary key. Foreign key to ContactType.ContactTypeID.
  • PersonID — int — Foreign key → Person.BusinessEntityID — NOT NULL — Primary key. Foreign key to Person.BusinessEntityID.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

ContactType

  • ContactTypeID — int — Primary key — NOT NULL — Primary key for ContactType records.
  • Name — dbo.Name — NOT NULL — Contact type description.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

CountryRegion

  • CountryRegionCode — nvarchar(3) — Primary key — NOT NULL — ISO standard code for countries and regions.
  • Name — dbo.Name — NOT NULL — Country or region name.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

CountryRegionCurrency

  • CountryRegionCode — nvarchar(3) — Foreign key — NOT NULL — ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.
  • CurrencyCode — nchar(3) — Foreign key → Currency.CurrencyCode — NOT NULL — ISO standard currency code. Foreign key to Currency.CurrencyCode.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

CreditCard

  • CreditCardID — int — Primary key — NOT NULL — Primary key for CreditCard records.
  • CardType — nvarchar(50) — NOT NULL — Credit card name.
  • CardNumber — nvarchar(25) — NOT NULL — Credit card number.
  • ExpMonth — tinyint — NOT NULL — Credit card expiration month.
  • ExpYear — smallint — NOT NULL — Credit card expiration year.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

Culture

  • CultureID — nchar(6) — Primary key — NOT NULL — Primary key for Culture records.
  • Name — dbo.Name — NOT NULL — Culture description.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

Currency

  • CurrencyCode — nchar(3) — Primary key — NOT NULL — The ISO code for the Currency.
  • Name — dbo.Name — NOT NULL — Currency name.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

CurrencyRate

  • CurrencyRateID — int — Primary key — NOT NULL — Primary key for CurrencyRate records.
  • CurrencyRateDate — datetime — NOT NULL — Date and time the exchange rate was obtained.
  • FromCurrencyCode — nchar(3) — Foreign key → Currency.CurrencyCode — NOT NULL — Exchange rate was converted from this currency code.
  • ToCurrencyCode — nchar(3) — Foreign key → Currency.CurrencyCode — NOT NULL — Exchange rate was converted to this currency code.
  • AverageRate — money — NOT NULL — Average exchange rate for the day.
  • EndOfDayRate — money — NOT NULL — Final exchange rate for the day.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

Customer

  • CustomerID — int — Primary key — NOT NULL — Primary key.
  • PersonID — int — Foreign key → Person.BusinessEntityID — Foreign key to Person.BusinessEntityID
  • StoreID — int — Foreign key → Store.BusinessEntityID — Foreign key to Store.BusinessEntityID
  • TerritoryID — int — Foreign key → SalesTerritory.TerritoryID — ID of the territory in which the customer is located. Foreign key to SalesTerritory.SalesTerritoryID.
  • AccountNumber — AS — Unique number identifying the customer assigned by the accounting system.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

DatabaseLog

  • DatabaseLogID — int — Primary key — NOT NULL — Primary key for DatabaseLog records.
  • PostTime — datetime — NOT NULL — The date and time the DDL change occurred.
  • DatabaseUser — sysname — NOT NULL — The user who implemented the DDL change.
  • Event — sysname — NOT NULL — The type of DDL statement that was executed.
  • Schema — sysname — The schema to which the changed object belongs.
  • Object — sysname — The object that was changed by the DDL statment.
  • TSQL — nvarchar(max) — NOT NULL — The exact Transact-SQL statement that was executed.
  • XmlEvent — xml — NOT NULL — The raw XML data generated by database trigger.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

Department

  • DepartmentID — smallint — Primary key — NOT NULL — Primary key for Department records.
  • Name — dbo.Name — NOT NULL — Name of the department.
  • GroupName — dbo.Name — NOT NULL — Name of the group to which the department belongs.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

Document

  • DocumentNode — hierarchyid — Primary key — NOT NULL — Primary key for Document records.
  • DocumentLevel — AS — Depth in the document hierarchy.
  • Title — nvarchar(50) — NOT NULL — Title of the document.
  • Owner — int — Foreign key → Employee.BusinessEntityID — NOT NULL — Employee who controls the document. Foreign key to Employee.BusinessEntityID
  • FolderFlag — bit — NOT NULL — 0 = This is a folder, 1 = This is a document.
  • FileName — nvarchar(400) — NOT NULL — File name of the document
  • FileExtension — nvarchar(8) — NOT NULL — File extension indicating the document type. For example, .doc or .txt.
  • Revision — nchar(5) — NOT NULL — Revision number of the document.
  • ChangeNumber — int — NOT NULL — Engineering change approval number.
  • Status — tinyint — NOT NULL — 1 = Pending approval, 2 = Approved, 3 = Obsolete
  • DocumentSummary — nvarchar(max) — Document abstract.
  • Document — varbinary(max) — Complete document.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Required for FileStream.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

EmailAddress

  • EmailAddressID — int — Primary key — NOT NULL — Primary key. ID of this email address.
  • BusinessEntityID — int — Foreign key → Person.BusinessEntityID — NOT NULL — Primary key. Person associated with this email address. Foreign key to Person.BusinessEntityID
  • EmailAddress — nvarchar(50) — E-mail address for the person.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

Employee

  • BusinessEntityID — int — Foreign key → Person.BusinessEntityID — NOT NULL — Primary key for Employee records. Foreign key to BusinessEntity.BusinessEntityID.
  • NationalIDNumber — nvarchar(15) — NOT NULL — Unique national identification number such as a social security number.
  • LoginID — nvarchar(256) — NOT NULL — Network login.
  • OrganizationNode — hierarchyid — Where the employee is located in corporate hierarchy.
  • OrganizationLevel — AS — The depth of the employee in the corporate hierarchy.
  • JobTitle — nvarchar(50) — NOT NULL — Work title such as Buyer or Sales Representative.
  • BirthDate — date — NOT NULL — Date of birth.
  • MaritalStatus — nchar(1) — NOT NULL — M = Married, S = Single
  • Gender — nchar(1) — NOT NULL — M = Male, F = Female
  • HireDate — date — NOT NULL — Employee hired on this date.
  • SalariedFlag — dbo.Flag — NOT NULL — Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining.
  • VacationHours — smallint — NOT NULL — Number of available vacation hours.
  • SickLeaveHours — smallint — NOT NULL — Number of available sick leave hours.
  • CurrentFlag — dbo.Flag — NOT NULL — 0 = Inactive, 1 = Active
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

EmployeeDepartmentHistory

  • StartDate — date — Primary key — NOT NULL — Date the employee started work in the department.
  • DepartmentID — smallint — Foreign key → Department.DepartmentID — NOT NULL — Department in which the employee worked including currently. Foreign key to Department.DepartmentID.
  • BusinessEntityID — int — Foreign key → Employee.BusinessEntityID — NOT NULL — Employee identification number. Foreign key to Employee.BusinessEntityID.
  • ShiftID — tinyint — Foreign key → Shift.ShiftID — NOT NULL — Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID.
  • EndDate — date — Date the employee left the department. NULL = Current department.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

EmployeePayHistory

  • RateChangeDate — datetime — Primary key — NOT NULL — Date the change in pay is effective
  • BusinessEntityID — int — Foreign key → Employee.BusinessEntityID — NOT NULL — Employee identification number. Foreign key to Employee.BusinessEntityID.
  • Rate — money — NOT NULL — Salary hourly rate.
  • PayFrequency — tinyint — NOT NULL — 1 = Salary received monthly, 2 = Salary received biweekly
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

ErrorLog

  • ErrorLogID — int — Primary key — NOT NULL — Primary key for ErrorLog records.
  • ErrorTime — datetime — NOT NULL — The date and time at which the error occurred.
  • UserName — sysname — NOT NULL — The user who executed the batch in which the error occurred.
  • ErrorNumber — int — NOT NULL — The error number of the error that occurred.
  • ErrorSeverity — int — The severity of the error that occurred.
  • ErrorState — int — The state number of the error that occurred.
  • ErrorProcedure — nvarchar(126) — The name of the stored procedure or trigger where the error occurred.
  • ErrorLine — int — The line number at which the error occurred.
  • ErrorMessage — nvarchar(4000) — NOT NULL — The message text of the error that occurred.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

Illustration

  • IllustrationID — int — Primary key — NOT NULL — Primary key for Illustration records.
  • Diagram — xml — Illustrations used in manufacturing instructions. Stored as XML.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

JobCandidate

  • JobCandidateID — int — Primary key — NOT NULL — Primary key for JobCandidate records.
  • BusinessEntityID — int — Foreign key → Employee.BusinessEntityID — Employee identification number if applicant was hired. Foreign key to Employee.BusinessEntityID.
  • Resume — xml(CONTENT HumanResources.HRResumeSchemaCollection) — Résumé in XML format.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

Location

  • LocationID — smallint — Primary key — NOT NULL — Primary key for Location records.
  • Name — dbo.Name — NOT NULL — Location description.
  • CostRate — smallmoney — NOT NULL — Standard hourly cost of the manufacturing location.
  • Availability — decimal(8, 2) — NOT NULL — Work capacity (in hours) of the manufacturing location.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

Password

  • BusinessEntityID — int — Foreign key → Person.BusinessEntityID — NOT NULL
  • PasswordHash — varchar(128) — NOT NULL — Password for the e-mail account.
  • PasswordSalt — varchar(10) — NOT NULL — Random value concatenated with the password string before the password is hashed.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

Person

  • BusinessEntityID — int — Foreign key → BusinessEntity.BusinessEntityID — NOT NULL — Primary key for Person records.
  • PersonType — nchar(2) — NOT NULL — Primary type of person: SC = Store Contact, IN = Individual (retail) customer, SP = Sales person, EM = Employee (non-sa…
  • NameStyle — dbo.NameStyle — NOT NULL — 0 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (la…
  • Title — nvarchar(8) — A courtesy title. For example, Mr. or Ms.
  • FirstName — dbo.Name — NOT NULL — First name of the person.
  • MiddleName — dbo.Name — Middle name or middle initial of the person.
  • LastName — dbo.Name — NOT NULL — Last name of the person.
  • Suffix — nvarchar(10) — Surname suffix. For example, Sr. or Jr.
  • EmailPromotion — int — NOT NULL — 0 = Contact does not wish to receive e-mail promotions, 1 = Contact does wish to receive e-mail promotions from Adventu…
  • AdditionalContactInfo — xml(CONTENT Person.AdditionalContactInfoSchemaCollection) — Additional contact information about the person stored in xml format.
  • Demographics — xml(CONTENT Person.IndividualSurveySchemaCollection) — Personal information such as hobbies, and income collected from online shoppers. Used for sales analysis.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

PersonCreditCard

  • CreditCardID — int — Foreign key → CreditCard.CreditCardID — NOT NULL — Credit card identification number. Foreign key to CreditCard.CreditCardID.
  • BusinessEntityID — int — Foreign key — NOT NULL — Business entity identification number. Foreign key to Person.BusinessEntityID.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

PersonPhone

  • PhoneNumber — dbo.Phone — Primary key — NOT NULL — Telephone number identification number.
  • BusinessEntityID — int — Foreign key → Person.BusinessEntityID — NOT NULL — Business entity identification number. Foreign key to Person.BusinessEntityID.
  • PhoneNumberTypeID — int — Foreign key → PhoneNumberType.PhoneNumberTypeID — NOT NULL — Kind of phone number. Foreign key to PhoneNumberType.PhoneNumberTypeID.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

PhoneNumberType

  • PhoneNumberTypeID — int — Primary key — NOT NULL — Primary key for telephone number type records.
  • Name — dbo.Name — NOT NULL — Name of the telephone number type
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

Product

  • ProductID — int — Primary key — NOT NULL — Primary key for Product records.
  • Name — dbo.Name — NOT NULL — Name of the product.
  • ProductNumber — nvarchar(25) — NOT NULL — Unique product identification number.
  • MakeFlag — dbo.Flag — NOT NULL — 0 = Product is purchased, 1 = Product is manufactured in-house.
  • FinishedGoodsFlag — dbo.Flag — NOT NULL — 0 = Product is not a salable item. 1 = Product is salable.
  • Color — nvarchar(15) — Product color.
  • SafetyStockLevel — smallint — NOT NULL — Minimum inventory quantity.
  • ReorderPoint — smallint — NOT NULL — Inventory level that triggers a purchase order or work order.
  • StandardCost — money — NOT NULL — Standard cost of the product.
  • ListPrice — money — NOT NULL — Selling price.
  • Size — nvarchar(5) — Product size.
  • SizeUnitMeasureCode — nchar(3) — Foreign key — Unit of measure for Size column.
  • WeightUnitMeasureCode — nchar(3) — Foreign key — Unit of measure for Weight column.
  • Weight — decimal(8, 2) — Product weight.
  • DaysToManufacture — int — NOT NULL — Number of days required to manufacture the product.
  • ProductLine — nchar(2) — R = Road, M = Mountain, T = Touring, S = Standard
  • Class — nchar(2) — H = High, M = Medium, L = Low
  • Style — nchar(2) — W = Womens, M = Mens, U = Universal
  • ProductSubcategoryID — int — Foreign key → ProductSubcategory.ProductSubcategoryID — Product is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID.
  • ProductModelID — int — Foreign key → ProductModel.ProductModelID — Product is a member of this product model. Foreign key to ProductModel.ProductModelID.
  • SellStartDate — datetime — NOT NULL — Date the product was available for sale.
  • SellEndDate — datetime — Date the product was no longer available for sale.
  • DiscontinuedDate — datetime — Date the product was discontinued.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

ProductCategory

  • ProductCategoryID — int — Primary key — NOT NULL — Primary key for ProductCategory records.
  • Name — dbo.Name — NOT NULL — Category description.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

ProductCostHistory

  • StartDate — datetime — Primary key — NOT NULL — Product cost start date.
  • ProductID — int — Foreign key → Product.ProductID — NOT NULL — Product identification number. Foreign key to Product.ProductID
  • EndDate — datetime — Product cost end date.
  • StandardCost — money — NOT NULL — Standard cost of the product.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

ProductDescription

  • ProductDescriptionID — int — Primary key — NOT NULL — Primary key for ProductDescription records.
  • Description — nvarchar(400) — NOT NULL — Description of the product.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

ProductDocument

  • DocumentNode — hierarchyid — Foreign key → Document.DocumentNode — NOT NULL — Document identification number. Foreign key to Document.DocumentNode.
  • ProductID — int — Foreign key → Product.ProductID — NOT NULL — Product identification number. Foreign key to Product.ProductID.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

ProductInventory

  • LocationID — smallint — Foreign key → Location.LocationID — NOT NULL — Inventory location identification number. Foreign key to Location.LocationID.
  • ProductID — int — Foreign key → Product.ProductID — NOT NULL — Product identification number. Foreign key to Product.ProductID.
  • Shelf — nvarchar(10) — NOT NULL — Storage compartment within an inventory location.
  • Bin — tinyint — NOT NULL — Storage container on a shelf in an inventory location.
  • Quantity — smallint — NOT NULL — Quantity of products in the inventory location.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

ProductListPriceHistory

  • StartDate — datetime — Primary key — NOT NULL — List price start date.
  • ProductID — int — Foreign key → Product.ProductID — NOT NULL — Product identification number. Foreign key to Product.ProductID
  • EndDate — datetime — List price end date
  • ListPrice — money — NOT NULL — Product list price.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

ProductModel

  • ProductModelID — int — Primary key — NOT NULL — Primary key for ProductModel records.
  • Name — dbo.Name — NOT NULL — Product model description.
  • CatalogDescription — xml(CONTENT Production.ProductDescriptionSchemaCollection) — Detailed product catalog information in xml format.
  • Instructions — xml(CONTENT Production.ManuInstructionsSchemaCollection) — Manufacturing instructions in xml format.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

ProductModelIllustration

  • IllustrationID — int — Foreign key → Illustration.IllustrationID — NOT NULL — Primary key. Foreign key to Illustration.IllustrationID.
  • ProductModelID — int — Foreign key → ProductModel.ProductModelID — NOT NULL — Primary key. Foreign key to ProductModel.ProductModelID.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

ProductModelProductDescriptionCulture

  • CultureID — nchar(6) — Foreign key → Culture.CultureID — NOT NULL — Culture identification number. Foreign key to Culture.CultureID.
  • ProductDescriptionID — int — Foreign key → ProductDescription.ProductDescriptionID — NOT NULL — Primary key. Foreign key to ProductDescription.ProductDescriptionID.
  • ProductModelID — int — Foreign key → ProductModel.ProductModelID — NOT NULL — Primary key. Foreign key to ProductModel.ProductModelID.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

ProductPhoto

  • ProductPhotoID — int — Primary key — NOT NULL — Primary key for ProductPhoto records.
  • ThumbNailPhoto — varbinary(max) — Small image of the product.
  • ThumbnailPhotoFileName — nvarchar(50) — Small image file name.
  • LargePhoto — varbinary(max) — Large image of the product.
  • LargePhotoFileName — nvarchar(50) — Large image file name.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

ProductProductPhoto

  • ProductID — int — Foreign key → Product.ProductID — NOT NULL — Product identification number. Foreign key to Product.ProductID.
  • ProductPhotoID — int — Foreign key → ProductPhoto.ProductPhotoID — NOT NULL — Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

ProductReview

  • ProductReviewID — int — Primary key — NOT NULL — Primary key for ProductReview records.
  • ProductID — int — Foreign key → Product.ProductID — NOT NULL — Product identification number. Foreign key to Product.ProductID.
  • ReviewerName — dbo.Name — NOT NULL — Name of the reviewer.
  • ReviewDate — datetime — NOT NULL — Date review was submitted.
  • EmailAddress — nvarchar(50) — NOT NULL — Reviewer
  • Rating — int — NOT NULL — Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating.
  • Comments — nvarchar(3850) — Reviewer
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

ProductSubcategory

  • ProductSubcategoryID — int — Primary key — NOT NULL — Primary key for ProductSubcategory records.
  • ProductCategoryID — int — Foreign key → ProductCategory.ProductCategoryID — NOT NULL — Product category identification number. Foreign key to ProductCategory.ProductCategoryID.
  • Name — dbo.Name — NOT NULL — Subcategory description.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

ProductVendor

  • ProductID — int — Foreign key — NOT NULL — Primary key. Foreign key to Product.ProductID.
  • BusinessEntityID — int — Foreign key — NOT NULL — Primary key. Foreign key to Vendor.BusinessEntityID.
  • AverageLeadTime — int — NOT NULL — The average span of time (in days) between placing an order with the vendor and receiving the purchased product.
  • StandardPrice — money — NOT NULL — The vendor
  • LastReceiptCost — money — The selling price when last purchased.
  • LastReceiptDate — datetime — Date the product was last received by the vendor.
  • MinOrderQty — int — NOT NULL — The maximum quantity that should be ordered.
  • MaxOrderQty — int — NOT NULL — The minimum quantity that should be ordered.
  • OnOrderQty — int — The quantity currently on order.
  • UnitMeasureCode — nchar(3) — Foreign key → UnitMeasure.UnitMeasureCode — NOT NULL — The product
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

PurchaseOrderDetail

  • PurchaseOrderDetailID — int — Primary key — NOT NULL — Primary key. One line number per purchased product.
  • PurchaseOrderID — int — Foreign key → PurchaseOrderHeader.PurchaseOrderID — NOT NULL — Primary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID.
  • DueDate — datetime — NOT NULL — Date the product is expected to be received.
  • OrderQty — smallint — NOT NULL — Quantity ordered.
  • ProductID — int — Foreign key — NOT NULL — Product identification number. Foreign key to Product.ProductID.
  • UnitPrice — money — NOT NULL — Vendor
  • LineTotal — AS — Per product subtotal. Computed as OrderQty * UnitPrice.
  • ReceivedQty — decimal(8, 2) — NOT NULL — Quantity actually received from the vendor.
  • RejectedQty — decimal(8, 2) — NOT NULL — Quantity rejected during inspection.
  • StockedQty — AS — Quantity accepted into inventory. Computed as ReceivedQty - RejectedQty.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

PurchaseOrderHeader

  • PurchaseOrderID — int — Primary key — NOT NULL — Primary key.
  • RevisionNumber — tinyint — NOT NULL — Incremental number to track changes to the purchase order over time.
  • Status — tinyint — NOT NULL — Order current status. 1 = Pending; 2 = Approved; 3 = Rejected; 4 = Complete
  • EmployeeID — int — Foreign key — NOT NULL — Employee who created the purchase order. Foreign key to Employee.BusinessEntityID.
  • VendorID — int — Foreign key — NOT NULL — Vendor with whom the purchase order is placed. Foreign key to Vendor.BusinessEntityID.
  • ShipMethodID — int — Foreign key → ShipMethod.ShipMethodID — NOT NULL — Shipping method. Foreign key to ShipMethod.ShipMethodID.
  • OrderDate — datetime — NOT NULL — Purchase order creation date.
  • ShipDate — datetime — Estimated shipment date from the vendor.
  • SubTotal — money — NOT NULL — Purchase order subtotal. Computed as SUM(PurchaseOrderDetail.LineTotal)for the appropriate PurchaseOrderID.
  • TaxAmt — money — NOT NULL — Tax amount.
  • Freight — money — NOT NULL — Shipping cost.
  • TotalDue — AS — Total due to vendor. Computed as Subtotal + TaxAmt + Freight.
  • (0))) — PERSISTED — NOT NULL
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

SalesOrderDetail

  • SalesOrderDetailID — int — Primary key — NOT NULL — Primary key. One incremental unique number per product sold.
  • SalesOrderID — int — Foreign key — NOT NULL — Primary key. Foreign key to SalesOrderHeader.SalesOrderID.
  • CarrierTrackingNumber — nvarchar(25) — Shipment tracking number supplied by the shipper.
  • OrderQty — smallint — NOT NULL — Quantity ordered per product.
  • ProductID — int — Foreign key → SpecialOfferProduct.ProductID — NOT NULL — Product sold to customer. Foreign key to Product.ProductID.
  • SpecialOfferID — int — Foreign key → SpecialOfferProduct.SpecialOfferID — NOT NULL — Promotional code. Foreign key to SpecialOffer.SpecialOfferID.
  • UnitPrice — money — NOT NULL — Selling price of a single product.
  • UnitPriceDiscount — money — NOT NULL — Discount amount.
  • LineTotal — AS — Per product subtotal. Computed as UnitPrice * (1 - UnitPriceDiscount) * OrderQty.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

SalesOrderHeader

  • SalesOrderID — int — Primary key — NOT NULL — Primary key.
  • RevisionNumber — tinyint — NOT NULL — Incremental number to track changes to the sales order over time.
  • OrderDate — datetime — NOT NULL — Dates the sales order was created.
  • DueDate — datetime — NOT NULL — Date the order is due to the customer.
  • ShipDate — datetime — Date the order was shipped to the customer.
  • Status — tinyint — NOT NULL — Order current status. 1 = In process; 2 = Approved; 3 = Backordered; 4 = Rejected; 5 = Shipped; 6 = Cancelled
  • OnlineOrderFlag — dbo.Flag — NOT NULL — 0 = Order placed by sales person. 1 = Order placed online by customer.
  • SalesOrderNumber — AS — Unique sales order identification number.
  • N*** — ERROR
  • PurchaseOrderNumber — dbo.OrderNumber — Customer purchase order number reference.
  • AccountNumber — dbo.AccountNumber — Financial accounting number reference.
  • CustomerID — int — Foreign key → Customer.CustomerID — NOT NULL — Customer identification number. Foreign key to Customer.BusinessEntityID.
  • SalesPersonID — int — Foreign key → SalesPerson.BusinessEntityID — Sales person who created the sales order. Foreign key to SalesPerson.BusinessEntityID.
  • TerritoryID — int — Foreign key → SalesTerritory.TerritoryID — Territory in which the sale was made. Foreign key to SalesTerritory.SalesTerritoryID.
  • BillToAddressID — int — Foreign key → Address.AddressID — NOT NULL — Customer billing address. Foreign key to Address.AddressID.
  • ShipToAddressID — int — Foreign key → Address.AddressID — NOT NULL — Customer shipping address. Foreign key to Address.AddressID.
  • ShipMethodID — int — Foreign key — NOT NULL — Shipping method. Foreign key to ShipMethod.ShipMethodID.
  • CreditCardID — int — Foreign key — Credit card identification number. Foreign key to CreditCard.CreditCardID.
  • CreditCardApprovalCode — varchar(15) — Approval code provided by the credit card company.
  • CurrencyRateID — int — Foreign key — Currency exchange rate used. Foreign key to CurrencyRate.CurrencyRateID.
  • SubTotal — money — NOT NULL — Sales subtotal. Computed as SUM(SalesOrderDetail.LineTotal)for the appropriate SalesOrderID.
  • TaxAmt — money — NOT NULL — Tax amount.
  • Freight — money — NOT NULL — Shipping cost.
  • TotalDue — AS — Total due from customer. Computed as Subtotal + TaxAmt + Freight.
  • Comment — nvarchar(128) — Sales representative comments.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

SalesOrderHeaderSalesReason

  • SalesOrderID — int — Foreign key — NOT NULL — Primary key. Foreign key to SalesOrderHeader.SalesOrderID.
  • SalesReasonID — int — Foreign key → SalesReason.SalesReasonID — NOT NULL — Primary key. Foreign key to SalesReason.SalesReasonID.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

SalesPerson

  • BusinessEntityID — int — Foreign key → Employee.BusinessEntityID — NOT NULL — Primary key for SalesPerson records. Foreign key to Employee.BusinessEntityID
  • TerritoryID — int — Foreign key → SalesTerritory.TerritoryID — Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID.
  • SalesQuota — money — Projected yearly sales.
  • Bonus — money — NOT NULL — Bonus due if quota is met.
  • CommissionPct — smallmoney — NOT NULL — Commision percent received per sale.
  • SalesYTD — money — NOT NULL — Sales total year to date.
  • SalesLastYear — money — NOT NULL — Sales total of previous year.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

SalesPersonQuotaHistory

  • QuotaDate — datetime — Primary key — NOT NULL — Sales quota date.
  • BusinessEntityID — int — Foreign key — NOT NULL — Sales person identification number. Foreign key to SalesPerson.BusinessEntityID.
  • SalesQuota — money — NOT NULL — Sales quota amount.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

SalesReason

  • SalesReasonID — int — Primary key — NOT NULL — Primary key for SalesReason records.
  • Name — dbo.Name — NOT NULL — Sales reason description.
  • ReasonType — dbo.Name — NOT NULL — Category the sales reason belongs to.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

SalesTaxRate

  • SalesTaxRateID — int — Primary key — NOT NULL — Primary key for SalesTaxRate records.
  • StateProvinceID — int — Foreign key — NOT NULL — State, province, or country/region the sales tax applies to.
  • TaxType — tinyint — NOT NULL — 1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail…
  • TaxRate — smallmoney — NOT NULL — Tax rate amount.
  • Name — dbo.Name — NOT NULL — Tax rate description.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

SalesTerritory

  • TerritoryID — int — Primary key — NOT NULL — Primary key for SalesTerritory records.
  • Name — dbo.Name — NOT NULL — Sales territory description
  • CountryRegionCode — nvarchar(3) — Foreign key → CountryRegion.CountryRegionCode — NOT NULL — ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode.
  • Group — nvarchar(50) — NOT NULL — Geographic area to which the sales territory belong.
  • SalesYTD — money — NOT NULL — Sales in the territory year to date.
  • SalesLastYear — money — NOT NULL — Sales in the territory the previous year.
  • CostYTD — money — NOT NULL — Business costs in the territory year to date.
  • CostLastYear — money — NOT NULL — Business costs in the territory the previous year.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

SalesTerritoryHistory

  • StartDate — datetime — Primary key — NOT NULL — Primary key. Date the sales representive started work in the territory.
  • BusinessEntityID — int — Foreign key — NOT NULL — Primary key. The sales rep. Foreign key to SalesPerson.BusinessEntityID.
  • TerritoryID — int — Foreign key — NOT NULL — Primary key. Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID.
  • EndDate — datetime — Date the sales representative left work in the territory.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

ScrapReason

  • ScrapReasonID — smallint — Primary key — NOT NULL — Primary key for ScrapReason records.
  • Name — dbo.Name — NOT NULL — Failure description.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

Shift

  • ShiftID — tinyint — Primary key — NOT NULL — Primary key for Shift records.
  • Name — dbo.Name — NOT NULL — Shift description.
  • StartTime — time(7) — NOT NULL — Shift start time.
  • EndTime — time(7) — NOT NULL — Shift end time.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

ShipMethod

  • ShipMethodID — int — Primary key — NOT NULL — Primary key for ShipMethod records.
  • Name — dbo.Name — NOT NULL — Shipping company name.
  • ShipBase — money — NOT NULL — Minimum shipping charge.
  • ShipRate — money — NOT NULL — Shipping charge per pound.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

ShoppingCartItem

  • ShoppingCartItemID — int — Primary key — NOT NULL — Primary key for ShoppingCartItem records.
  • ShoppingCartID — nvarchar(50) — NOT NULL — Shopping cart identification number.
  • Quantity — int — NOT NULL — Product quantity ordered.
  • ProductID — int — Foreign key — NOT NULL — Product ordered. Foreign key to Product.ProductID.
  • DateCreated — datetime — NOT NULL — Date the time the record was created.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

SpecialOffer

  • SpecialOfferID — int — Primary key — NOT NULL — Primary key for SpecialOffer records.
  • Description — nvarchar(255) — NOT NULL — Discount description.
  • DiscountPct — smallmoney — NOT NULL — Discount precentage.
  • Type — nvarchar(50) — NOT NULL — Discount type category.
  • Category — nvarchar(50) — NOT NULL — Group the discount applies to such as Reseller or Customer.
  • StartDate — datetime — NOT NULL — Discount start date.
  • EndDate — datetime — NOT NULL — Discount end date.
  • MinQty — int — NOT NULL — Minimum discount percent allowed.
  • MaxQty — int — Maximum discount percent allowed.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

SpecialOfferProduct

  • ProductID — int — Foreign key — NOT NULL — Product identification number. Foreign key to Product.ProductID.
  • SpecialOfferID — int — Foreign key → SpecialOffer.SpecialOfferID — NOT NULL — Primary key for SpecialOfferProduct records.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

StateProvince

  • StateProvinceID — int — Primary key — NOT NULL — Primary key for StateProvince records.
  • StateProvinceCode — nchar(3) — NOT NULL — ISO standard state or province code.
  • CountryRegionCode — nvarchar(3) — Foreign key → CountryRegion.CountryRegionCode — NOT NULL — ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode.
  • IsOnlyStateProvinceFlag — dbo.Flag — NOT NULL — 0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode.
  • Name — dbo.Name — NOT NULL — State or province description.
  • TerritoryID — int — Foreign key → SalesTerritory.TerritoryID — NOT NULL — ID of the territory in which the state or province is located. Foreign key to SalesTerritory.SalesTerritoryID.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

Store

  • BusinessEntityID — int — Foreign key → BusinessEntity.BusinessEntityID — NOT NULL — Primary key. Foreign key to Customer.BusinessEntityID.
  • Name — dbo.Name — NOT NULL — Name of the store.
  • SalesPersonID — int — Foreign key → SalesPerson.BusinessEntityID — ID of the sales person assigned to the customer. Foreign key to SalesPerson.BusinessEntityID.
  • Demographics — xml(CONTENT Sales.StoreSurveySchemaCollection) — Demographic informationg about the store such as the number of employees, annual sales and store type.
  • rowguid — uniqueidentifier — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

TransactionHistory

  • TransactionID — int — Primary key — NOT NULL — Primary key for TransactionHistory records.
  • ProductID — int — Foreign key → Product.ProductID — NOT NULL — Product identification number. Foreign key to Product.ProductID.
  • ReferenceOrderID — int — NOT NULL — Purchase order, sales order, or work order identification number.
  • ReferenceOrderLineID — int — NOT NULL — Line number associated with the purchase order, sales order, or work order.
  • TransactionDate — datetime — NOT NULL — Date and time of the transaction.
  • TransactionType — nchar(1) — NOT NULL — W = WorkOrder, S = SalesOrder, P = PurchaseOrder
  • Quantity — int — NOT NULL — Product quantity.
  • ActualCost — money — NOT NULL — Product cost.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

TransactionHistoryArchive

  • TransactionID — int — Primary key — NOT NULL — Primary key for TransactionHistoryArchive records.
  • ProductID — int — NOT NULL — Product identification number. Foreign key to Product.ProductID.
  • ReferenceOrderID — int — NOT NULL — Purchase order, sales order, or work order identification number.
  • ReferenceOrderLineID — int — NOT NULL — Line number associated with the purchase order, sales order, or work order.
  • TransactionDate — datetime — NOT NULL — Date and time of the transaction.
  • TransactionType — nchar(1) — NOT NULL — W = Work Order, S = Sales Order, P = Purchase Order
  • Quantity — int — NOT NULL — Product quantity.
  • ActualCost — money — NOT NULL — Product cost.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

UnitMeasure

  • UnitMeasureCode — nchar(3) — Primary key — NOT NULL — Primary key.
  • Name — dbo.Name — NOT NULL — Unit of measure description.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

Vendor

  • BusinessEntityID — int — Foreign key → BusinessEntity.BusinessEntityID — NOT NULL — Primary key for Vendor records. Foreign key to BusinessEntity.BusinessEntityID
  • AccountNumber — dbo.AccountNumber — NOT NULL — Vendor account (identification) number.
  • Name — dbo.Name — NOT NULL — Company name.
  • CreditRating — tinyint — NOT NULL — 1 = Superior, 2 = Excellent, 3 = Above average, 4 = Average, 5 = Below average
  • PreferredVendorStatus — dbo.Flag — NOT NULL — 0 = Do not use if another vendor is available. 1 = Preferred over other vendors supplying the same product.
  • ActiveFlag — dbo.Flag — NOT NULL — 0 = Vendor no longer used. 1 = Vendor is actively used.
  • PurchasingWebServiceURL — nvarchar(1024) — Vendor URL.
  • ModifiedDate — datetime — NOT NULL — Date and time the record was last updated.
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =