Database schema design ====================== database: fmn table: list _id title text table: item _id name table: list_item _id listId quantity table: category _id name table: item_category _id itemId categoryId Things to consider: 1. will need to provide list synchronization - last_modified time for list_item? list? and item? - modifiedBy? - list changes: item added, item deleted, item modified - how do we track when an item is deleted? 2. would like to mark lists and items as private - this needs to be on both the item and the list - categories may be helpful in implementing privacy - allow user to add public items to private list - allow user to add private items to private list - could careate a "Private" category only