Chat

Tables (4)

ChatRoom (CopyOfChatUser)

  • id — Long — Primary key — NOT NULL
  • createDate (CreateDate) — LocalDateTime
  • updateTime (Field2) — LocalDateTime
  • lastReadMessageIndex (마지막 읽은 메시지 인덱스) — Long
  • isActivated (활성화여부) — Boolean
  • chatUserAesKey (참여자목록 AESKEY) — String

ChatRoomCache (ChatRoom Cache)

  • chatRoomIdPid (id) — String — Primary key — NOT NULL
  • participantId (참여자 ID) — String
  • updateTime (Field2) — LocalDateTime
  • lastReadMessageIndex (마지막 읽은 메시지 인덱스) — Long
  • isActivated (활성화여부) — Boolean
  • chatUserAesKey (참여자목록 AESKEY) — String

ChatUser

  • id — Long — Primary key — NOT NULL
  • charRoomId (채팅방 ID) — Long — Foreign key → ChatRoom.id — NOT NULL
  • participantId (String) — String
  • participantName (이름) — String — dd
  • createDate (CreateDate) — LocalDateTime
  • updateTime (Field2) — LocalDateTime
  • lastReadMessageIndex (마지막 읽은 메시지 인덱스) — Long
  • isActivated (활성화여부) — Boolean

ChatUserCache

  • id — Long — Primary key — NOT NULL
  • participantId (String) — String
  • participantName (이름) — String — dd
  • createDate (CreateDate) — LocalDateTime
  • updateTime (Field2) — LocalDateTime
  • lastReadMessageIndex (마지막 읽은 메시지 인덱스) — Long
  • isActivated (활성화여부) — Boolean