Adventure

Tables (13)

address

  • AddressID — int(11) — Primary key — NOT NULL — Primary key for Address records.
  • AddressLine1 — varchar(60) — NOT NULL — First street address line.
  • AddressLine2 — varchar(60) — Second street address line.
  • City — varchar(30) — NOT NULL — Name of the city.
  • StateProvince — varchar(100) — NOT NULL — Name of state or province.
  • CountryRegion — varchar(100) — NOT NULL
  • PostalCode — varchar(15) — NOT NULL — Postal code for the street address.
  • rowguid — varchar(64) — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — timestamp — NOT NULL — Date and time the record was last updated.

buildversion

  • SystemInformationID — tinyint(3) — NOT NULL — Primary key for BuildVersion records.
  • Database — Version` — NOT NULL — Version number of the database in 9.yy.mm.dd.00 format.
  • VersionDate — datetime — NOT NULL — Date and time the record was last updated.
  • ModifiedDate — timestamp — NOT NULL — Date and time the record was last updated.

customer

  • CustomerID — int(11) — Primary key — NOT NULL — Primary key for Customer records.
  • NameStyle — tinyint(1) — NOT NULL — 0 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (la…
  • Title — varchar(8) — A courtesy title. For example, Mr. or Ms.
  • FirstName — varchar(100) — NOT NULL — First name of the person.
  • MiddleName — varchar(100) — Middle name or middle initial of the person.
  • LastName — varchar(100) — NOT NULL — Last name of the person.
  • Suffix — varchar(10) — Surname suffix. For example, Sr. or Jr.
  • CompanyName — varchar(128) — The customer's organization.
  • SalesPerson — varchar(256) — The customer's sales person, an employee of AdventureWorks Cycles.
  • EmailAddress — varchar(50) — E-mail address for the person.
  • Phone — varchar(50) — Phone number associated with the person.
  • 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 — varchar(64) — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — timestamp — NOT NULL — Date and time the record was last updated.

customeraddress

  • CustomerID (CustomerID2) — int(11) — Foreign key → customer.CustomerID — NOT NULL — Primary key for Customer records.
  • AddressID (AddressID2) — int(11) — Foreign key → address.AddressID — NOT NULL — Primary key for Address records.
  • AddressType — varchar(100) — NOT NULL — The kind of Address. One of: Archive, Billing, Home, Main Office, Primary, Shipping
  • rowguid — varchar(64) — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — timestamp — NOT NULL — Date and time the record was last updated.

errorlog

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

product

  • ProductID — int(11) — Primary key — NOT NULL — Primary key for Product records.
  • Name — varchar(100) — NOT NULL — Name of the product.
  • ProductNumber — varchar(25) — NOT NULL — Unique product identification number.
  • Color — varchar(15) — Product color.
  • StandardCost — decimal(19, 4) — NOT NULL — Standard cost of the product.
  • ListPrice — decimal(19, 4) — NOT NULL — Selling price.
  • Size — varchar(5) — Product size.
  • Weight — decimal(8, 2) — Product weight.
  • ProductCategoryID — int(11) — Product is a member of this product category. Foreign key to ProductCategory.ProductCategoryID.
  • ProductModelID — int(11) — 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.
  • ThumbNailPhoto — longblob — Small image of the product.
  • ThumbnailPhotoFileName — varchar(50) — Small image file name.
  • rowguid — varchar(64) — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — timestamp — NOT NULL — Date and time the record was last updated.

productcategory

  • ProductCategoryID — int(11) — Primary key — NOT NULL — Primary key for ProductCategory records.
  • ParentProductCategoryID — int(11) — Foreign key → productcategory.ProductCategoryID — Product category identification number of immediate ancestor category. Foreign key to ProductCategory.ProductCategoryID.
  • Name — varchar(100) — NOT NULL — Category description.
  • rowguid — varchar(64) — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — timestamp — NOT NULL — Date and time the record was last updated.

productdescription

  • ProductDescriptionID — int(11) — Primary key — NOT NULL — Primary key for ProductDescription records.
  • Description — varchar(400) — NOT NULL — Description of the product.
  • rowguid — varchar(64) — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — timestamp — NOT NULL — Date and time the record was last updated.

productmodel

  • ProductModelID — int(11) — Primary key — NOT NULL
  • Name — varchar(100) — NOT NULL
  • CatalogDescription — text
  • rowguid — varchar(64) — NOT NULL
  • ModifiedDate — timestamp — NOT NULL

productmodelproductdescription

  • ProductModelID — int(11) — Primary key — NOT NULL — Primary key. Foreign key to ProductModel.ProductModelID.
  • ProductDescriptionID — int(11) — Primary key — NOT NULL — Primary key. Foreign key to ProductDescription.ProductDescriptionID.
  • Culture — char(6) — Primary key — NOT NULL — The culture for which the description is written
  • rowguid — varchar(64) — NOT NULL
  • ModifiedDate — timestamp — NOT NULL — Date and time the record was last updated.

salesorderdetail

  • SalesOrderID — int(11) — Primary key — NOT NULL — Primary key. Foreign key to SalesOrderHeader.SalesOrderID.
  • SalesOrderDetailID — int(11) — Primary key — NOT NULL — Primary key. One incremental unique number per product sold.
  • OrderQty — smallint(6) — NOT NULL — Quantity ordered per product.
  • ProductID — int(11) — NOT NULL — Product sold to customer. Foreign key to Product.ProductID.
  • UnitPrice — decimal(19, 4) — NOT NULL — Selling price of a single product.
  • UnitPriceDiscount — decimal(19, 4) — NOT NULL — Discount amount.
  • LineTotal — decimal(38, 6) — NOT NULL — Per product subtotal. Computed as UnitPrice * (1 - UnitPriceDiscount) * OrderQty.
  • rowguid — varchar(64) — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — timestamp — NOT NULL — Date and time the record was last updated.

salesorderheader

  • SalesOrderID — int(11) — Primary key — NOT NULL — Primary key.
  • CustomerID (CustomerID2) — int(11) — Foreign key → customer.CustomerID — NOT NULL — Primary key for Customer records.
  • AddressID (AddressID2) — int(11) — Foreign key → address.AddressID — NOT NULL — Primary key for Address records.
  • AddressID (AddressID3) — int(11) — Foreign key → address.AddressID — NOT NULL — Primary key for Address records.
  • RevisionNumber — tinyint(3) — NOT NULL — Incremental number to track changes to the sales order over time.
  • OrderDate — timestamp — 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(3) — NOT NULL — Order current status. 1 = In process; 2 = Approved; 3 = Backordered; 4 = Rejected; 5 = Shipped; 6 = Cancelled
  • OnlineOrderFlag — tinyint(1) — NOT NULL — 0 = Order placed by sales person. 1 = Order placed online by customer.
  • SalesOrderNumber — varchar(25) — NOT NULL — Unique sales order identification number.
  • PurchaseOrderNumber — varchar(50) — Customer purchase order number reference.
  • AccountNumber — varchar(30) — Financial accounting number reference.
  • ShipToAddressID — int(11) — The ID of the location to send goods. Foreign key to the Address table.
  • BillToAddressID — int(11) — The ID of the location to send invoices. Foreign key to the Address table.
  • ShipMethod — varchar(50) — NOT NULL — Shipping method. Foreign key to ShipMethod.ShipMethodID.
  • CreditCardApprovalCode — varchar(15) — Approval code provided by the credit card company.
  • SubTotal — decimal(19, 4) — NOT NULL — Sales subtotal. Computed as SUM(SalesOrderDetail.LineTotal)for the appropriate SalesOrderID.
  • TaxAmt — decimal(19, 4) — NOT NULL — Tax amount.
  • Freight — decimal(19, 4) — NOT NULL — Shipping cost.
  • TotalDue — decimal(19, 4) — NOT NULL — Total due from customer. Computed as Subtotal + TaxAmt + Freight.
  • Comment — longtext — Sales representative comments.
  • rowguid — varchar(64) — NOT NULL — ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  • ModifiedDate — timestamp — NOT NULL — Date and time the record was last updated.

sysdiagrams

  • diagram_id — int(11) — Primary key — NOT NULL
  • name — varchar(160) — NOT NULL
  • principal_id — int(11) — NOT NULL
  • version — int(11)
  • definition — longblob