project

Tables (8)

Cart

  • cno — number
  • mno — number
  • pno — number
  • c_count — number(10)
  • c_price — number(10)

board

  • bno — number
  • mno — number
  • b_content — varchar2(4000)
  • b_title — varchar(2)
  • del — char(1)

buy

  • bno — number
  • mno — number
  • reg_date — date

buylist

  • pno — number
  • bno — number

like

  • mno — number
  • pno — number
  • del — char(1)

member

  • mno — number
  • id — varchar2(20)
  • password — varchar(20)
  • name — varchar2(20)
  • tel — char(13)
  • gender — varchar2(2)
  • addr — varchar(20)
  • addr_detail — varchar2(20)
  • reg_date — date
  • profile — varchar2(20)
  • del — char(1)

product

  • 상품번호 (pno) — number
  • 상품명 (pname) — varchar2(20)
  • 상품가격 (p_price) — number(6)
  • 원산지 (p_country) — varchar(20)
  • 판매처 (p_tel) — varchar(20)
  • 상세이미지 (detail_img) — blob
  • 상세내용 (detail_content) — varchar2(1000)
  • 할인율 (discount) — number(2,0)
  • 댓글 (tag) — varchar2(10)
  • 상품삭제 (del) — char(1)

review

  • rno — number
  • mno — number
  • pno — number
  • star_rate — number(1,1)
  • r_content — varchar(20)
  • r_date — date
  • r_del — char(1)