shopping-mall
Tables (7)
CART (장바구니)
- KEY (id) — Primary key — NOT NULL
CART_PRODUCT (연결테이블2)
- KEY (cart_id) — Foreign key → CART.KEY — NOT NULL
- KEY (product_id) — Foreign key → PRODUCT.KEY — NOT NULL
CATEGORY (카테고리)
- KEY (id) — Primary key — NOT NULL
- 이름 (name) — unique
ORDER (주문)
- KEY (id) — Primary key — NOT NULL
- KEY (user_id) — Foreign key → USER.KEY — NOT NULL
ORDER_PRODUCT (연결테이블)
- KEY (order_id) — Foreign key → ORDER.KEY — NOT NULL
- KEY (product_id) — Foreign key → PRODUCT.KEY — NOT NULL
PRODUCT (상품)
- KEY (id) — Primary key — NOT NULL
- 제목 (title)
- 가격 (price)
- 설명 (description)
- 이미지 (image)
- KEY (category_id) — Foreign key → CATEGORY.KEY — NOT NULL
USER (유저)
- KEY (id) — Primary key — NOT NULL
- 이메일 (email) — unique
- 비밀번호 (password)
- 이름 (name)
- 비밀번호 (role)
- FK (cart_id) — Foreign key → CART.KEY — NOT NULL