How is message data stored in the database?

Question

Database design

Are they all stored in a separate table linked to the user?

Answer 1

It depends on who writes how.
Of course, it is correct to store separately.

Answer 2

Separately. User bound. Usually one user can write several messages.
I store it like this:

id	integer Auto Increment 
chat_id	integer	
user_id	integer	
body	text	
created_at	timestamp(0) NULL	
updated_at	timestamp(0) NULL

Answer 3

Just for the record - OLTP is not the right place to store messages. A more document-oriented database is more suitable here