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