How to implement the management of the number of goods at different points?

Question

Database design

For example, there are 30,000 products and 400 outlets.
How to manage the availability of goods at each outlet (as well as specify other product fields for a particular outlet: price, name, discount)?

If we implement in 3 tables: "goods", "points", "goods at the outlet",
THEN in the table "goods at the outlet" there will be 12 million records. This is not good from the optimization side, I guess. How can I implement this even without 3 tables in the database?

Answer 1

Not how considering that it is necessary to store additional fields for each record, and why crutches and reinvent the wheel. It's ok 3 tables and 2 OneToMany relationships.
12k records is not that much.

Answer 2

Make a separate base for each point, it still makes no sense for them to look at the availability at other points