MySQL Sample Database

Download Sample Database

Download Sample Database

USE classicmodels;
SELECT * FROM customers;

Sample Database Schema

  • Customers: stores customer’s data.

  • Products: stores a list of scale model cars.

  • ProductLines: stores a list of product line categories.

  • Orders: stores sales orders placed by customers.

  • OrderDetails: stores sales order line items for each sales order.

  • Payments: stores payments made by customers based on their accounts.

  • Employees: stores all employee information as well as the organization structure such as who reports to whom.

  • Offices: stores sales office data.