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 Entries
table:
id
(int): This will be the primary identifiername
(varchar)slug
(varchar)excerpt
(text)content
(text)published_at
(int)created_at
(timestamp): This will be a timestamp of when the record was createdupdated_at
(timestamp) - This will be a timestamp of when the record was last updated