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