obigomessenger

Tables (8)

ChatInvitation (채팅방 초대)

    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 (Untitled)

      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)