i'm gonna make a forum site, but i don't know how to design the database. The forum will have categories like social, academic, and etc., so i think that i should create different databases for each category. For example database "Social", database "Academic"; and each time when user starts a new thread, for example in "Social" category, the new table will be created in "Social" database, and this table will have columns "repliers_name", "date", and of course "text". So, it is my idea, however i think it's not the optimal and correct way of designing the database for a forum. Any ideas?
you'll want a table for categories, a table for forums (each forum belongs to only one category), a table for members, a table for threads (each thread belongs to only one forum, and each thread has only on member as thread starter), and a table for posts (each post belongs to only one thread and has only one member as poster)