쇼핑
테이블 (4)
order_items
- order_item_id — INT — 기본 키
- order_id — INT — NOT NULL
- product_id — INT — NOT NULL
- quantity — INT — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
orders
- order_date — DATETIME — 기본 키
- user_id (user_id2) — INT — 외래 키 → users.user_id
- total_amount — DECIMAL(10, 2) — NOT NULL
- status — VARCHAR(20)
- order_id — INT
products
- product_id — INT — 기본 키
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- price — DECIMAL(10, 2) — NOT NULL
- stock — INT — NOT NULL
- created_at — DATETIME
users
- user_id — INT — 기본 키
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at — DATETIME