How the table structure for storing chat records is designed

How to design a database to store chat records, the data roughly include:
Message Send time
Sent by
Accepted by
Message ID, unique
Message type: text, picture, etc.
Message content
How the data sheet should be designed, thank you.

Reply content:

How to design a database to store chat records, the data roughly include:
Message Send time
Sent by
Accepted by
Message ID, unique
Message type: text, picture, etc.
Message content
How the data sheet should be designed, thank you.

This is generally the design, after the sub-table and so on, if you do not need to search so record, you can consider the old data scheduled export cleanup

How does a non-relational database work? A user is a collection. A collection of chat logs per day.

