포트폴리오용
테이블 (7)
cart
- cart_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → user.user_id — NOT NULL
- product_id — INT — 외래 키 → product.product_id — NOT NULL
category
- category_id — INT — 기본 키 — NOT NULL
- name — VARCHAR(30) — NOT NULL
product
- product_id — INT — 기본 키 — NOT NULL
- category_id — INT — 외래 키 → category.category_id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- detail — VARCHAR(1000)
- price — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- is_delelted (is_deleted) — BOOLEAN
product_image
- product_image_id — INT — 기본 키 — NOT NULL
- product_id — INT — 외래 키 → product.product_id — NOT NULL
- image_url — VARCHAR(100)
- display_order — INT — NOT NULL
- is_thumbnail — BOOLEAN — NOT NULL
purchase_history
- history_id (Key) — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → user.user_id — NOT NULL
- product_id — INT — 외래 키 → product.product_id — NOT NULL
- price (Field) — INT
- bought_at (Field2) — TIMESTAMP
- imp_uid (Field3) — VARCHAR(30)
user
- user_id — INT — 기본 키 — NOT NULL
- login_id — VARCHAR(15) — NOT NULL
- password — VARCHAR(150) — NOT NULL
- name — VARCHAR(15) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- email — VARCHAR(50) — NOT NULL
- role — ENUM('ROLE_USER', 'ROLE_ADMIN') — NOT NULL
- is_withdraw — BOOLEAN — NOT NULL
wishlist
- wishlist_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → user.user_id — NOT NULL
- product_id — INT — 외래 키 → product.product_id — NOT NULL
- is_wishlisted — BOOLEAN — NOT NULL