실시간채팅
테이블 (6)
chat_room
- room_id — BIGINT — NOT NULL
- room_name — VARCHAR(100)
- room_type — VARCHAR(10) — NOT NULL
- created_by — BIGINT — NOT NULL
- is_active — BOOLEAN
- last_message_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_room_type
- INDEX — idx_last_message_at
chat_room_member
- member_id — BIGINT — NOT NULL
- room_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- joined_at — DATETIME
- last_read_at — DATETIME
- unread_count — INT
- is_active — BOOLEAN
- role — VARCHAR(10)
- INDEX — idx_user_id
- INDEX — idx_room_id
message
- message_id — BIGINT — NOT NULL
- room_id — BIGINT — NOT NULL
- sender_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- message_type — VARCHAR(10)
- is_deleted — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_room_id
- INDEX — idx_sender_id
- INDEX — idx_created_at
message_read_status
- read_id — BIGINT — NOT NULL
- message_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- read_at — DATETIME
- INDEX — idx_message_id
- INDEX — idx_user_id
typing_status
- typing_id — BIGINT — NOT NULL
- room_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- is_typing — BOOLEAN
- started_at — DATETIME
user
- user_id — BIGINT — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- avatar_url — VARCHAR(500)
- status — VARCHAR(10)
- last_active_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_email
- INDEX — idx_status