mini chatting room

Tables (4)

ChatRoom (채팅방 테이블)

  • id (Key) — long — Primary key — NOT NULL
  • pid (Field) — string ( uuid )
  • createDate (Field6) — datetime
  • lastLoginDate (Field8) — datetime
  • isActive (Field2) — boolean
  • isPrivate (Field3) — boolean

ChatUser (사용자 테이블)

  • id (Key) — long — Primary key — NOT NULL
  • pid (Field) — string( uuid )
  • nick (Field2) — string ( unique )
  • email (Field3) — string ( unique )
  • pw (Field4) — string
  • token (Field5) — string ( unique )
  • lastIp (Field10) — string
  • createDate (Field6) — datetime
  • updateDate (Field7) — datetime
  • lastLoginDate (Field8) — datetime
  • pwChangedDate (Field9) — datetime
  • isActive (Field11) — boolean
  • lastUsedPw (Field12) — string

FriendsList (사용자 친구 리스트)

  • id (Key) — long — Primary key — NOT NULL
  • id (Key2) — long — Foreign key → ChatUser.id — NOT NULL
  • pid (Field) — string ( uuid )
  • requestUser (Field2) — ChatUser ( Many To One )
  • responseUser (Field3) — ChatUser ( Many To One )
  • status (Field4) — string
  • createDate (Field6) — datetime
  • lastLoginDate (Field8) — datetime

UserWithRoom (사용자와 채팅방 사이 중간 테이블)

  • id (Key) — long — Primary key — NOT NULL
  • ChatUser (Key2) — ChatUser — Foreign key → ChatUser.id — NOT NULL
  • ChatRoom (Key3) — ChatRoom — Foreign key → ChatRoom.id — NOT NULL
  • roompid (Field8) — string ( uuid ) — 빠른 조회를 위해서 사용
  • readMsgCnt (Field2) — LONG