How to make a subd table in my case?

Question

MySQL

Good!
SQLite DBMS
Help me understand how best to do this.
I want to make a table where there will be one Date column, the rest will contain a list of _id of other tables. It should be like in a basket, add / remove and tied to a specific date, here I sketched it schematically. In my case, is it possible to get by with one table or do I need a table for each column?

Answer 1

you can use one, the text field and all the cases
are inefficient, however, well, they don’t expect another from sqlite anyway