How to store the game task in the database?

Question

Database

Coolity, there is generally a text rpg and, as usual, there are many small tasks (find this, collect that, talk to that, etc.)

How to store such a structure in the database? serialization?

I think by pressing the "accept task" key, pull the information about the task from the database (shove it into the serializer) and write it to the table of active tasks (from there, pull it when necessary and monitor the status)

But maybe I'm wrong, tell me who knows
Thank you.

Answer 1

The subject area is divided into entities, each entity has its own table with a set of fields, hang a logic layer on top for accessing the database, and just above the application logic.