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