SOPT-ANDROID-TEAM5

Tables (3)

chatroom_folders

  • chatroom_folder_id — BIGINT — Primary key — NOT NULL
  • chatroom_id — BIGINT — Foreign key → chatrooms.chatroom_id — NOT NULL
  • folder_id — BIGINT — Foreign key → folders.folder_id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

chatrooms

  • chatroom_id — BIGINT — Primary key — 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 — Primary key — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • icon — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL