MeetCode
Tables (3)
meeting
- 회의id (id) — BIGINT — Primary key — NOT NULL
- 룸코드 (room_code) — VARCHAR(20) — NOT NULL
- 제목 (title) — VARCHAR(100)
- 방장_닉네임 (host_nickname) — VARCHAR(30)
- save_key — VARCHAR(64) — NOT NULL
- owner_user_id — BIGINT
- 상태 (status) — VARCHAR(20) — NOT NULL
- 생성일시 (created_at) — DATETIME — NOT NULL
- 저장일시 (saved_at) — DATETIME — NOT NULL
- 만료일시 (expires_at) — DATETIME
- INDEX — idx_meeting_room_code
meeting_asset
- id — BIGINT
- meeting_id — BIGINT — NOT NULL
- asset_type — VARCHAR(20) — NOT NULL
- title — VARCHAR(100)
- url — TEXT — NOT NULL
- uploader — VARCHAR(30)
- created_at — DATETIME — NOT NULL
- INDEX — idx_asset_meeting
meeting_message
- id — BIGINT
- meeting_id — BIGINT — NOT NULL
- seq — INT — NOT NULL
- type — VARCHAR(20) — NOT NULL
- sender — VARCHAR(30)
- content — TEXT — NOT NULL
- sent_at — DATETIME — NOT NULL
- INDEX — idx_message_meeting