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