HueCamping

Tables (14)

Replynotice

  • reply_no — number(38) — Primary key
  • board_no — number(38)
  • reply_name — varchar2(30) — NOT NULL
  • reply_title — varchar2(200) — NOT NULL
  • reply_pwd — varchar2(20) — NOT NULL
  • reply_cont — varchar2(4000) — NOT NULL
  • reply_hit — number(38)
  • reply_ref — number(38)
  • reply_step — number(38)
  • reply_level — number(38)
  • reply_date — date

ReplyproductQnA

  • reply_no — number(38) — Primary key
  • board_no — number(38)
  • reply_name — varchar2(30) — NOT NULL
  • reply_title — varchar2(200) — NOT NULL
  • reply_pwd — varchar2(20) — NOT NULL
  • reply_cont — varchar2(4000) — NOT NULL
  • reply_hit — number(38)
  • reply_ref — number(38)
  • reply_step — number(38)
  • reply_level — number(38)
  • reply_date — date

bigcategory

  • no — number — Primary key — NOT NULL
  • name — varchar2(50) — NOT NULL
  • step — number — NOT NULL

cart

  • no — number — Primary key
  • mno — number
  • pno — number
  • opname — varchar2(40)
  • qty — number — NOT NULL

member

  • no — number — Primary key — NOT NULL
  • id — varchar2(40) — NOT NULL
  • password — varchar2(30) — NOT NULL
  • name — varchar2(30) — NOT NULL
  • zip — varchar2(20)
  • addr1 — varchar2(50)
  • addr2 — varchar2(50)
  • mobile1 — varchar2(30)
  • mobile2 — varchar2(30)
  • mobile3 — varchar2(30)
  • email — varchar2(50)
  • gender — varchar2(10)
  • state — int — NOT NULL
  • memdate — date
  • deldate — date
  • delcont — varchar2(4000)

notice

  • board_no — number(38) — Primary key
  • board_name — varchar2(30) — NOT NULL
  • board_title — varchar2(200) — NOT NULL
  • board_pwd — varchar2(20) — NOT NULL
  • board_cont — varchar2(4000) — NOT NULL
  • board_hit — number(38)
  • board_ref — number(38)
  • board_step — number(38)
  • board_level — number(38)
  • board_date — date

orderlist

  • no — number — Primary key
  • mno — number
  • pno — number
  • opname — varchar2(40)
  • qty — number
  • price — number
  • time — date
  • receiver — varchar(40)
  • rv_hp1 — varchar2(30)
  • rv_hp2 — varchar2(30)
  • rv_hp3 — varchar2(30)
  • rv_zip — varchar2(20)
  • rv_addr1 — varchar2(50)
  • rv_addr2 — varchar2(50)

product

  • no — number — Primary key — NOT NULL
  • lcno — number — NOT NULL
  • scno — number
  • name — varchar2(100) — NOT NULL
  • oriprice — number
  • discprice — number
  • info — varchar2(400)
  • mainImgN — varchar2(30)
  • detailImgN1 — varchar2(30)
  • detailImgN2 — varchar2(30)
  • detailImgN3 — varchar2(30)
  • detailImgN4 — varchar2(30)

productQnA

  • board_no — number(38) — Primary key
  • board_name — varchar2(30) — NOT NULL
  • board_title — varchar2(200) — NOT NULL
  • board_pwd — varchar2(20) — NOT NULL
  • board_cont — varchar2(4000) — NOT NULL
  • board_hit — number(38)
  • board_ref — number(38)
  • board_step — number(38)
  • board_level — number(38)
  • board_date — date

review

  • board_no — number(38) — Primary key
  • board_name — varchar2(30) — NOT NULL
  • board_title — varchar2(200) — NOT NULL
  • board_pwd — varchar2(20) — NOT NULL
  • board_cont — varchar2(4000) — NOT NULL
  • board_hit — number(38)
  • board_ref — number(38)
  • board_step — number(38)
  • board_level — number(38)
  • board_date — date
  • board_file1 — varchar2(150)

reviewReply

  • reply_no — number(38) — Primary key
  • board_no — number(38)
  • reply_name — varchar2(30) — NOT NULL
  • reply_title — varchar2(200) — NOT NULL
  • reply_pwd — varchar2(20) — NOT NULL
  • reply_cont — varchar2(4000) — NOT NULL
  • reply_hit — number(38)
  • reply_ref — number(38)
  • reply_step — number(38)
  • reply_level — number(38)
  • reply_date — date

smallcategory

  • no — number — Primary key — NOT NULL
  • name — varchar2(50) — NOT NULL
  • step — number — NOT NULL
  • lcno — number

stock

  • no — number — Primary key — NOT NULL
  • pno — number
  • opname — varchar2(20) — NOT NULL
  • count — number
  • no (no2) — number — Foreign key → product.no — NOT NULL

wishlist

  • no — number — Primary key
  • mno — number
  • pno — number
  • opname — varchar2(40)
  • qty — number — NOT NULL