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

Question

SQL

There is a table, and here we are talking about a web muzzle, where in the first column the lines are, say, details, and in the header of an arbitrary number of other columns - dates. at their intersection we have text inputs, where you can record a certain state, comment, etc. These dates can be from 1-999+, that is, the plate stretches for as long as you like. Always different.
How to implement this in the database itself? The parts themselves are a separate table for matching with products and are connected to this product by an intermediate table 1 to many by id.

Answer 1

You can create a separate table for dates by adding any number of dates there, one per row, linking them to a specific part ID from the first table.

Answer 2

`table` (`part_id` INT, `date` DATE, `state` VARCHAR())