There is a table with skills and evaluation. Ie, I do not know how many skills he has, he can list them a lot. At the end I will put an assessment. How to create a table, so that I could get all the skills of this person upon request. Store everything as a string or in a json file, are there other options?

  • 2
    The list of people is a separate table, the list of skills is a separate table (because they can be repeated for different people), estimates are the third table (because for different people they can be repeated). And one table that links the previous three (that is, in fact there are three fields - links to other tables) - Chubatiy
  • @Chubatiy and in short: how to make a link to another table? - user33274
  • 2
    @MaximLensky I paraphrase - the fourth table stores three IDs in three fields. One for each of the three previous tables) - Chubatiy
  • 2
    If only one assessment is made for one skill of one person, then a separate assessment table is not needed, the assessment will be stored directly in the link table. - Akina
  • @Akina agree. The question is how to TK. But anyway - I think the issue is resolved) - Chubatiy

1 answer 1

Create a "People" table with id_person and other fields.
Create a table "Skills" with id_wiki and other fields.
Create a table "People Skills" where there will be only three columns: id_person, id_ Skill and grade_ skill.
So you can realize the many-to-many connection.