Meeting Minutes

Tables (10)

CalendarEvent

  • id — int(20) — Primary key — NOT NULL
  • title — VARCHAR(150) — NOT NULL
  • description — TEXT — NOT NULL
  • start_time — DATETIME — NOT NULL
  • end_time — DATETIME — NOT NULL
  • location — VARCHAR(100)
  • created_by — int(20) — Foreign key → Meeting.id — NOT NULL

ChatBotQuery

  • id — int(20) — Primary key — NOT NULL
  • query_text — TEXT — NOT NULL
  • response_text — TEXT — NOT NULL
  • queried_at — DATETIME — NOT NULL
  • user_Id — int(20) — Foreign key → User.id — NOT NULL
  • meeting_id — int(20) — Foreign key → Meeting.id — NOT NULL

Dictionary

  • id — int(20) — Primary key — NOT NULL
  • term — VARCHAR(100)
  • short_desc — VARCHAR(200)
  • full_desc — TEXT — NOT NULL
  • team_or_dept — VARCHAR(50) — NOT NULL
  • registered_by — int(20) — Foreign key → User.id — NOT NULL

Highlight

  • id — int(20) — Primary key — NOT NULL
  • keyword — VARCHAR(100) — NOT NULL
  • detected_at — DECIMAL(10,3) — NOT NULL
  • context_text — TEXT — NOT NULL
  • meeting_id — int(20) — Foreign key → Meeting.id — NOT NULL

Keyword

  • id — int(20) — Primary key — NOT NULL
  • value — VARCHAR(100)
  • category — VARCHAR(50)
  • is_active — BOOLEAN
  • create_by — int(20) — Foreign key → User.id — NOT NULL

Meeting

  • id — int(20) — Primary key — NOT NULL
  • title — VARCHAR(150) — NOT NULL
  • started_at — DATETIME — NOT NULL
  • ended_at — DATETIME — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • raw_audio_path — VARCHAR(255) — NOT NULL
  • stt_raw_text — TEXT — NOT NULL
  • summary_text — TEXT — NOT NULL
  • highlight_text — TEXT
  • host_user_id — int(20) — Foreign key → User.id — NOT NULL
  • calendar_event_id — int(20) — Foreign key → CalendarEvent.id

Participant

  • id — int(20) — Primary key — NOT NULL
  • join_time — DATETIME
  • leave_time — DATETIME
  • speaker_label — VARCHAR(30) — NOT NULL
  • meeting_id — int(20) — Foreign key → Meeting.id — NOT NULL
  • user_id — int(20) — Foreign key → User.id — NOT NULL

SpeechLog

  • id — int(20) — Primary key — NOT NULL
  • timestamp — DECIMAL(10,3) — NOT NULL
  • speaker_label — VARCHAR(30) — NOT NULL
  • stt_text — TEXT — NOT NULL
  • is_highlighted — BOOLEAN
  • is_action_item — BOOLEAN
  • keyword_matched — VARCHAR(100)
  • meeting_id — int(20) — Foreign key → Meeting.id — NOT NULL
  • participant_id — int(20) — Foreign key → Participant.id — NOT NULL

To-Do

  • id — int(20) — Primary key — NOT NULL
  • content — TEXT — NOT NULL
  • due_date — DATETIME
  • linked_calendar_event_id — int(20) — Foreign key → CalendarEvent.id
  • meeting_id — int(20) — Foreign key → Meeting.id — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • responsible_participant_id — int(20) — Foreign key → Participant.id — NOT NULL

User

  • id — int(20) — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(200) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • department — VARCHAR(200)
  • position — VARCHAR(50)
  • social_type — VARCHAR(50)
  • profile_img_url — VARCHAR(50)
  • sns_id — VARCHAR(100)