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)