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 — 탈퇴 시각