The easiest way to do the item_log table (if I understand your question correctly) is to only have the item_id and your checkoutlog_id. That way when you do an sql query, you can identify the logs by their id and match it to the item_id that is required. Can you explain more in detail what you are trying to do so that I can aid you more precisely?
 

The best way to go about this problem is to think of your tables as the values that you use in you models, so you should have a column for the same types that you have in your class. the only difference here is that instead of having a List in your item class, you have to do a collection table in your sql, like I mentioned in the earlier post. so for your checkout logs, your table should reflect that of the class. You can refer to SQL and MySQL lecture notes, slide 17 to get an understanding of how your tables should look. There is also an example table to refer to in slide 3.

No I got it, I just didn't think to put an available column in the items table because I thought we weren't supposed to make columns for information that can be derived from other tables. I think I got what I needed to finish thanks!