Core
Tables (3)
Member (Untitled)
- 회원 ID (member_id) — Primary key — NOT NULL
- 회원 등급 (grade)
Order (Untitled3)
- 주문 ID (order_id) — Primary key — NOT NULL
- 회원 ID (member_id) — Foreign key → Member.회원 ID — NOT NULL
- 상품 ID (product_id) — Foreign key → Product.상품 ID — NOT NULL
- 주문 금액 (order_cost)
Product (Untitled2)
- 상품 ID (product_id) — Primary key — NOT NULL
- 상품명 (product_name)
- Field (product_cost)