무임승차

테이블 (14)

action_items

  • id — BIGINT — 기본 키 — NOT NULL
  • meeting_id — BIGINT — 외래 키 → meetings.id — NOT NULL
  • assignee_id — BIGINT — 외래 키 → users.id — NOT NULL
  • description — VARCHAR(1000) — NOT NULL
  • due_date — DATE
  • is_for_next_meeting — BOOLEAN — NOT NULL
  • status — ENUM('todo','in_progress','done','cancelled') — NOT NULL
  • completed_at — DATETIME(3)
  • source — ENUM('manual','ai_extracted') — NOT NULL
  • source_utterance_id — BIGINT — 외래 키 → utterances.id
  • confirmed — BOOLEAN — NOT NULL
  • confirmed_at — DATETIME(3)
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL
  • deleted_at — DATETIME(3)

agendas

  • id — BIGINT — 기본 키 — NOT NULL
  • meeting_id — BIGINT — 외래 키 → meetings.id — NOT NULL
  • milestone_id — BIGINT — 외래 키 → milestones.id — 실제 소요 시간
  • title — VARCHAR(200) — NOT NULL
  • estimated_minutes — INT — NOT NULL
  • order — INT — NOT NULL
  • status — ENUM('pending', 'active', 'done') — NOT NULL
  • started_at_offset_ms — BIGINT — ★ 발화 자동 매칭된 안건
  • ended_at_offset_ms — BIGINT — Moonshine 추론 신뢰도 0.000~1.000 (산출 방식 미확정 — 09)
  • actual_minutes — INT — 예: capture_loss, inference_fail, vad_overrun
  • source — ENUM('ai_recommended', 'manual', 'ad_hoc') — NOT NULL
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL
  • deleted_at — DATETIME(3)

anomaly_events

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • meeting_id — BIGINT — 외래 키 → meetings.id — NOT NULL
  • event_type — VARCHAR(50) — NOT NULL — 발언 안정성
  • severity — ENUM('low', 'medium', 'high') — NOT NULL
  • timestamp_offset_ms — BIGINT — NOT NULL
  • metadata — JSON
  • created_at — DATETIME(3) — NOT NULL

contribution_scores

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • meeting_id — BIGINT — 외래 키 → meetings.id — NOT NULL
  • attendance_ratio — DECIMAL(5, 4) — 마감 준수율
  • punctuality_score — DECIMAL(5, 4) — 종합 점수 (가중 평균)
  • speech_ratio — DECIMAL(5, 4) — 측정 불가로 제외된 지표명 배열
  • speech_consistency — DECIMAL(5, 4)
  • 4) — NULL
  • 4) — NULL
  • 4) — NULL
  • low) — NOT — NOT NULL
  • excluded_indicators — JSON — NOT NULL
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL

decisions

  • id — BIGINT — 기본 키 — NOT NULL
  • meeting_id — BIGINT — 외래 키 → meetings.id — NOT NULL
  • content — VARCHAR(1000) — NOT NULL
  • created_by — BIGINT — 외래 키 → users.id — NOT NULL
  • source — ENUM('manual','ai_extracted') — NOT NULL
  • source_utterance_id — BIGINT — 외래 키 → utterances.id
  • confirmed — BOOLEAN — NOT NULL
  • confirmed_at — DATETIME(3)
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL
  • deleted_at — DATETIME(3)

meetings

  • id — BIGINT — 기본 키 — NOT NULL
  • team_id — BIGINT — 외래 키 → teams.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • scheduled_at — DATETIME — NOT NULL — 연결된 마일스톤 (선택)
  • total_minutes — INT — NOT NULL — T0 기준 시작 오프셋(ms)
  • status — ENUM('scheduled', 'ongoing', 'ended', 'cancelled') — NOT NULL
  • t0_timestamp — DATETIME(3) — T0 기준 종료 오프셋(ms)
  • ended_at — DATETIME(3)
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL
  • deleted_at — DATETIME(3)

milestones

  • id — BIGINT — 기본 키 — NOT NULL
  • project_id — BIGINT — 외래 키 → projects.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • deadline — DATETIME
  • order — INT — NOT NULL
  • progress_ratio — DECIMAL(5, 4) — NOT NULL — 실제 시작 시각 (T0) — 회의 시작 시 발행
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL
  • deleted_at — DATETIME(3)

presence_events

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • meeting_id — BIGINT — NOT NULL
  • event_type — ENUM('join','leave','disconnect','reconnect') — NOT NULL
  • timestamp_offset_ms — BIGINT — NOT NULL
  • reason — ENUM('user_action','network','browser_close','timeout')
  • created_at — DATETIME(3) — NOT NULL

projects

  • id — BIGINT — 기본 키 — NOT NULL
  • team_id — BIGINT — 외래 키 → teams.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • status — ENUM('active','completed','archived') — NOT NULL
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL
  • deleted_at — DATETIME(3)

team_memberships

  • id — BIGINT — 기본 키 — NOT NULL
  • team_id — BIGINT — 외래 키 → teams.id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • role — ENUM('leader','member') — NOT NULL
  • joined_at — DATETIME(3) — NOT NULL
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL
  • deleted_at — DATETIME(3)

team_settings

  • team_id — BIGINT — 외래 키 → teams.id — NOT NULL
  • punctuality_grace_ratio — DECIMAL(4, 3) — NOT NULL — 자리비움 grace (0~300)
  • max_utterance_chars — INT — NOT NULL — 0.0000~1.0000, 하위 안건 완료율로 자동 계산
  • presence_grace_seconds — INT — NOT NULL — 예정 시각
  • absent_meeting_handling — ENUM('include_zero', 'exclude_excused') — NOT NULL
  • deadline_penalty_curve — ENUM('standard', 'strict', 'lenient') — NOT NULL
  • contribution_visibility — ENUM('team', 'self', 'leader') — NOT NULL
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL
  • =팀별 — 기여도

teams

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • course_name — VARCHAR(100) — NOT NULL — 초대 코드 (외부 노출용)
  • invite_code — CHAR(8) — NOT NULL — 허용 지각 비율 (0~0.300)
  • created_by — BIGINT — 외래 키 → users.id — NOT NULL
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL
  • deleted_at — DATETIME(3)
  • =팀 — (=프로젝트 단위

users

  • id — BIGINT — 기본 키 — NOT NULL
  • kakao_id — VARCHAR(64) — NOT NULL — 카카오 OAuth provider user id
  • name — VARCHAR(50) — NOT NULL
  • university — VARCHAR(100) — NOT NULL — 향후 통계용 (02. 기능명세)
  • department — VARCHAR(100) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL
  • deleted_at — DATETIME(3)

utterances

  • id — BIGINT — 기본 키 — NOT NULL
  • meeting_id — BIGINT — 외래 키 → meetings.id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • agenda_id — BIGINT — 외래 키 → agendas.id — 출석 시간 비율 0~1
  • text — TEXT — NOT NULL
  • char_count — INT — NOT NULL
  • confidence — DECIMAL(4, 3) — 정시 도착 0~1
  • started_at_offset_ms — BIGINT — NOT NULL
  • ended_at_offset_ms — BIGINT — NOT NULL
  • created_at — DATETIME(3) — NOT NULL
  • =발화(STT — 결과