Need help with a simple DB design

[Rocco Moretto]

I need help with a simple db design.
Very New to DB Design. I'm close but need help.

The solution I need to create revolves around a fleet of three trucks.
Each truck has numerous compartments that hold a specific quantities of specific items. I know the items and I know the amount of each item that should be in each compartment.

I need to create a db that shows the static information of each compartment (quantities and items)

Once I have this static information in my DB. Using a LAMP stack, which I have in place already. I'll need to audit each compartment by truck, to see where I need to adjust the quantity and items to be back to their normal levels.

I want to keep the static part of the DB intact and create audit tables to show what is needed, so I can report on it.

I'm only asking for help designing the static part of the DB for now.