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