Line Clone ERD

Tables (6)

Chat

  • Chatroom (ChatId) — long — Primary key — NOT NULL
  • Chat name (chatName) — String
  • attentdant (attendant1id) — long
  • createdAt — TimeStamp
  • member 区別 (holderId) — long — Foreign key → SimpleMember.member 区別 — NOT NULL

FriendList (friendList)

  • FriendListId (friendlistId) — long — Primary key — NOT NULL
  • friend (friendId) — long
  • member (memberId) — long

MemberDetail

  • MemberDetailID (memberDetailId) — long — Primary key — NOT NULL
  • Field (profile message) — String
  • 設定された名前 (name) — String
  • profileURL (url) — String
  • member 区別 (memberId) — long — Foreign key → SimpleMember.member 区別 — NOT NULL
  • createdAt — Timestamp
  • updatedAt — TimeStamp

MessageList (messages)

  • messageId — long — Primary key — NOT NULL
  • message内容 (context) — long
  • roomId — long
  • sender (senderId) — long
  • createdAt — TimeStamp

SimpleMember (Member)

  • member 区別 (memberId) — long — Primary key — NOT NULL
  • memberId (loginId) — String
  • registerToken (loginToken) — String
  • FCMToekn (fcmToken) — String
  • Hashed password (password) — String
  • MemberDetailID (memberDetailId) — long — Foreign key → MemberDetail.MemberDetailID — NOT NULL
  • createdAt — TimeStamp
  • updatedAt — TimeStamp

messageRoomList (RoomList)

  • roomId (roomid) — long — Primary key — NOT NULL
  • Field