Which table structure to choose for the comment system?

Question

Database design

There was such a dilemma: how to design tables for a comment system, such as here on the toaster, so that you can insert both text and links (for example, so that videos from YouTube are loaded), ordinary links and pictures? - is it somehow all in one table to shove or spread across several? To withstand a huge load.

So far I've come to this:

id
thread_id - id записи
user_id
ip
replay - тело
type - тип коммента (1-текст,2-ссылка,3-картинка)
created_at

Answer 1

There is no functional description of the task, so there is little help on the case.
It will take more than a year for a scalable commenting system.
user_id - who wrote,
and if he answered, who needs to know...?
content - body, which can consist of parts: text and other elements.
You need to know the status of the message: approved, pending moderation, rejected, deleted.
There are many more details that cannot be described.
If the commenting system is not primary for business, then it makes sense to integrate a third-party system, of which there are enough on the market.