dimanche 21 décembre 2014

Best mysql database structure for this data


I need to create a MySQL database that can store the following data for many users:


General settings (for each user)



  • 10 url's.

  • 10 words of 20 letters for.

  • ...and more fields like these.


Sentences (for each user)



  • Each user could store 100-5000 sentences of 150 words.


ID's (for each user)



  • Each user will have many ids (0-50000) of 15 numbers stored in the DB.


I don't know neither how many tables and fields are required nor what type of field should I use for each type of data. What would you recommend me? I would appreciate any suggestions.





Aucun commentaire:

Enregistrer un commentaire