Answer the question
In order to leave comments, you need to log in
The structure of the database for statistics, how to organize?
There is a table in a DB in which records about some objects are stored. My software selects data in batches from this table. That is, the program pulls out 10-15 objects at a time. I need to store statistics about the received packs. I'm thinking of just making 1 more table in the database and let the software write there what it does, for example date, number of objects.
Question: “What is the best way to record which object IDs were received by the program in this batch?”
Answer the question
In order to leave comments, you need to log in
It depends what you do with these IDs.
If you want to JOIN, then it's better to make an intermediate table, as everyone does for many-to-many hierarchies.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question