Topic: just double checking the validity of my design.
So basically, the app is supposed to allow anyone to signup and create their own customized mini forums and thus becoming admins of their own forum. Each admins create as many forums as they want.
Forums consist of categoory > topic > posts . Anyone can register to as many forums as they want. and they will have a menu to show all of the forums they belong to.
Consist of : Admin.rb, Forum.rb, User.rb, Category.rb, Topic.rb, Post.rb
So in general what the below says is:
One to many b/t Admin and Forums.
Many to Many b/t Forums and Users.
One to many b/t Forum and Categories.
One to many b/t Category and Topics.
One to many b/t Topic and Posts.
Err. thats the easy part. My main dillema is whether or not upon sign up what sort of fields(excluding ids) I should include in the Admin's table as well as User's table.
Should Admin table have things like
OR is the above approach completely wrong?
Instead, should above fields be in their own unique tables? Meaning, forum_title, forum_admin_name would be in the Forum table. and category_title, category_order would be in the Category table.....and so on. And rails be intelligent enough to work out all the relationships??
The latter part I am still unsure of..
Last edited by downwiz2 (2007-04-22 05:06:01)