Mall

Tables (8)

Basket

  • OrderNum — NUMBER — Primary key — NOT NULL
  • productID (product_id) — VARCHAR2(10) — Foreign key → Product.product_id — NOT NULL
  • memid — varchar(20) — Foreign key → member.memid — NOT NULL
  • Quantity — NUMBER

PaymentInfo

  • paymentNum — NUMBER — Primary key — NOT NULL
  • memid — varchar(20) — Foreign key → member.memid — NOT NULL
  • email — varchar(30) — NOT NULL
  • phone — varchar(13) — NOT NULL
  • address — varchar(100)
  • payment — varchar(50)
  • product_id — VARCHAR2(999) — NOT NULL
  • Quantity — VARCHAR2(999) — NOT NULL
  • product_name — VARCHAR2(999) — NOT NULL
  • product_price — VARCHAR2(999) — NOT NULL
  • Money — VARCHAR2(999) — NOT NULL
  • sumMoney — int — NOT NULL
  • fee — int
  • allSum — int — NOT NULL
  • paymentDate — DATE

Product

  • product_id — VARCHAR2(10) — Primary key — NOT NULL
  • product_name — VARCHAR2(50) — NOT NULL
  • product_price — int — NOT NULL
  • product_detail — VARCHAR2(300)
  • product_keyword — VARCHAR2(200) — NOT NULL
  • product_url — VARCHAR2(100)

contents_board

  • contents_num — NUMBER — Primary key — NOT NULL
  • contents_subject — VARCHAR2(100)
  • contents_creator — VARCHAR2(100)
  • contents_src — VARCHAR2(100)
  • contents_file — VARCHAR2(100)

jjim

  • rec_id (memid) — varchar(20) — Foreign key → member.memid — NOT NULL
  • contents_num — NUMBER — Foreign key → contents_board.contents_num — NOT NULL

jjim_product

  • rec_id (memid) — varchar(20) — Foreign key → member.memid — NOT NULL
  • product_id — VARCHAR2(10) — Foreign key → Product.product_id — NOT NULL

member

  • memid — varchar(20) — Primary key — NOT NULL
  • pw — varchar(20) — NOT NULL
  • email — varchar(30) — NOT NULL
  • phone — varchar(13) — NOT NULL
  • address — varchar(100)
  • payment — varchar(50)
  • memberDate — DATE

review_board

  • board_num — NUMBER — Primary key — NOT NULL
  • board_id (memid) — varchar(20) — Foreign key → member.memid — NOT NULL
  • board_subject — VARCHAR2(100)
  • board_content — VARCHAR2(2000)
  • board_file — VARCHAR2(100)
  • board_re_ref — NUMBER
  • board_re_lev — NUMBER
  • board_re_seq — NUMBER
  • board_count — NUMBER
  • board_date — DATE