채팅
테이블 (4)
유저 (USERS)
- userId (user_id) — INT(11) — 기본 키 — NOT NULL
- email (emial) — VARCHAR(20)
- name — VARCHAR(20)
- joinDate (join_date) — TIMESTAMP
- loginTime (login_time) — TIMESTAMP
- logoutTime (logout_time) — TIMESTAMP
- totalAccessTime (total_access_time) — TIMESTAMP
채팅메시지 (MESSAGES)
- messageId (message_id) — INT(11) — 기본 키 — NOT NULL
- userId (user_id) — INT(11) — 외래 키 → 유저.userId — NOT NULL
- roomId (room_id) — INT(11) — 외래 키 → 채팅방.roomId — NOT NULL
- contents — VARCHAR(2000)
- unreadMsgCnt (unread_msg_cnt) — INT
- time — TIMESTAMP
채팅방 (ROOMS)
- roomId (room_id) — INT(11) — 기본 키 — NOT NULL
- name — VARCHAR(20)
- createdDate (created_date) — TIMESTAMP
채팅방에 접속한 유저 (ROOM_USER)
- connectId (connect_id) — INT(11) — 기본 키
- userId (user_id) — INT(11) — 외래 키 → 유저.userId — NOT NULL
- roomId (room_id) — INT(11) — 외래 키 → 채팅방.roomId — NOT NULL
- connectedTime (connected_time) — TIMESTAMP
- disconnectedTime (disconnected_time) — TIMESTAMP