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 — 비밀번호