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