Design help plz
 

Hi all. My first post here. I would like to know if someone can give me some advice on how to model inventory that comes in and goes out and then comes back in again. The inventory is basically loaned out and then returned and re-loaned out again.

I can't model this correctly for some reason. What I would like is to also keep a history of the people that have been loaned this equipment.

Any help would be greatly appreciated.

Tom

Re: Design help plz
 

An Inventory table with the item_id,item_description

A loans table which will contain the item_id of items that have been loaned out, the date out, the return date, and any other info u need, you could also put the customer details in here or even beter in a different customers table.