Blog design

Set up author, post and tag tables and write skeleton queries.

In this project you will build a blog database. First step: create the posts table.

CREATE TABLE posts (
  id INT PRIMARY KEY,
  title VARCHAR(200),
  body TEXT,
  author_id INT
);

Skeleton of the posts table.

The table posts is created.

Blog design — details

TEXT is for long text, VARCHAR for bounded text. author_id will be a foreign key.

The posts table has a VARCHAR for the title, TEXT for the body, author_id to link the author and a status column.

Create posts with id, title, body and author_id.

Show example solution

CREATE TABLE posts (
  id INT PRIMARY KEY,
  title VARCHAR(200),
  body TEXT,
  author_id INT
)

Add PRIMARY KEY

CREATE TABLE posts (
  id INT ____,
  title VARCHAR(200)
);

Show answer

CREATE TABLE posts (
  id INT PRIMARY KEY,
  title VARCHAR(200)
);

Next lesson: Post list