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