Inv_Lot_Attr

Rename "item_id" to "inv_lot_item_id" and "lot_no" to "inv_lot_lot_no" so column names are unique when joined with other tables.

Replace foreign key from "item_id" to item with one from "inv_lot_item_id", "inv_lot_lot_no" to lot. Remains cascade-delete.