쇼핑몰

테이블 (12)

address

  • address_id (Key) — NUMBER — 기본 키 — NOT NULL
  • memberid — VARCHAR(215)
  • address — VARCHAR(2100)

b_qna

  • b_no — NUMBER
  • b_title — VARCHAR(250)
  • b_pwd — NUMBER
  • b_writer — VARCHAR(215)
  • b_content — VARCHAR(20000)
  • b_date — DATE
  • b_readcount — NUMBER
  • b_category — VARCHAR(250)
  • pID — VARCHAR(230)
  • lock_flag — CHAR(1)

b_review

  • b_no — NUMBER
  • pID — VARCHAR(230)
  • b_writer — VARCHAR(215)
  • b_content — VARCHAR(20000)
  • b_original_filename — VARCHAR(2100)
  • b_renamed_filename — VARCHAR(2100)
  • b_date — DATE

buy

  • orderno — NUMBER
  • res_name — VARCHAR(220)
  • res_address — VARCHAR(2100)
  • res_phone — CHAR(11)
  • memberid — VARCHAR(215)
  • res_requirement — VARCHAR(2100)
  • totalprice — NUMBER
  • orderdate — DATE

c_qna

  • c_no — NUMBER
  • c_ref — NUMBER
  • c_writer — VARCHAR(215)
  • c_comment_date — DATE
  • c_content — VARCHAR(20000)

cart

  • pID — VARCHAR(230)
  • pname — VARCHAR(230)
  • amount — NUMBER
  • pprice — NUMBER(10)
  • Key — NUMBER — 외래 키 → member.Key — NOT NULL
  • address_id (Key2) — NUMBER — 외래 키 → member.address_id — NOT NULL

delete_b_qna

  • b_title — VARCHAR(250)
  • b_pwd — NUMBER
  • b_writer — VARCHAR(215)
  • b_content — VARCHAR(20000)
  • b_date — DATE
  • b_readcount — NUMBER
  • b_category — VARCHAR(250)
  • pID — VARCHAR(230)
  • lock_flag — CHAR(1)
  • b_no — NUMBER

delete_b_review

  • b_writer — VARCHAR(215)
  • b_content — VARCHAR(20000)
  • b_original_filename — VARCHAR(2100)
  • b_renamed_filename — VARCHAR(2100)
  • b_date — DATE
  • pID — VARCHAR(230)
  • b_no — NUMBER

delete_c_qna

  • c_writer — VARCHAR(215)
  • c_comment_date — DATE
  • c_content — VARCHAR(20000)
  • c_ref — NUMBER
  • c_no — NUMBER

member

  • Key — NUMBER — 기본 키 — NOT NULL
  • address_id (Key2) — NUMBER — 외래 키 → address.address_id — NOT NULL
  • memberid — VARCHAR(215)
  • membername — VARCHAR(220)
  • gender — CHAR(1)
  • age — NUMBER
  • email — VARCHAR(230)
  • phone — CHAR(11)
  • favorite — VARCHAR(250)
  • grade — VARCHAR(215)
  • enrolldate — DATE
  • delflag — CHAR(1)
  • deletedate — DATE
  • regflag — CHAR(1)
  • password — VARCHAR(300)

product

  • pID — VARCHAR(230) — 기본 키
  • pname — VARCHAR(230)
  • price — NUMBER(10)
  • pcategory — VARCHAR(230)
  • description — VARCHAR(250)
  • pcompany — VARCHAR(230)
  • pstock — NUMBER

product_io

  • ioNo — NUMBER — 기본 키
  • pID — VARCHAR(230)
  • orderno — NUMBER
  • amount — NUMBER
  • status — CHAR(1)
  • pDate — DATE
  • memberid — VARCHAR(215)