PostgreSQL Ecommerce Database Setup

I’m launching a fresh PostgreSQL back-end and need it designed from the ground up to power an ecommerce workflow. The database must comfortably store products, orders, and payments, with the first release focused on the payments, refunds, and full transaction history module.

Here’s what I expect from you:
• A well-structured schema that covers the tables, relationships, constraints, and indexes necessary for reliable payment data handling.
• Clear DDL scripts I can run on a clean PostgreSQL instance.
• An ER diagram (PDF or PNG) that shows how everything fits together.
• Simple seed data so I can run smoke tests right after deployment.
• Brief documentation explaining any non-obvious design choices and the connection string format.

I’ll provide access to the server; you deliver scripts and docs that run without modification on PostgreSQL 15+. Once the migration executes cleanly and my test suite confirms inserts, updates, and rollbacks, the job is done.