What is the best way to make a table?

Question

SQL

The next dilemma was the table, everything functioned OK and now it also works, but due to its inexperience, I did the following.
The "Goods" table has a "Warehouse" column, which contains the id of the warehouse where the goods are located. When creating the same product in another warehouse, another record is created in the table (it is duplicated, but only the warehouse id is changed). I have 3 warehouses and so there are 3 records in the goods table for one product. In fact, there are not many goods, it is convenient to sort and keep records under different accounts. Since each seller has his own account and accesses are registered in this account.
But now I have one question. Did I do the right thing? Maybe it would be better to create in the product table not a warehouse id, but for each warehouse to select a column with the amount of goods in stock? Maybe someone will tell you how best to do it and how to do it in general in such cases. While the base is not completely filled and there is an opportunity to redo it?

Answer 1

Of course , there should be three tables: goods, warehouses and goods-warehouse. The last table simply stores the link between the product and the warehouse (maybe more quantity).

Answer 2

That's right , a many-to-many relationship between the Warehouse and Product tables.