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