Multi-user inventory list in MySQL?
Posted: Wed Jan 28, 2015 2:52 pm
Hello, for a long time I've been wanting to learn PHP and MySQL and I've finally begun to do so. After following a 15 hour course on Lynda.com, I think I know the basics to be able to construct a small website. Now, I've got a project that I want to try out. My sister works for a company which sells different kinds of products, from makeup to soap. She has requested a small application where she can keep track of her inventory. When she recieves a new order for her inventory, she'll apply it to the application and it will update the database. I somewhat know how to do this, but I'm not sure how I want to build my database. My initial thought was to have individual tables for userdata, products, and then one for each users' inventory list? Is that a bad way to do this? In future, we would really like to be able to offer this to her colleagues as well for them to use. Is there a better way to build my database and how would I go about relating the users to their inventory data? Essentially, I think I'd be able to relate a users' data to another table for their inventory list. I don't see any other apparent way. I'd really like another set of eyes on this
Please be kind enough to explain it somewhat thoroughly aswell, since I am relatively new to this
Some notes: I want the website containing an overview over all products in their inventory, making them able to add and remove, alter prices and such using for example forms. Now, I'll be partially able to code it myself, if you can help me decide how to build my database
Thank you very much in advance, I look forward to interact with the people of this forum

Some notes: I want the website containing an overview over all products in their inventory, making them able to add and remove, alter prices and such using for example forms. Now, I'll be partially able to code it myself, if you can help me decide how to build my database