example

Tables (19)

ai_cache

  • id — BIGINT — Primary key — NOT NULL
  • cache_key — CHAR(64) — NOT NULL — 프롬프트의 SHA-256. 원문을 키로 쓰면 인덱스 길이 제한에 걸림
  • kind — VARCHAR(30) — NOT NULL — RECOMMEND_REASON · STORY
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

charm

  • id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL — munich-2025
  • name — VARCHAR(100) — NOT NULL — 뮌헨 아틀리에 에디션
  • edition — VARCHAR(50)
  • image_key — VARCHAR(200)
  • store_only — BOOLEAN — NOT NULL — 매장에서만 수령. 기본값 true를 바꾸지 말 것
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

charm_grant

  • id — BIGINT — Primary key — NOT NULL
  • guest_id — BIGINT — Foreign key → guest.id — NOT NULL
  • charm_id — BIGINT — Foreign key → charm.id — NOT NULL
  • story_chapter_id — BIGINT — Foreign key → story_chapter.id — 어느 챕터 완료로 얻었는지
  • status — VARCHAR(20) — NOT NULL — GRANTED · REDEEMED
  • granted_at — DATETIME — NOT NULL
  • redeemed_at — DATETIME
  • redeemed_store_id — BIGINT — Foreign key → store.id
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

companion

  • id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → product.id — NOT NULL — UNIQUE로 1:1 강제
  • companion_def_id — BIGINT — Foreign key → companion_def.id — NOT NULL
  • born_at — DATETIME — NOT NULL — "함께한 412일" 계산 기준
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

companion_def

  • id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL — leo-winter-seoul
  • name — VARCHAR(50) — NOT NULL — 레오
  • season — VARCHAR(20) — NOT NULL — SPRING · SUMMER · AUTUMN · WINTER
  • region — VARCHAR(30) — NOT NULL — seoul · munich
  • image_key — VARCHAR(200) — S3 assets 버킷 키
  • persona_prompt — TEXT — LLM 말투 지시문
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

guest

  • id — BIGINT — Primary key — NOT NULL — FK가 참조하는 내부 키
  • token — CHAR(36) — NOT NULL — 쿠키(gid)에 담기는 값. 추측 불가해야 함
  • member_id — BIGINT — Foreign key → member.id — 로그인 시 채움 = 승계. 이 한 줄이 승계의 전부
  • linked_at — DATETIME — 승계 시각
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

inspection

  • id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → product.id — NOT NULL
  • guest_id — BIGINT — Foreign key → guest.id — NOT NULL
  • s3_key — VARCHAR(300) — NOT NULL — private 버킷. 30일 후 수명주기로 자동 삭제
  • status — VARCHAR(20) — NOT NULL — PENDING · DONE · FAILED
  • observation — TEXT — 모서리 가죽이 조금 건조해 보여요
  • care_items — JSON — 권장 케어 3개. 검색 대상이 아닌 표시 전용이라 JSON
  • needs_atelier — BOOLEAN — NOT NULL
  • completed_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

member

  • id — BIGINT — Primary key — NOT NULL
  • kakao_id — VARCHAR(50) — 카카오 회원번호. 이메일은 수집하지 않음
  • nickname — VARCHAR(50) — 카카오 닉네임
  • withdrawn_at — DATETIME — 탈퇴 시각. 탈퇴 시 kakao_id·nickname을 비움(익명화)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

product

  • id — BIGINT — Primary key — NOT NULL
  • product_model_id — BIGINT — Foreign key → product_model.id — NOT NULL
  • serial_no — VARCHAR(20) — NOT NULL — 0187
  • made_ym — CHAR(7) — 2025-05
  • atelier — VARCHAR(50) — 뮌헨 아틀리에
  • owner_guest_id — BIGINT — Foreign key → guest.id — NULL = 주인 없음 → 제품 여권(S2)로 분기
  • is_display — BOOLEAN — NOT NULL — true = 매장 진열품 → 미리보기(S14)로 분기
  • registered_at — DATETIME — CTA를 눌러 소유를 확정한 시각. 태그만으로는 안 채워짐
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

product_model

  • id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL — stark-backpack
  • name — VARCHAR(100) — NOT NULL — Stark Backpack
  • category — VARCHAR(30) — NOT NULL — BAG · WALLET · CHARM
  • material — VARCHAR(100) — Visetos 코팅 캔버스
  • image_key — VARCHAR(200) — S3 assets 버킷 키
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

product_ownership_log

  • id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → product.id — NOT NULL
  • guest_id — BIGINT — Foreign key → guest.id — NULL이면 소유 해제
  • created_at — DATETIME — NOT NULL

store

  • id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(30) — NOT NULL — cheongdam-haus
  • name — VARCHAR(100) — NOT NULL — 청담 MCM HAUS
  • address — VARCHAR(200)
  • lat — DECIMAL(10, 7)
  • lng — DECIMAL(10, 7)
  • phone — VARCHAR(20)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

store_visit

  • id — BIGINT — Primary key — NOT NULL
  • guest_id — BIGINT — Foreign key → guest.id — NOT NULL
  • store_id — BIGINT — Foreign key → store.id — NOT NULL
  • visited_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL

story_chapter

  • id — BIGINT — Primary key — NOT NULL
  • season — VARCHAR(20) — NOT NULL
  • chapter_no — INT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • summary — VARCHAR(300)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

story_choice

  • id — BIGINT — Primary key — NOT NULL
  • story_scene_id — BIGINT — Foreign key → story_scene.id — NOT NULL
  • choice_no — INT — NOT NULL
  • text — VARCHAR(200) — NOT NULL
  • trait_tag — VARCHAR(30) — 취향 태그. 집계 대상이라 JSON이 아닌 컬럼
  • next_scene_id — BIGINT — Foreign key → story_scene.id — NULL이면 순차 진행
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

story_choice_log

  • id — BIGINT — Primary key — NOT NULL
  • guest_id — BIGINT — Foreign key → guest.id — NOT NULL
  • story_choice_id — BIGINT — Foreign key → story_choice.id — NOT NULL
  • created_at — DATETIME — NOT NULL

story_progress

  • id — BIGINT — Primary key — NOT NULL
  • guest_id — BIGINT — Foreign key → guest.id — NOT NULL
  • story_chapter_id — BIGINT — Foreign key → story_chapter.id — NOT NULL
  • current_scene_id — BIGINT — Foreign key → story_scene.id
  • completed_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

story_scene

  • id — BIGINT — Primary key — NOT NULL
  • story_chapter_id — BIGINT — Foreign key → story_chapter.id — NOT NULL
  • scene_no — INT — NOT NULL
  • bg_image_key — VARCHAR(200)
  • line — TEXT — NOT NULL — 캐릭터 대사
  • is_last — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

tag

  • id — BIGINT — Primary key — NOT NULL
  • tag_code — VARCHAR(20) — NOT NULL — URL의 /t/{여기}
  • type — VARCHAR(20) — NOT NULL — PRODUCT · STORE
  • product_id — BIGINT — Foreign key → product.id — type=PRODUCT일 때
  • store_id — BIGINT — Foreign key → store.id — type=STORE일 때
  • is_active — BOOLEAN — NOT NULL — 사고 시 즉시 차단용
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL