쇼핑몰ERD
테이블 (6)
big_category
- categoryNum — int — 기본 키 — NOT NULL
- categoryName — varchar(20) — NOT NULL
cart
- cart_id — int — 기본 키 — NOT NULL
- product_id — int — 외래 키 → product.product_id — NOT NULL
- product_cnt — int — NOT NULL
- user_id — varchar(20) — NOT NULL
category
- categoryNum — int — 기본 키 — NOT NULL
- categoryDetail — varchar(20) — NOT NULL
- bigCategoryNum — int — 외래 키 → big_category.categoryNum — NOT NULL
order1
- order_id — int — 기본 키 — NOT NULL
- user_id — varchar(20) — NOT NULL
- order_date — datetime — NOT NULL
- receiver_name — varchar(20) — NOT NULL
- receiver_phone — varchar(20) — NOT NULL
- receiver_id — varchar(100) — NOT NULL
- addr1 — varchar(100) — NOT NULL
- addr2 — varchar(100) — NOT NULL
- addr3 — varchar(100) — NOT NULL
- total_price — int — NOT NULL
order_detail
- order_id — int — 외래 키 → order1.order_id — NOT NULL
- product_id — int — 외래 키 → product.product_id — NOT NULL
- ordered_cnt — int — NOT NULL
- order_status — varchar(10) — NOT NULL
- refundCheck_YN — varchar(1) — NOT NULL
product
- product_id — int — 기본 키 — NOT NULL
- product_name — varchar(100) — NOT NULL
- product_price — int — NOT NULL
- category1 — int — NOT NULL
- category2 — int — 외래 키 → category.categoryNum — NOT NULL
- detail — int — NOT NULL
- product_img — varchar(500) — NOT NULL
- product_cnt — int — NOT NULL