쇼핑몰
테이블 (6)
BASKET
- b_num — INT — 기본 키 — NOT NULL
- id — VARCHAR(50) — 외래 키 → MEMBER.id — NOT NULL
- p_num — INT — 외래 키 → PRODUCT.p_num — NOT NULL
- b_quantity — INT — NOT NULL
- b_rgst_date — DATE — NOT NULL
MEMBER
- id — VARCHAR(50) — 기본 키 — NOT NULL
- pw — VARCHAR(50) — NOT NULL
- name — VARCHAR(20) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- address — VARCHAR(200) — NOT NULL
- cp — INT — NOT NULL
- admin — CHAR — NOT NULL
- del — CHAR — NOT NULL
- rgst_date — DATE — NOT NULL
ORDERS
- o_num — INT — 기본 키 — NOT NULL
- id — VARCHAR(50) — 외래 키 → MEMBER.id — NOT NULL
- o_rgst_date — DATE — NOT NULL
ORDER_DETAIL
- od_num — INT — 기본 키 — NOT NULL
- o_num — INT — 외래 키 → ORDERS.o_num — NOT NULL
- p_num — INT — 외래 키 → PRODUCT.p_num — NOT NULL
- od_quantity — INT — NOT NULL
- od_result — CHAR — NOT NULL
PRODUCT
- p_num — INT — 기본 키 — NOT NULL
- p_name — VARCHAR(100) — NOT NULL
- p_category — CHAR — NOT NULL
- p_cost — INT — NOT NULL
- p_price — INT — NOT NULL
- p_con — VARCHAR(3000) — NOT NULL
- p_image — VARCHAR(3000) — NOT NULL
- p_view_count — INT — NOT NULL
- p_delete — CHAR — NOT NULL
- p_rgst_date — DATE — NOT NULL
REVIEW
- r_num — INT — 기본 키 — NOT NULL
- id — VARCHAR(50) — 외래 키 → MEMBER.id — NOT NULL
- od_num — INT — 외래 키 → ORDER_DETAIL.od_num — NOT NULL
- r_title — VARCHAR(100) — NOT NULL
- r_content — VARCHAR(3000) — NOT NULL
- r_image — VARCHAR(3000) — NOT NULL
- r_starrate — INT — NOT NULL
- r_delete — CHAR — NOT NULL
- r_rgst_date — DATE — NOT NULL