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 — =