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