Need to work out database structure
- by jim smith
Hi, Just need a little kickstart with this.
I have Mysql/PHP, and
I have 5,000 products.
I have 30 companies
I need to store some data for those 30 companies for each product as follows:
a) prices
b) stock qty
I also need to store data historically on a daily basis.
So the table...
It makes sense that the records will be the products…