How to design a notification system correctly?

Question

Database design

there is an announcement wall, under it you can offer exchanges, auctions, and ask questions:
all offers are written in separate tables: auctions, exchanges and questions, in addition, under these all actions, you can leave comments and reply with a comment to a comment.
Question - how to correctly design a table for alerts?
The following solution came to mind:
notifications : id, user_id, advert_id, notification_type_id
notification_types : id, alias, name

Answer 1

user_code, table_code, table_code , timestamp, type, text, status

what do you have, enter table_code

You have several tables ( auctions, exchanges и questions), so you need to specify it.

the text will not work, since the site has multilingualism and if a person changes the language of the site, the text of the notification will remain the same.

Change the same as the text of the sentence.