Before creating the tables in the database, let's first detail what data will be stored and which initial fields will be there in the tables.
For blogging, we will have blog posts or entries and these will have a published date. They will be categorized to enable grouping of similar themes. Each post will be associated with an author (user) and will have content and an excerpt. We can add free-form tagging later.
The following fields exist in the
id(int): This will be the primary identifier
created_at(timestamp): This will be a timestamp of when the record was created
updated_at(timestamp) - This will be a timestamp of when the ...