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)