ShiftRhythm

Tables (21)

chat_message_feedbacks (메시지피드백)

  • id — BIGINT — Primary key — NOT NULL
  • message_id — BIGINT — Foreign key → chat_messages.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • feedback — VARCHAR(20) — NOT NULL — LIKE / DISLIKE
  • created_at — DATETIME — NOT NULL

chat_messages (챗메시지)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • role — VARCHAR(20) — NOT NULL — USER / ASSISTANT
  • content — TEXT — NOT NULL
  • context_snapshot — JSON — 답변 근거(다음 근무까지 남은 시간, 카페인 컷오프 등)
  • safety_flag — VARCHAR(30) — NOT NULL — NONE / MEDICAL_REFERRAL / EMERGENCY
  • created_at — DATETIME — NOT NULL

coaching_cards (코칭카드)

  • id — BIGINT — Primary key — NOT NULL
  • daily_coaching_id — BIGINT — Foreign key → daily_coachings.id — NOT NULL
  • card_type — VARCHAR(30) — NOT NULL — LIGHT_EXPOSURE / CAFFEINE_CUTOFF / NAP
  • title — VARCHAR(100) — NOT NULL
  • window_start — DATETIME — NOT NULL — 권장 시간 창 시작
  • window_end — DATETIME — NOT NULL — 권장 시간 창 종료
  • description — TEXT
  • rationale — TEXT — 왜 이 시간인가 근거 설명
  • order_no — INT — NOT NULL

content_favorites (콘텐츠즐겨찾기)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • content_id — BIGINT — Foreign key → nutrition_contents.id — NOT NULL
  • created_at — DATETIME — NOT NULL

daily_coachings (일일코칭)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • coaching_date — DATE — NOT NULL
  • today_shift_type — VARCHAR(20) — NOT NULL
  • next_shift_start_at — DATETIME — 다음 근무 시작 시각
  • is_transition_day — BOOLEAN — NOT NULL
  • generated_at — DATETIME — NOT NULL

daily_summaries (일일요약)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • summary_date — DATE — NOT NULL
  • total_count — INT — NOT NULL
  • done_count — INT — NOT NULL
  • skipped_count — INT — NOT NULL
  • completion_rate — DECIMAL(4, 3) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

nap_sessions (낮잠세션)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • planned_minutes — INT — NOT NULL — 설정한 낮잠 길이(분)
  • started_at — DATETIME — NOT NULL
  • ended_at — DATETIME
  • status — VARCHAR(20) — NOT NULL — RUNNING / COMPLETED / CANCELED
  • created_at — DATETIME — NOT NULL

notification_settings (알림설정)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • type — VARCHAR(30) — NOT NULL — NAP / CAFFEINE_CUTOFF / LIGHT_EXPOSURE
  • enabled — BOOLEAN — NOT NULL
  • custom_time — TIME — NULL이면 일정 기반 자동 제안 시각 사용
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

nutrition_contents (영양콘텐츠)

  • id — BIGINT — Primary key — NOT NULL
  • content_type — VARCHAR(30) — NOT NULL — NUTRITION_INFO / RECIPE
  • timing_tag — VARCHAR(30) — NOT NULL — BEFORE_NIGHT / DURING_NIGHT / AFTER_NIGHT / GENERAL
  • title — VARCHAR(150) — NOT NULL
  • summary — TEXT
  • body — TEXT
  • source_url — VARCHAR(500) — 정보 출처
  • disclaimer — TEXT — 효능 단정 금지 및 주의사항 문구
  • thumbnail_url — VARCHAR(500)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

ocr_shift_drafts (OCR인식초안)

  • id — BIGINT — Primary key — NOT NULL
  • upload_id — BIGINT — Foreign key → schedule_uploads.id — NOT NULL
  • work_date — DATE — NOT NULL
  • shift_type — VARCHAR(20) — NOT NULL — DAY / EVENING / NIGHT / OFF
  • confidence — DECIMAL(4, 3) — 인식 신뢰도 0.000~1.000
  • is_uncertain — BOOLEAN — NOT NULL — 사용자 확인 필요 여부
  • is_reviewed — BOOLEAN — NOT NULL — 사용자 보정 완료 여부
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

refresh_tokens (리프레시 토큰)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • token_hash — VARCHAR(255) — NOT NULL — 해시된 리프레시 토큰
  • expires_at — DATETIME — NOT NULL
  • revoked_at — DATETIME
  • created_at — DATETIME — NOT NULL

routine_tasks (루틴항목)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • task_date — DATE — NOT NULL
  • source_type — VARCHAR(20) — NOT NULL — COACHING / TRANSITION
  • source_id — BIGINT — coaching_cards.id 또는 transition_protocol_steps.id (논리 참조)
  • category — VARCHAR(30) — NOT NULL — NAP / CAFFEINE_CUTOFF / LIGHT / SLEEP / MEAL
  • title — VARCHAR(100) — NOT NULL
  • tip — TEXT — 간단 실행 팁
  • window_start — DATETIME
  • window_end — DATETIME
  • status — VARCHAR(20) — NOT NULL — PENDING / DONE / SKIPPED
  • completed_at — DATETIME
  • order_no — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

schedule_uploads (근무표업로드)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL — 업로드 이미지 저장 경로
  • status — VARCHAR(20) — NOT NULL — PENDING / PROCESSING / SUCCEEDED / PARTIAL / FAILED
  • ocr_raw_result — JSON — OCR 원본 응답
  • recognized_count — INT — NOT NULL — 인식된 날짜 수
  • uncertain_count — INT — NOT NULL — 불확실 항목 수
  • retry_count — INT — NOT NULL — 동일 이미지 재처리 횟수
  • fail_reason — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • completed_at — DATETIME

shift_patterns (반복근무패턴)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • name — VARCHAR(50) — NOT NULL — 패턴 이름
  • cycle_days — INT — NOT NULL — 반복 주기(일)
  • pattern — JSON — NOT NULL — "DAY","DAY","NIGHT","OFF" 형태
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

shift_schedules (근무일정)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • work_date — DATE — NOT NULL
  • shift_type — VARCHAR(20) — NOT NULL — DAY / EVENING / NIGHT / OFF
  • start_time — TIME
  • end_time — TIME
  • source — VARCHAR(20) — NOT NULL — OCR / MANUAL / PATTERN
  • confidence — DECIMAL(4, 3)
  • confirmed — BOOLEAN — NOT NULL — 사용자 확인 완료 여부
  • upload_id — BIGINT — Foreign key → schedule_uploads.id — 어떤 업로드에서 확정됐는지
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

transition_protocol_steps (전환프로토콜단계)

  • id — BIGINT — Primary key — NOT NULL
  • protocol_id — BIGINT — Foreign key → transition_protocols.id — NOT NULL
  • phase — VARCHAR(20) — NOT NULL — PREV_DAY / D_DAY / NEXT_DAY
  • category — VARCHAR(20) — NOT NULL — SLEEP / NAP / LIGHT / MEAL
  • order_no — INT — NOT NULL
  • window_start — TIME
  • window_end — TIME
  • action_text — TEXT — NOT NULL — 권장 행동 문구

transition_protocols (전환프로토콜)

  • id — BIGINT — Primary key — NOT NULL
  • from_shift_type — VARCHAR(20) — NOT NULL
  • to_shift_type — VARCHAR(20) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • created_at — DATETIME — NOT NULL

user_settings

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • caffeine_daily_mg — INT — 평소 일일 카페인 섭취량(mg)
  • caffeine_sensitivity — VARCHAR(20) — LOW / MEDIUM / HIGH
  • preferred_nap_minutes — INT — NOT NULL — 선호 낮잠 길이(분)
  • max_naps_per_day — INT — NOT NULL — 하루 최대 낮잠 횟수
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_streaks (연속기록)

  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • current_streak — INT — NOT NULL
  • longest_streak — INT — NOT NULL
  • last_checkin_date — DATE
  • updated_at — DATETIME — NOT NULL

user_transitions (회원의 근무유형전환일)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • protocol_id — BIGINT — Foreign key → transition_protocols.id — NOT NULL
  • transition_date — DATE — NOT NULL — 전환일
  • from_shift_type — VARCHAR(20) — NOT NULL
  • to_shift_type — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

users (회원)

  • id — BIGINT — Primary key — NOT NULL — 사용자 ID
  • google_sub — VARCHAR(64) — NOT NULL — 구글 계정 고유 식별자
  • email — VARCHAR(255) — NOT NULL — 이메일
  • nickname — VARCHAR(50) — NOT NULL — 닉네임
  • profile_image_url — VARCHAR(500) — 프로필 이미지 URL
  • timezone — VARCHAR(50) — NOT NULL — 타임존
  • status — VARCHAR(20) — NOT NULL — ACTIVE / WITHDRAWN
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME — 탈퇴 시각