chat

Tables (4)

ChatRoom (채팅방)

  • chatRoomId (채팅방id) — Long — Primary key — NOT NULL
  • name (채팅방이름) — String

Message (채팅)

  • massageId (메세지id) — Long — Primary key — NOT NULL
  • chatRoomId (채팅방id) — Long — Foreign key → UserChatRoom.chatRoomId — NOT NULL
  • userId (유저id) — Long — Foreign key → UserChatRoom.userId — NOT NULL

User (유저)

  • userId (Long) — Primary key — NOT NULL
  • name (String)
  • Field

UserChatRoom (채팅방 - 유저)

  • chatRoomId (채팅방id) — Long — Foreign key → ChatRoom.chatRoomId — NOT NULL
  • userId (유저id) — Long — Foreign key → User.userId — NOT NULL
  • Field