Instructions

Simply import this database to your live (or local) MySQL testing server to get started.

This database is provided as a .SQL file which can be imported, or executed, to a MySQL database server. Before you proceed, you will need to have access to a MySQL database server. Most likely, you will want to set up a PHP/MySQL testing environment on your local machine.

For more information on setting up a local testing server, visit one of the following URLS:

With your server configured and ready to go, follow these instructions for importing the database file to your server:

http://www.webassist.com/go/howto/import_sql

Close

Close

A three-tiered cylinder representing a database with the descriptive text FREE

eCommerce mySQL Database

The database architecture to get your eCommerce website
off the ground... quickly.

Free!

Download

Database Relationship Diagram

Click the diagram icon to the right to see the ecommerce database architecture made easily available to you in mySQL.

Show Diagram

Product Summary

This free MySQL database contains all the necessary database tables and columns for a typical eCommerce website.  This is provided for any web developer - novice or advanced, to leverage as a great starting point in their production process.  To save you time, and the need to create your own database, WebAssist documentation will reference this database in numerous tutorials.

Endless Applications
Although created to fulfill all the needs of an eCommerce website, this database can be used for most PHP websites, without the need for much modification. You are free to use and modify this database to suit your needs.
Works with any WebAssist extension
This database contains all the necessary tables and relationship to work with any of the web development Dreamweaver extensions created by WebAssist. You could use the Users table with SecurityAssist, or the Orders and OrderDetails tables with eCart.
Supported Documentation
This database will be referenced throughout many tutorials found on the WebAssist website. Allowing you to avoid the database creation and become successful with WebAssist extensions faster.
Free and fully customizable
Even though this database has everything you need, you can modify however you please. Add new columns or tables, or modify the ones that already exist. This database is provided for you to use however you see fit.

Understanding the database table relationships

To accommodate for various features that you might want in an online store, this database comes with a number of pre-configured relationships.  This section explains the purpose for each table within this database, and the relationships that those tables, and columns, have with one another.

Note: This database contains many tables or columns that may not be necessary in your situation.  You only need to use the columns and tables that suit your needs.

Products

The Products table is intended to contain the information for each product you would sell in your online store.  This contains columns for graphics, price, short description, long description, and more.

Relationships

  • 1 to many relationship from ProductID column to ProductOptions and OrderDetails tables.
  • Many to 1 relationship from ProductCategoryID to ProductCategories table.

ProductCategories

This table is intended to contain all the different product categories.

Relationships

  • 1 to many relationship from CategoryID column to Products table.

Orders

The Orders table stores information for each of the purchases made on your site.  This will include information regarding the total price of the order, shipping address, customer, etc.

Relationships

  • 1 to many relationship from OrderID column to OrderDetails table.
  • Many to 1 relationship from OrderUserID to Users table.

OrderDetails

The OrderDetails table contains the specific details for each order.  This includes each product that was ordered, price per product, quantity, etc.

Relationships

  • Many to 1 relationship from DetailOrderID to Orders table.
  • Many to 1 relationship from DetailProductID to Products table.

Users

The Users table is provided to store information for users that register on your site.  This includes columns for username, email address, password, etc.

Relationships

  • 1 to many relationship from UserID column to Orders table.

 

Product Options

The following tables are provided to allow the implementation of product options.  Using these tables and their various relationships with each other and the products table, you should be able to develop an online store that sells products with various options such as color, size, etc.

ProductOptions

This table is used as a linking table between the Products, Options, and OptionGroups tables.

Relationships

  • Many to 1 relationship from ProductID column to Products table.
  • Many to 1 relationship from OptionID column to Options table.
  • Many to 1 relationship from OptionGroupID column to OptionGroups table.

OptionGroups

The OptionGroups table is provided to store details for each type of option provided for your products.  For example, you might have an entry for Color, and another for Size.

Relationships

  • 1 to many relationship from OptionGroupID column to ProductOptions table.
  • 1 to many relationship from OptionGroupID column to Options table.

Options

This table is intended to contain the values for each OptionGroup that you would associate with a product. For example, the OptionName column would likely contain the different colors that would be available from the OptionGroups table.

Relationships

  • 1 to many relationship from OptionID column to ProductOptions table.
  • Many to 1 relationship from OptionGroupID to OptionGroups table.

Is this different than the Blue Sky Music database?

Yes. The Blue Sky Music database was provided as a learning tool for you to use as you work through Solution Recipes and various other tutorials. However, that database was not designed to be used as your production database, and likely did not contain all the tables necessary for your application.

This database is a fully functional MySQL database that can be used for an eCommerce website, or something much more simple, such as a user registration system.

I don’t see many WebAssist tutorials using this database.

Currently, there are only a few tutorials that reference this database. However, this database should still contain the tables or columns you would need when following other, older tutorials.

In the future, more complex tutorials that require a database will refer to this database and its tables, to give customers a reference as to what tables and structure is needed.