PostgreSQL Sample Database
This repo contains a db which simulates a webshop. The original sql files were dumped from postgres 10, i have migrated these to postgres 18, and added some missing foreign key constraints.
The data includes:
- 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
# default db name is mywebshop
./restore.sh
./restore.sh webshop # or some other name(using the defaults localhost:5432 and user postgres)
Created with schemaspy:
