q8
Tables (5)
Order
- 주문번호 (order_id) — Number(5) — Primary key — NOT NULL
- 고객id (customer_id) — Number(5)
- 주문날짜 (order_date) — DATETIME
- 배송상태 (delivery_status) — Varchar2(10)
- 결제상태 (payment_status) — Varchar2(10)
- 제품수량 (quantity) — Number(5)
Payment
- 결제id (Payment_id) — Number(5) — Primary key — NOT NULL
- 주문번호 (order_id) — Number(5)
- 결제 금액 (amount) — Number(5)
- 결제수단 (method) — Varchar2(10)
- 결제상태 (payment_status) — Varchar2(10)
Product
- Key (product_id) — Number(5) — Primary key — NOT NULL
- Field (product_code) — Varchar2(10)
- Field2 (name) — Varchar2(10)
- Field3 (category) — Varchar2(10)
- Field (price) — Number(5)
- Field2 (stock) — Number(5)
Review
- 리뷰id (review_id) — Number(5) — Primary key — NOT NULL
- 고객id (customer_id) — Number(5)
- 제품id (product_id) — Number(5)
- 리뷰내용 (content) — Varchar2(10)
- 별점 (rating) — Number(5)
- 작성날짜 (date_written) — DATETIME
customer
- 고객id (customer_id) — Number(5) — Primary key — NOT NULL
- 이름 (name) — Varchar2(10)
- 이메일 (email) — Varchar2(10)
- 전화번호 (phone) — Varchar2(10)
- 배송주소 (address) — Varchar2(10)
- 계정 (account) — Varchar2(10)