ㅇㅇㅇㅇ
Tables (4)
ORDERS
- order_id — INT
- user_id — INT — NOT NULL
- order_date — TIMESTAMP
- total_amount — DECIMAL(10, 2) — NOT NULL
ORDER_ITEMS
- order_item_id — INT
- order_id — INT — NOT NULL
- product_id — INT — NOT NULL
- quantity — INT — NOT NULL
- price_per_unit — DECIMAL(10, 2) — NOT NULL
PRODUCTS
- product_id — INT
- product_name — VARCHAR(100) — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
- stock_quantity — INT
USERS
- user_id — INT
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP