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