joytalk

Tables (5)

Chatroom

  • chatroom_id — Long — Primary key — NOT NULL
  • title — String
  • createdAt (createAt) — DATETIME
  • Field

FriendMapping

  • friends_id — Long — Primary key — NOT NULL
  • member_id — Long — Foreign key → Member.member_id — NOT NULL
  • friend_id — Long

Member

  • member_id — Long — Primary key — NOT NULL
  • email — String
  • name — String
  • nickName — String
  • profileImage — String
  • role — String

MemberChatroomMapping

  • member_chatroom_mapping_id — Long — Primary key — NOT NULL
  • member_id — Long — Foreign key → Member.member_id — NOT NULL
  • chatroom_id — Long — Foreign key → Chatroom.chatroom_id — NOT NULL

Message

  • id — Long — Primary key — NOT NULL
  • member_id — Long — Foreign key → Member.member_id — NOT NULL
  • chatroom_id — Long — Foreign key → Chatroom.chatroom_id — NOT NULL
  • text — String
  • Field