채팅

테이블 (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