M
M
MosVasil2018-09-16 20:21:50
Database design
MosVasil, 2018-09-16 20:21:50

How to store price history?

For example, we have 1000 outlets, they all sell the same goods T1, T2, T3, T4, T5
Prices for goods are different, prices at different outlets may be different, prices may change at different intervals.
Tell me how the tables should look like to store such a data set? Provided that we need to know the current price/s for the product/s

Answer the question

In order to leave comments, you need to log in

2 answer(s)
E
Eugene, 2018-09-16
@klim76

as an option:
link to the product / link to the store / price / date

S
sim3x, 2018-09-16
@sim3x

Магазин:
 ...

Товар:
 ...

Цена:
 магазин  = ForeignKey(Магазин)
 цена = ForeignKey(Цена)
 дата_время

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question