This is an example database

The schema is real, but it is not connected to a database. Sign in to import or connect your own.

Sign in to add yours

E-commerce

PostgreSQL 17

Customers, orders, products and line items for a small online store.

ExampleImportedVersion 17
4 tables18 columns4 primary keys3 foreign keysAdded Sep 12, 2025, 10:00:00 AM

Database rules

The AI follows these rules in every chat that uses this database.

  • Revenue uses `order_items.quantity * order_items.unit_price`; exclude orders with status 'cancelled'.
  • Customer lifetime revenue counts only orders with status 'paid'.

4 tables, 18 columns — 4 primary keys and 3 foreign keys.