합세 카카오톡

테이블 (3)

chatroom_folders

  • chatroom_id — BIGINT — 외래 키 → chatrooms.chatroom_id — NOT NULL
  • folder_id — BIGINT — 외래 키 → folders.folder_id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

chatrooms

  • chatroom_id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • participant_count — INT — NOT NULL
  • last_message — VARCHAR(500)
  • last_message_at — DATETIME
  • unread_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

folders

  • folder_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • icon — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL