쇼핑몰
테이블 (12)
address
- address_id (Key) — NUMBER — 기본 키 — NOT NULL
- memberid — VARCHAR(215)
- address — VARCHAR(2100)
b_qna
- b_no — NUMBER
- b_title — VARCHAR(250)
- b_pwd — NUMBER
- b_writer — VARCHAR(215)
- b_content — VARCHAR(20000)
- b_date — DATE
- b_readcount — NUMBER
- b_category — VARCHAR(250)
- pID — VARCHAR(230)
- lock_flag — CHAR(1)
b_review
- b_no — NUMBER
- pID — VARCHAR(230)
- b_writer — VARCHAR(215)
- b_content — VARCHAR(20000)
- b_original_filename — VARCHAR(2100)
- b_renamed_filename — VARCHAR(2100)
- b_date — DATE
buy
- orderno — NUMBER
- res_name — VARCHAR(220)
- res_address — VARCHAR(2100)
- res_phone — CHAR(11)
- memberid — VARCHAR(215)
- res_requirement — VARCHAR(2100)
- totalprice — NUMBER
- orderdate — DATE
c_qna
- c_no — NUMBER
- c_ref — NUMBER
- c_writer — VARCHAR(215)
- c_comment_date — DATE
- c_content — VARCHAR(20000)
cart
- pID — VARCHAR(230)
- pname — VARCHAR(230)
- amount — NUMBER
- pprice — NUMBER(10)
- Key — NUMBER — 외래 키 → member.Key — NOT NULL
- address_id (Key2) — NUMBER — 외래 키 → member.address_id — NOT NULL
delete_b_qna
- b_title — VARCHAR(250)
- b_pwd — NUMBER
- b_writer — VARCHAR(215)
- b_content — VARCHAR(20000)
- b_date — DATE
- b_readcount — NUMBER
- b_category — VARCHAR(250)
- pID — VARCHAR(230)
- lock_flag — CHAR(1)
- b_no — NUMBER
delete_b_review
- b_writer — VARCHAR(215)
- b_content — VARCHAR(20000)
- b_original_filename — VARCHAR(2100)
- b_renamed_filename — VARCHAR(2100)
- b_date — DATE
- pID — VARCHAR(230)
- b_no — NUMBER
delete_c_qna
- c_writer — VARCHAR(215)
- c_comment_date — DATE
- c_content — VARCHAR(20000)
- c_ref — NUMBER
- c_no — NUMBER
member
- Key — NUMBER — 기본 키 — NOT NULL
- address_id (Key2) — NUMBER — 외래 키 → address.address_id — NOT NULL
- memberid — VARCHAR(215)
- membername — VARCHAR(220)
- gender — CHAR(1)
- age — NUMBER
- email — VARCHAR(230)
- phone — CHAR(11)
- favorite — VARCHAR(250)
- grade — VARCHAR(215)
- enrolldate — DATE
- delflag — CHAR(1)
- deletedate — DATE
- regflag — CHAR(1)
- password — VARCHAR(300)
product
- pID — VARCHAR(230) — 기본 키
- pname — VARCHAR(230)
- price — NUMBER(10)
- pcategory — VARCHAR(230)
- description — VARCHAR(250)
- pcompany — VARCHAR(230)
- pstock — NUMBER
product_io
- ioNo — NUMBER — 기본 키
- pID — VARCHAR(230)
- orderno — NUMBER
- amount — NUMBER
- status — CHAR(1)
- pDate — DATE
- memberid — VARCHAR(215)