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