demo00001
Tables (15)
brand
- brand_id — BIGINT
- brand_name — VARCHAR(50) — NOT NULL
- brand_like_count — BIGINT — Redis 동기화용 캐시 컬럼
brand_like
- member_id — BIGINT — Primary key — NOT NULL
- brand_id — BIGINT — Primary key — NOT NULL
- created_at — TIMESTAMP
cart
- cart_id — BIGINT
- member_id — BIGINT — NOT NULL
- product_option_id — BIGINT — NOT NULL
- count — INT
- updated_at — TIMESTAMP
delivery
- delivery_id — BIGINT
- ordered_product_id — BIGINT — NOT NULL
- tracking_number — VARCHAR(50) — 운송장 번호
- delivery_company — VARCHAR(20)
delivery_address
- delivery_address_id — BIGINT
- member_id — BIGINT — NOT NULL
- receiver_name — VARCHAR(20) — NOT NULL
- receiver_phone — VARCHAR(15) — NOT NULL
- receiver_address — VARCHAR(255) — NOT NULL
- is_default — TINYINT(1) — 기본 배송지 여부 (1:True)
history
- history_id — BIGINT
- ordered_product_id — BIGINT — NOT NULL
- previous_status — VARCHAR(20)
- new_status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP
member
- member_id — BIGINT
- email — VARCHAR(50) — NOT NULL — 로그인 ID 겸용 (유니크)
- password — VARCHAR(128) — Bcrypt 암호화 (소셜로그인 시 NULL)
- name — VARCHAR(20) — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- phone — VARCHAR(15) — NOT NULL
- profile_image — VARCHAR(2083) — 프로필 이미지 URL
- role — VARCHAR(20) — USER, ADMIN, PARTNER
- provider_type — VARCHAR(20) — NONE, KAKAO, GOOGLE, APPLE
- provider_id — VARCHAR(100) — 소셜 서비스 식별자
- status — VARCHAR(20) — ACTIVE, INACTIVE, WITHDRAWN, BANNED
- withdrawn_at — TIMESTAMP — 탈퇴 요청 일시 (30일 뒤 삭제)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
ordered_product
- ordered_product_id — BIGINT
- order_id — BIGINT — NOT NULL
- product_option_id — BIGINT — NOT NULL
- quantity — INT — NOT NULL
- piece_price — BIGINT — NOT NULL — 구매 시점 단가
- product_name_snapshot — VARCHAR(100) — NOT NULL
- option_name_snapshot — VARCHAR(50) — NOT NULL
- status — VARCHAR(20) — ORDERED, CANCELED, DELIVERING...
orders
- order_id — BIGINT
- member_id — BIGINT — 탈퇴 시 NULL 처리 (이력 보존)
- order_no — VARCHAR(50) — NOT NULL — 주문번호 (UUID 등)
- receiver_name — VARCHAR(20) — NOT NULL
- receiver_phone — VARCHAR(15) — NOT NULL
- receiver_address — VARCHAR(255) — NOT NULL
- status — VARCHAR(20) — 전체 주문 상태
- ordered_at — TIMESTAMP
product
- product_id — BIGINT
- brand_id — BIGINT — NOT NULL
- product_name — VARCHAR(100) — NOT NULL
- category — VARCHAR(20) — NOT NULL — Enum 관리 (TOP, OUTER...)
- subcategory — VARCHAR(20)
- original_price — BIGINT — NOT NULL
- thumbnail_image_url — VARCHAR(2083)
- product_like_count — BIGINT — Redis 동기화용
- view_count — BIGINT — Redis 동기화용
- is_deleted — TINYINT(1) — Soft Delete
- deleted_at — TIMESTAMP
- created_at — TIMESTAMP
product_image
- product_image_id — BIGINT
- product_id — BIGINT — NOT NULL
- image_url — VARCHAR(2083) — NOT NULL
- display_order — INT — 이미지 노출 순서
product_like
- member_id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — Primary key — NOT NULL
- created_at — TIMESTAMP
product_option
- product_option_id — BIGINT
- product_id — BIGINT — NOT NULL
- option_name — VARCHAR(50) — NOT NULL — Color / Size 조합
- stock — INT
- version — BIGINT — 낙관적 락(Optimistic Lock) 버전
- is_deleted — TINYINT(1)
receipt
- receipt_id — BIGINT
- order_id — BIGINT — NOT NULL
- total_amount — BIGINT — NOT NULL — 최종 결제 금액
- payment_method — VARCHAR(20) — NOT NULL — CARD, TRANSFER...
- paid_at — TIMESTAMP
search_history
- search_id — BIGINT
- member_id — BIGINT — 비회원 검색 고려
- search_word — VARCHAR(100) — NOT NULL
- searched_at — TIMESTAMP