To create REST API or RESTful web service for a blog, we first to have entities. As we will storing blog entities in a database and fetching the data from a database, we first need to create a database schema for those entities.
We are going to create endpoints two resources/entities, which are :
- Blog post
- Post comments
So, we will be creating a database schema for these two resources.
Here is how we will design a database schema for a blog having posts comments. A post can have multiple comments and a comment always belongs to post. Here, we have SQL for the database schema. You will first need to create a database and you will need to run the following SQL to have posts and comments tables. If you haven't created the database, then create it now. You can create it via some DB UI tool, or you can run the following SQL query:
create DATABASE blog;
This will create a database with the name blog
.
Before creating a blog posts table...