LET'S SOPT 안드로이드 5조 ERD
테이블 (3)
chatroom_folders
- chatroom_folder_id — BIGINT — 기본 키 — NOT NULL
- 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