MillerTime
New member
- Local time
- Today, 13:39
- Joined
- Dec 9, 2020
- Messages
- 5
I have been tasked with creating a inventory database for my company, we are small job shop that produces specialized trailers for moving shipping containers. Right now we are producing one at a time but want to start upping production to producing a few a week, hence the need for a database. I've seen a lot of great templates for inventory but they all seem tailored to retail where the product is bought, stocked, then sold. In our case we only sell six products but they are made up of kits, other stand alone parts, and possibly one off metal products we might have to manufacture in shop to fit the need of the trailer.
Our trailers are assembled with what we call "kits", kits will be sets of parts we order from other manufactures such as our electronics or hydraulics . These kits are then put on the main frame to make the final assembly. Some kits like the electronics kit are order well ahead of time and kept in stock, but on the other hand things like the hydraulic hoses and the kit that contains bolt-on metal pieces are order one at time so they arrive just before the build.
My boss wants to track everything from the nuts and bolts up to where and what customer the trailer is sold to. I've only made a very small example database before so I'm a bit confused / intimidated on how I want to structure the overall database. I want to be able to know stock levels of all parts along with how many kits we have available. Basically I'm not sure how to map this multilayer production on to a database.
Our trailers are assembled with what we call "kits", kits will be sets of parts we order from other manufactures such as our electronics or hydraulics . These kits are then put on the main frame to make the final assembly. Some kits like the electronics kit are order well ahead of time and kept in stock, but on the other hand things like the hydraulic hoses and the kit that contains bolt-on metal pieces are order one at time so they arrive just before the build.
My boss wants to track everything from the nuts and bolts up to where and what customer the trailer is sold to. I've only made a very small example database before so I'm a bit confused / intimidated on how I want to structure the overall database. I want to be able to know stock levels of all parts along with how many kits we have available. Basically I'm not sure how to map this multilayer production on to a database.