School project, modeling
So basically I've tasked myself with making an it solution to Dunder Mifflin, and one of the things I need to do is a project where employees can keep track of stock, here it's ofc. paper, but like how would I model storing paper 
like 1 row for each paper, 1 row for each pallet, 1 table, like wtf idk why but I hate my own idea now lol, I'm just going to use sqlite for this shit
like 1 row for each paper, 1 row for each pallet, 1 table, like wtf idk why but I hate my own idea now lol, I'm just going to use sqlite for this shit6 Replies
tldr how would you model the db of dunder mifflin which in this case just sells paper
theres no authentication or anything cba doing that
https://gist.github.com/barrybtw/a18be9ba4ff339d5fd0c4ed3ed483826
this might be fine? idk
i beleive orders are in reams of paper ie a "stack" if u care, probably dont need to worry about sheets for orders and palletes is only if you are going to create the shipment system as well
if you are doing the shipment system gather all the PII, billing and shipping info along with the cost in the order
status of shipment etc
have CSV export for the order sheets to give it to the shipment crew
i had a big brain moment and said this project is too big for this cuz well i only need to display fundemental knowledge of programming
so ima just make a thing with pysimplegui that gives you a file from some entered details lol
based programmer moment