Sample Database for a Webshop with customers, products and orders, including data!
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
data
schema
src
.gitignore
README.md
dump.sh
restore.sh
schemaspy.sh

README.md

PostgreSQL Sample Database

This is a sample webshop, including

  • 1000 customers
  • 2000 orders
  • 1000 products with 17730 different articles

You can either create the database yourself with the scripts in src or restore the dump in data via

$ ./restore.sh myDatabaseName

(using the defaults localhost:5432 and user postgres)

Schema

Created with schemaspy: