wkdb

Tables (29)

activities

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → projects.id — NOT NULL
  • actor_id — BIGINT — Foreign key → users.id — NOT NULL
  • type — VARCHAR(50) — NOT NULL — 업무 변경/GitHub/회의록/산출물 등
  • target_id — BIGINT — 폴리모픽 대상 id (FK 제약 없음)
  • created_at — DATETIME — NOT NULL

assistant_messages

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → projects.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • role — VARCHAR(10) — NOT NULL — user/assistant
  • content — TEXT — NOT NULL
  • sources — JSON — 출처 (회의록/업무/산출물 등)
  • created_at — DATETIME — NOT NULL

audit_logs

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • action — VARCHAR(50) — NOT NULL
  • target_type — VARCHAR(30)
  • target_id — BIGINT
  • created_at — DATETIME — NOT NULL

comments

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → projects.id — NOT NULL
  • target_type — VARCHAR(10) — NOT NULL — personal/team
  • target_user_id — BIGINT — Foreign key → users.id — personal일 때만 사용, team이면 NULL
  • author_id — BIGINT — Foreign key → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

contribution_reports

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → projects.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • summary — TEXT
  • evidence — JSON — 업무/회의/GitHub/산출물 근거
  • created_at — DATETIME — NOT NULL

deliverables

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → projects.id — NOT NULL
  • type — VARCHAR(30) — NOT NULL — 발표자료/보고서/README/제안서 등
  • title — VARCHAR(200) — NOT NULL
  • content — LONGTEXT
  • status — VARCHAR(20) — NOT NULL — draft/review/final
  • file_path — VARCHAR(500)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

document_chunks

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → projects.id — NOT NULL
  • source_type — VARCHAR(20) — NOT NULL — meeting/task/deliverable/github (폴리모픽)
  • source_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • embedding — JSON — 운영 환경은 PostgreSQL pgvector VECTOR 타입 사용
  • created_at — DATETIME — NOT NULL

evaluation_scores

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → projects.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • score — DECIMAL(5,2) — NOT NULL
  • is_public — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

evaluation_settings

  • project_id — BIGINT — Foreign key — NOT NULL
  • contribution_ratio — DECIMAL(5,2) — NOT NULL
  • updated_at — DATETIME — NOT NULL

github_records

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → projects.id — NOT NULL
  • type — VARCHAR(20) — NOT NULL — commit/pr/issue
  • title — VARCHAR(300) — NOT NULL
  • author — VARCHAR(100)
  • url — VARCHAR(500)
  • linked_task_id — BIGINT — Foreign key → tasks.id — 선택적 FK - 업무 연결
  • created_at — DATETIME — NOT NULL

invitations

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → projects.id — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • token — VARCHAR(255) — NOT NULL
  • status — VARCHAR(20) — NOT NULL — pending/accepted/expired
  • expires_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL

meeting_action_items

  • id — BIGINT — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • recommended_assignee_id — BIGINT — Foreign key
  • final_assignee_id — BIGINT — Foreign key
  • due_date — DATE
  • priority — VARCHAR(255)
  • category — VARCHAR(255)
  • basis — TEXT
  • approved — BOOLEAN — NOT NULL
  • created_task_id — BIGINT — Foreign key
  • created_at — DATETIME — NOT NULL

meeting_analysis

  • meeting_id — BIGINT — Foreign key → meetings.id — NOT NULL — 1:1 - meetings.id
  • summary — TEXT
  • decisions — JSON — 결정사항 목록
  • risks — JSON — 위험요소 목록
  • action_items — JSON — To-Do 후보 목록
  • created_at — DATETIME — NOT NULL

meeting_attendees

  • id — BIGINT — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meetings.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL

meetings

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → projects.id — NOT NULL
  • title — VARCHAR(200)
  • file_type — VARCHAR(20) — NOT NULL — document/audio/video
  • file_path — VARCHAR(500)
  • transcript — LONGTEXT
  • analysis_status — VARCHAR(20) — NOT NULL — 비동기 분석 상태
  • created_at — DATETIME — NOT NULL

milestones

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → projects.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • due_date — DATE
  • created_at — DATETIME — NOT NULL

ml_predictions

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → projects.id — NOT NULL
  • target_type — VARCHAR(20) — NOT NULL — task/user (폴리모픽)
  • target_id — BIGINT — NOT NULL
  • model_type — VARCHAR(50) — NOT NULL — delay_risk/overload/anomaly
  • result — VARCHAR(50) — 정상/주의/위험 등
  • score — DECIMAL(6, 3)
  • created_at — DATETIME — NOT NULL

notifications

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key — NOT NULL
  • type — VARCHAR(255) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT
  • target_type — VARCHAR(255)
  • target_id — BIGINT
  • is_read — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

project_members

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → projects.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • role — VARCHAR(20) — NOT NULL — 팀장/팀원/심사자 (프로젝트별 role)
  • created_at — DATETIME — NOT NULL

projects

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • type — VARCHAR(50) — 캡스톤디자인/해커톤/공모전 등
  • deadline — DATE
  • description — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

rag_assignee_sync_failures

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — NOT NULL
  • source_type — VARCHAR(50) — NOT NULL
  • source_id — BIGINT — NOT NULL
  • assignee_id — BIGINT
  • error_message — TEXT
  • failed_at — DATETIME — NOT NULL

task_checklists

  • id — BIGINT — Primary key — NOT NULL
  • task_id — BIGINT — Foreign key → tasks.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • is_done — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

task_comments

  • id — BIGINT — Primary key — NOT NULL
  • task_id — BIGINT — Foreign key — NOT NULL
  • author_id — BIGINT — Foreign key — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • type — VARCHAR(20) — NOT NULL

task_result_files

  • id — BIGINT — Primary key — NOT NULL
  • task_id — BIGINT — Foreign key — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • storage_path — TEXT — NOT NULL
  • size — BIGINT — NOT NULL
  • content_type — VARCHAR(100)
  • uploaded_by — BIGINT — Foreign key
  • created_at — DATETIME — NOT NULL

task_result_links

  • id — BIGINT — Primary key — NOT NULL
  • task_id — BIGINT — Foreign key — NOT NULL
  • url — TEXT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • created_at — DATETIME — NOT NULL

task_results

  • id — BIGINT — Primary key — NOT NULL
  • task_id — BIGINT — Foreign key — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

tasks

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → projects.id — NOT NULL
  • milestone_id — BIGINT — Foreign key → milestones.id
  • title — VARCHAR(200) — NOT NULL
  • category — VARCHAR(50) — NOT NULL — 기획/프론트엔드/백엔드/AI-ML 등 18종
  • status — VARCHAR(20) — NOT NULL — 할 일/진행 중/보류-블로커/완료
  • assignee_id — BIGINT — Foreign key → users.id — 미배정 가능
  • due_date — DATE
  • priority — VARCHAR(20)
  • description — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • provider — VARCHAR(20) — NOT NULL — google 등 OAuth 제공자
  • provider_id — VARCHAR(255) — NOT NULL — OAuth sub (불변 식별자)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

workload_scores

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • overload_score — DECIMAL(5, 2) — NOT NULL
  • anomaly_type — VARCHAR(20) — NOT NULL — 정상/과부하 의심/저활동 의심/이상 패턴(방향 불명확) 중 하나
  • computed_at — DATETIME — NOT NULL