ty1903 Posted February 4, 2011 Share Posted February 4, 2011 I am working on task manager website(a to-do list) but having difficult time on creating my database tables. a school will be using this site so there will be thousands of people using this site. for this reason database must well organized and should easily retrieve the data. in this website students will register and create an account. they will be able to create/delete unlimited categories. under these categories they can create/delete unlimited tasks. users can also create/delete unlimited tags. Tasks will be assigned to these tags. here is what i got, let me know what do u think? user table unique_id name email ----------------- Category Table category_uniqe_id unique_id (foreign key)(where I contact to user table) category_title task list table task_unique_id category_uniqe_id (foreign key) task_title tag table tag_unique_id task_uniqe_id (foreign key) tag_title if i use above schema, there might be millions of row under every table but user table, and that will cause large database… what is the best way to set this up? Thanks in advance. Quote Link to comment Share on other sites More sharing options...
coupe-r Posted February 4, 2011 Share Posted February 4, 2011 Well, that is the only way you can really do it. If you are worried about large DBs, look into performance areas such as indexing and partitioning. I will recommend 2 more columns for each table... deleteStatus <-- Will allow you to "delete" records without actually deleting them createdDate <-- Will show you the date and time of when the record was created. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.