How to competently build the architecture of the base for logs?

Question

MySQL

Let's say there are 6 chats. Every chat message needs to be logged. Create 1 table with type column (chat type) or many tables per chat?

Answer 1

If the data is homogeneous and all chats are the same - the first one. If there is a possibility that the set saved for different chats will be different - the second.