vendredi 27 février 2015

Android SQLite tables realationship questions

Okay I am no good with databases. I have one table that consist of user details which is unique id, username, password and his name. Once the user logs in, how do I relate the user's data back to him so that all data associated to his ID returns when he request it?


Example user wants to add ToDo task on the database, and return ToDo's through listView. Do I create new table that contains something like this when FOREIGN KEY (userId) REFERENCES members(_id) and can I create multiple tables to reference to my members table?


Sorry for the basic questions I have just recently started developing in Android and using SQL


Aucun commentaire:

Enregistrer un commentaire