시크릿포레스트 팀프로젝트

테이블 (4)

Orders

  • order_num — varchar(20) — 기본 키 — NOT NULL
  • prod_id — varchar2(30) — 외래 키 → Product.prod_id — NOT NULL
  • user_id — varchar2(30) — 외래 키 → Users.user_id — NOT NULL
  • prod_name — varchar(30)
  • order_date — date
  • coupon — varchar(200)
  • user_destination — varchar(100)
  • user_recipient — varchar(100)
  • user_payment — varchar2(20)

Product

  • prod_id — varchar2(30) — 기본 키 — NOT NULL
  • prod_name — varchar2(200)
  • prod_price — number(30)
  • orderable — varchar2(10)
  • prod_color — varchar2(30)
  • prod_category — varchar2(100)
  • image — varchar2(255)

Review

  • review_num — number(10) — 기본 키 — NOT NULL
  • user_id — varchar2(30) — 외래 키 → Users.user_id — NOT NULL
  • review_title — varchar2(100)
  • review_content — CLOB
  • write_date — date
  • delete_date — date
  • delete_reason — varchar(30)

Users

  • user_id — varchar2(30) — 기본 키 — NOT NULL
  • user_name — varchar2(30)
  • user_password — varchar2(100)
  • user_email — varchar2(50)
  • user_phone — varchar2(50)
  • user_address — varchar2(100)