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)