How can I implement storage in the database passed by user tests?

  • Can you describe in more detail the structure of the existing database? - cheops
  • cheops it is at the level of a primitive, so there is nothing to show. I wanted a theoretical solution. - user200192
  • A lot of tests? Do they go in some order? I just would like more details about the task. - cheops
  • Yes, there are a few @cheops tests, all the more so without any division by type and complexity. Are you talking about ordering? I would like to date, but I think if you record the time and date of passage, there will be no problem. - user200192
  • @cheops thought came to mind, if you keep records of passed tests with the user's ID and the time it takes the table, and then just stupidly making a sample for a specific user is a correct decision? or crutch - user200192

1 answer 1

As an option:

  • Tests : test_id , test_name , (other test parameters) ...;
  • People : human_id , human_name , (other human parameters) ...;
  • People_Tests : test_id , p_id , result (number of points or passed / not passed).

Table Tests stores data on all tests that are. The People table stores registered users (people related to this testing). The People_Tests table stores the following data: "Which test ( test_id ) was written by which person ( human_id ) and whether it was successful ( result )."