updated database to include assigned_items