I want to create a windows 10 universal to-do app with offline sync capability. So I checked out this tutorial which helped me to get started on the offline functionality. But I was wondering how should I design my Azure database to get data efficiently and moreover I also should have the ability to store images. So here are my questions:
- Is it good to put all the users data in one table? Ex: (Content Table): ID , FK(UserId), Title, Desc, Created , Edited.
- Can I use any indexing technique to efficiently query for the user data as CRUD operations will be very common since it has a sync feature.
If the above is not really a good technique could you please tell me what is the right way to go about it. As I'm not so experienced when it comes to DB designing.