쇼핑몰
테이블 (12)
Untitled
- memberid — varchar2(15) — NOT NULL
- address — varchar2(100)
b_qna
- b_no — number — 기본 키 — 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 — 기본 키 — NOT NULL
- pID — varchar2(30) — 외래 키 → 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 — 기본 키 — 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 — 기본 키 — NOT NULL
- c_ref — number — 외래 키 → b_qna.b_no — NOT NULL
- c_writer — varchar2(15)
- c_comment_date — date
- c_content — varchar2(2000)
cart
- pID — varchar2(30) — 외래 키 → 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) — 기본 키 — 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) — 기본 키 — NOT NULL
- pname — varchar2(30)
- pprice — number(10)
- pcategory — varchar2(30)
- description — varchar2(50)
- pcompany — varchar2(30)
- pstock — number
product_io
- iono — number — 기본 키 — NOT NULL
- pID — varchar2(30) — 외래 키 → product.pID — NOT NULL
- orderno — number — 외래 키 → buy.orderno — NOT NULL
- amount — number
- status — varchar2(10)
- pDate — date
- memberid — varchar2(15) — NOT NULL