This type of site is going to be required for blogger ( also developer ) who wants to do personal journaling without complexity of CMS like wordpress and has the flexibility of improving the site with additional features.
This post will have all the links of step by step implementation of topic based community site with database tables - communities, topics, posts, comments and users.
Here are list of features we will be crafting one after another.
Layout
1. Adding boostrap ui with auth.
2. Creating and passing dynamic meta title and description to the relevant pages.
3. Adding menu links and making available based on authentication.
Under Authentication
Topic
1. Adding topic data.
2. Editing topic data.
3. Deleting topic data.
Community
1. Adding community and topic with validation
2. Editing community and topic with validation
3. Browsing community data with topic
4. Deleting community with topics
5. Searching posts in a topic under community.
6. Searching posts only under topic.
Post
1. Adding post under a topic within a community from browsing list of posts in a topic under a community
2. Editing a post
3. Adding comment under a post
4. Browsing all comments under a post
Mass Delete
1. Deleting posts with comments
2. Deleting topics with posts and comments
3. Deleting community with topics, posts and comments
Permission
1. Permission of edit for only those users who is the author
2. Permission of delete posts who are author and community creator
Outside Authentication
Home
1. Listing all posts.
2. Searching posts from all topics and communities.