ewjrik

Tables (12)

Untitled

  • memberid — varchar2(15) — Foreign key — NOT NULL
  • address — varchar2(100)

b_qna

  • b_no — number — Primary key — NOT NULL
  • b_title — varchar2(50)
  • b_pwd — number
  • b_writer — varchar2(15)
  • b_content — varchar2(2000)
  • b_date — date
  • b_readcount — number
  • b_category — varchar2(50)
  • pID — varchar2(30)
  • lock_flag — char(1)

b_review

  • b_no — number — Primary key — NOT NULL
  • pID — varchar2(30) — Foreign key → product.pID — NOT NULL
  • b_writer — varchar2(15)
  • b_content — varchar2(2000)
  • b_original_filename — varchar2(100)
  • b_renamed_filename — varchar2(100)
  • b_date — date

buy

  • orderno — number — Primary key — NOT NULL
  • res_name — varchar2(20)
  • res_address — varchar2(100)
  • res_phone — char(11)
  • memberid — varchar2(15) — NOT NULL
  • res_requirement — varchar2(100)
  • totalprice — number
  • orderdate — date

c_qna

  • c_no — number — Primary key — NOT NULL
  • c_ref — number — Foreign key → b_qna.b_no — NOT NULL
  • c_writer — varchar2(15)
  • c_comment_date — date
  • c_content — varchar2(2000)

cart

  • pID — varchar2(30) — Foreign key → product.pID — NOT NULL
  • pname — varchar2(30)
  • amount — number
  • pprice — number(10)

delete_b_qna

  • b_title — varchar2(50)
  • b_pwd — number
  • b_writer — varchar2(15)
  • b_content — varchar2(2000)
  • b_date — date
  • b_readcount — number
  • b_category — varchar2(50)
  • pID — varchar2(30)
  • lock_flag — char(1)
  • b_no — number

delete_b_review

  • b_writer — varchar2(15)
  • b_content — varchar2(2000)
  • b_original_filename — varchar2(100)
  • b_renamed_filename — varchar2(100)
  • b_date — date
  • pID — varchar2(30)
  • b_no — number

delete_c_qna

  • c_writer — varchar2(15)
  • c_comment_date — date
  • c_content — varchar2(2000)
  • c_ref — number
  • c_no — number

member

  • memberid — varchar2(15) — Primary key — NOT NULL
  • membername — varchar2(20)
  • gender — char(1)
  • age — number
  • email — varchar2(30)
  • phone — char(11)
  • favorite — varchar2(50)
  • grade — varchar2(15)
  • enrolldate — date
  • delflag — char(1)
  • deletedate — date
  • regflag — char(1)
  • password — varchar2(300)

product

  • pID — varchar2(30) — Primary key — NOT NULL
  • pname — varchar2(30)
  • pprice — number(10)
  • pcategory — varchar2(30)
  • description — varchar2(50)
  • pcompany — varchar2(30)
  • pstock — number

product_io

  • iono — number — Primary key — NOT NULL
  • pID — varchar2(30) — Foreign key → product.pID — NOT NULL
  • orderno — number — Foreign key → buy.orderno — NOT NULL
  • amount — number
  • status — varchar2(10)
  • pDate — date
  • memberid — varchar2(15) — NOT NULL