How to implement a database table with an arbitrary number of columns?

There is a table, and here we are talking about the web face, where in the first column are strings, say, the details, and in the header of an arbitrary number of other columns - date. at their intersection we have a text input where it is possible to record a certain status,commentary etc. These dates can be from 1-999, that is, the plate extends on indefinitely. Always different.
How to implement it in the database itself? The details are in a separate table to match products and connect with the piece intermediate table is 1 to many on id.
July 12th 19 at 16:43
2 answers
July 12th 19 at 16:45
You can create a separate table for dates adding these dates in any quantity one per line, tying them to a specific ID details from the first table.
It usually is done. - richie_Hettinger commented on July 12th 19 at 16:48
July 12th 19 at 16:47
`table` (`part_id` INT, `date` DATE, `state` VARCHAR())

Find more questions by tags DatabasesSQLSQLite