obigomessenger
Tables (8)
ChatMember (채팅방 멤버)
- PK (id) — Long — Primary key — NOT NULL
- 채팅방 ID (roomId) — Long
- 멤버 (memberId) — Long
- Field
ChatRoom (채팅방)
- PK (id) — Long — Primary key — NOT NULL
- 방 타입(Friendm Group) (roomType) — Enum
- openfire Jid (roomJid)
Friend (CopyOfUntitled)
- PK (id) — Primary key — NOT NULL
- 나(자기자신) (me) — Member
- 상대방 (opponent) — Member
- 상대방닉네임 (opponentNickname) — String
- 친구 상태 (FriendStatus) — Enum
- 일대일대화방 JID (oneToOneRoomJid) — String
Member (Untitled2)
- PK (memberId) — String — Primary key — NOT NULL
- username — String
- openfire Jid (jid) — String
- 전화번호 (phone) — String
ofmucconversationlog (Openfire가 만들어주는 메세지기록)
ofmucroom (Openfire가 만들어줌)
- MUC PK (name) — String — Primary key — NOT NULL
- 방 고유 ID (roomId) — Long
- 방 설정, 속성 (Field)