DialoG
Tables (16)
ActionItem
- id — BIGINT
- meeting_id — BIGINT — NOT NULL
- title — VARCHAR(500) — NOT NULL
- assignee — VARCHAR(100) — 담당자
- deadline — DATE
- status — VARCHAR(20)
- created_at — TIMESTAMP
- INDEX — idx_meeting
- INDEX — idx_deadline
- INDEX — idx_status
CalendarEvent
- id — BIGINT
- title — VARCHAR(255) — NOT NULL
- event_date — DATE — NOT NULL
- event_time — TIME
- meeting_id — BIGINT
- INDEX — idx_event_date
- INDEX — idx_meeting
ChatHistory
- id — BIGINT
- user_id — BIGINT — NOT NULL
- question — TEXT — NOT NULL
- answer — TEXT — NOT NULL
- related_meeting_id — BIGINT
- created_at — TIMESTAMP
- INDEX — idx_user
- INDEX — idx_meeting
- FULLTEXT — idx_qa
Dictionary
- id — BIGINT — Primary key
- term — VARCHAR(255) — NOT NULL
- definition — TEXT
- INDEX — idx_term
- FULLTEXT — idx_dictionary
Highlight
- id — BIGINT — Primary key
- meeting_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- timestamp_seconds — INT
- created_at — TIMESTAMP
- INDEX — idx_meeting
Job
- id — BIGINT — Foreign key → User.id
- code — VARCHAR(50) — NOT NULL — 직무 코드
- name — VARCHAR(100) — NOT NULL — 직무명
- INDEX — idx_code
Keyword
- id — BIGINT — Primary key
- name — VARCHAR(50) — NOT NULL
- INDEX — idx_name
Meeting
- id — BIGINT
- title — VARCHAR(255) — NOT NULL — 회의 제목
- description — TEXT — 회의 설명
- scheduled_at — DATETIME — NOT NULL — 예약 시간
- started_at — DATETIME — 실제 시작 시간
- ended_at — DATETIME — 실제 종료 시간
- status — VARCHAR(20) — NOT NULL — SCHEDULED, RECORDING, COMPLETED, CANCELED
- host_user_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
- INDEX — idx_scheduled_at
- INDEX — idx_status
- INDEX — idx_host_user_id
MeetingKeyword
- meeting_id — BIGINT — Primary key — NOT NULL
- keyword_id — BIGINT — Primary key — NOT NULL
Participant
- id — BIGINT — Primary key
- meeting_id — BIGINT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- INDEX — idx_meeting
Recording
- id — BIGINT
- meeting_id — BIGINT — NOT NULL
- audio_file_path — VARCHAR(500) — 녹음 파일 경로
- stt_raw_text — LONGTEXT — STT 원본
- created_at — TIMESTAMP
- INDEX — idx_meeting
- FULLTEXT — idx_stt
Summary
- id — BIGINT — Primary key
- meeting_id — BIGINT — NOT NULL
- summary_text — TEXT — NOT NULL
- created_at — TIMESTAMP
- INDEX — idx_meeting
- FULLTEXT — idx_summary
Todo
- id — BIGINT
- user_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- due_date — DATE
- completed — BOOLEAN
- created_at — TIMESTAMP
- INDEX — idx_user
- INDEX — idx_due_date
- INDEX — idx_completed
Transcript
- id — BIGINT
- meeting_id — BIGINT — NOT NULL
- speaker_id — VARCHAR(50) — NOT NULL — 발화자 ID
- speaker_name — VARCHAR(100) — 실제 이름
- text — TEXT — NOT NULL — 발화 내용
- timestamp_seconds — INT — NOT NULL — 시점(초)
- sequence_number — INT — NOT NULL — 순서
- INDEX — idx_meeting
- INDEX — idx_sequence
User
- id — BIGINT
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- job_id — BIGINT
- created_at — TIMESTAMP
- INDEX — idx_email
- INDEX — idx_job
UserSettings
- user_id — BIGINT — Primary key
- auto_start_recording — BOOLEAN
- enable_auto_summary — BOOLEAN
- enable_auto_highlight — BOOLEAN
- language — VARCHAR(10)
- theme — VARCHAR(20)