meetingly

Tables (8)

meetings

  • id — CHAR(36)
  • title — VARCHAR(255) — NOT NULL
  • team_id — CHAR(36) — NOT NULL
  • organizer_id — CHAR(36) — NOT NULL
  • start_time — DATETIME
  • end_time — DATETIME
  • recording_url — TEXT
  • created_at — TIMESTAMP

participants

  • id — CHAR(36)
  • meeting_id — CHAR(36) — NOT NULL
  • user_id — CHAR(36) — NOT NULL
  • join_time — DATETIME
  • leave_time — DATETIME

summaries

  • id — CHAR(36)
  • meeting_id — CHAR(36) — NOT NULL
  • type — VARCHAR(20) — 요약 유형 (AI / 수동)
  • content — TEXT
  • created_at — TIMESTAMP

tasks

  • id — CHAR(36)
  • meeting_id — CHAR(36) — NOT NULL
  • content — TEXT — NOT NULL
  • assignee_id — CHAR(36)
  • status — ENUM('todo', 'doing', 'done')
  • created_at — TIMESTAMP

teamMembers

  • id — CHAR(36)
  • team_id — CHAR(36) — NOT NULL
  • user_id — CHAR(36) — NOT NULL
  • role — ENUM('admin', 'member') — NOT NULL — 팀 내 역할
  • joined_at — TIMESTAMP

teams

  • id — CHAR(36) — 팀 ID
  • name — VARCHAR(100) — NOT NULL — 팀 이름
  • description — TEXT — 팀 설명
  • created_at — TIMESTAMP — 생성일

transcripts

  • id — CHAR(36)
  • meeting_id — CHAR(36) — NOT NULL
  • speaker — VARCHAR(100)
  • start_time — FLOAT
  • end_time — FLOAT
  • content — TEXT
  • created_at — TIMESTAMP

users

  • id — CHAR(36) — 사용자 ID
  • email — VARCHAR(255) — NOT NULL — 이메일
  • name — VARCHAR(100) — NOT NULL — 이름
  • role — ENUM('admin', 'user') — NOT NULL — 역할
  • created_at — TIMESTAMP — 생성일
  • password — CHAR(36) — NOT NULL — 비밀번호