ReeseLin/order-system
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
main
order-system/migrations
History
ReeseLin bee03ea349 Initial commit: Go + PostgreSQL order management system 
- Backend: Go 1.26 + Chi router + pgx v5 (no ORM, hand-written SQL)
- Database: PostgreSQL with 5 tables (users, products, orders, order_items, payments)
- Frontend admin: Vue 3 + Vite + Element Plus
- Docker Compose for PostgreSQL + pgAdmin
- Includes SQL learning docs and seed data
- Endpoints: products CRUD, orders CRUD, reports (daily sales, top products, customer spending)
- New: GET /api/orders/by-date for date-range order query
2026-06-15 17:14:18 +08:00
..
001_create_users.sql Initial commit: Go + PostgreSQL order management system 2026-06-15 17:14:18 +08:00
002_create_products.sql Initial commit: Go + PostgreSQL order management system 2026-06-15 17:14:18 +08:00
003_create_orders.sql Initial commit: Go + PostgreSQL order management system 2026-06-15 17:14:18 +08:00
004_create_order_items.sql Initial commit: Go + PostgreSQL order management system 2026-06-15 17:14:18 +08:00
005_create_payments.sql Initial commit: Go + PostgreSQL order management system 2026-06-15 17:14:18 +08:00
006_seed_data.sql Initial commit: Go + PostgreSQL order management system 2026-06-15 17:14:18 +08:00