projectree
Tables (14)
action_node_details
- node_id — BIGINT — Foreign key → knowledge_nodes.node_id — NOT NULL
- category_id (category_id2) — BIGINT — Foreign key → knowledge_nodes.category_id — NOT NULL
- assignee_user_id — BIGINT — 프로젝트 오너 또는 활성 일반 멤버
- status — VARCHAR(20) — NOT NULL — TODO, IN_PROGRESS, DONE
- due_at — DATETIME
- completed_at — DATETIME
issue_node_details
- node_id — BIGINT — Foreign key → knowledge_nodes.node_id — NOT NULL
- category_id (category_id2) — BIGINT — Foreign key → knowledge_nodes.category_id — NOT NULL
- status — VARCHAR(20) — NOT NULL — OPEN 또는 RESOLVED
- resolved_at — DATETIME
knowledge_nodes
- node_id — BIGINT — Primary key — NOT NULL
- project_id — BIGINT — Foreign key → projects.project_id — NOT NULL
- source_minutes_id — BIGINT — AI 회의록에서 생성되지 않은 직접 입력 노드는 NULL
- category_id — BIGINT — 주로 ROOT 노드가 참조
- parent_node_id — BIGINT — ROOT는 NULL
- created_by_user_id — BIGINT
- node_type — VARCHAR(20) — NOT NULL — ROOT, DECISION, ACTION, ISSUE
- title — VARCHAR(255) — NOT NULL
- content — LONGTEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
- category_id (category_id2) — BIGINT — Foreign key → projects.category_id — NOT NULL
meeting_minutes
- minutes_id — BIGINT — Primary key — NOT NULL
- meeting_id — BIGINT — Foreign key → meetings.meeting_id — NOT NULL
- summary — LONGTEXT
- status — VARCHAR(30) — NOT NULL — PROCESSING, REVIEW_REQUIRED, CONFIRMED, FAILED
- reviewed_by_user_id — BIGINT
- generated_at — DATETIME
- reviewed_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- category_id — BIGINT — Foreign key → meetings.category_id — NOT NULL
meeting_participants
- meeting_participant_id — BIGINT — Primary key — NOT NULL
- meeting_id — BIGINT — Foreign key → meetings.meeting_id — NOT NULL
- user_id — BIGINT — NOT NULL
- joined_at — DATETIME — NOT NULL
- left_at — DATETIME
- category_id — BIGINT — Foreign key → meetings.category_id — NOT NULL
meetings
- meeting_id — BIGINT — Primary key — NOT NULL — API에 노출하지 않아도 되는 내부 회의 PK
- project_id — BIGINT — Foreign key → projects.project_id — NOT NULL
- created_by_user_id — BIGINT
- title — VARCHAR(150) — NOT NULL
- status — VARCHAR(30) — NOT NULL — READY, IN_PROGRESS, ENDED, AI_PROCESSING, REVIEW_REQUIRED, CONFIRMED, FAILED
- session_provider — VARCHAR(30) — PoC 확정 후 OPENVIDU 등 저장
- external_session_id — VARCHAR(255) — OpenVidu 등 외부 세션 ID
- started_at — DATETIME
- ended_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- category_id — BIGINT — Foreign key → projects.category_id — NOT NULL
node_categories
- category_id — BIGINT — Primary key — NOT NULL
- code — VARCHAR(50) — NOT NULL — BACKEND, FRONTEND, DESIGN, PLANNING, INFRA, AI 등
- name — VARCHAR(50) — NOT NULL
- display_order — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
node_positions
- node_id — BIGINT — Foreign key → knowledge_nodes.node_id — NOT NULL
- category_id (category_id2) — BIGINT — Foreign key → knowledge_nodes.category_id — NOT NULL
- position_x — DOUBLE — NOT NULL
- position_y — DOUBLE — NOT NULL
- position_z — DOUBLE — NOT NULL
- updated_at — DATETIME — NOT NULL
node_relations
- node_relation_id — BIGINT — Primary key — NOT NULL
- project_id — BIGINT — Foreign key → projects.project_id — NOT NULL
- from_node_id — BIGINT — NOT NULL
- to_node_id — BIGINT — NOT NULL
- relation_type — VARCHAR(30) — NOT NULL — RELATED_TO, RESOLVES, PRODUCES, BLOCKS, REFERENCES
- created_at — DATETIME — NOT NULL
- category_id — BIGINT — Foreign key → projects.category_id — NOT NULL
project_invitations
- invitation_id — BIGINT — Primary key — NOT NULL
- project_id — BIGINT — Foreign key → projects.project_id — NOT NULL
- inviter_user_id — BIGINT
- invitee_user_id — BIGINT
- invitee_email — VARCHAR(255) — NOT NULL
- token_hash — VARCHAR(255) — NOT NULL — 원문 초대 토큰이 아닌 해시 저장
- status — VARCHAR(20) — NOT NULL — PENDING, ACCEPTED, EXPIRED, REVOKED
- expires_at — DATETIME — NOT NULL
- accepted_at — DATETIME
- created_at — DATETIME — NOT NULL
- category_id — BIGINT — Foreign key → projects.category_id — NOT NULL
project_members
- project_member_id — BIGINT — Primary key — NOT NULL
- project_id — BIGINT — Foreign key → projects.project_id — NOT NULL
- user_id — BIGINT — NOT NULL
- status — VARCHAR(20) — NOT NULL — ACTIVE 또는 LEFT
- joined_at — DATETIME — NOT NULL
- left_at — DATETIME
- category_id — BIGINT — Foreign key → projects.category_id — NOT NULL
projects
- project_id — BIGINT — Primary key — NOT NULL
- category_id — BIGINT — Foreign key → node_categories.category_id — NOT NULL
- owner_user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 프로젝트 생명주기를 소유하는 사용자
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- status — VARCHAR(20) — NOT NULL — ACTIVE 또는 DELETED
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
user_oauth_accounts
- oauth_account_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- provider — VARCHAR(30) — NOT NULL — 현재 GOOGLE
- provider_subject — VARCHAR(255) — NOT NULL — OAuth 공급자의 불변 사용자 식별자(sub)
- provider_email — VARCHAR(255) — 인증 당시 공급자 이메일
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL — 사용자 식별자
- email — VARCHAR(255) — NOT NULL — 현재 사용자 이메일
- name — VARCHAR(30) — NOT NULL — 사용자 이름 또는 닉네임
- profile_image_url — VARCHAR(2048) — 프로필 이미지 URL
- system_role — VARCHAR(20) — NOT NULL — USER 또는 ADMIN
- status — VARCHAR(20) — NOT NULL — ACTIVE 또는 WITHDRAWN
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- withdrawn_at — DATETIME