# A Universal Chat History Management

## Fields

Table Message:
+ source(enum): can be 0:wechat, ...
+ time(time)
+ sender: id of the sender. id follows the name convention of source
+ chatroom: id of the chatroom (can be a private chat with a sender, or a group chat)
+ text: text content. emojis are encoded according to the source
+ image: binary of the image.
+ sound: binary of an audio
+ extra_data: other possible data specific to the source.

Table Wechat:
+ avatars
+ nicknames
+ emojis