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
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)