此结构中的表
userscategoriespoststagspost_tagscomments
表结构（SQL）
MySQL 方言的 DDL。在编辑器中打开可获得可编辑的可视化 ER 图，或直接将 SQL 复制到你的项目中。
CREATE TABLE users (
id INT PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(50) NOT NULL UNIQUE,
email VARCHAR(254) NOT NULL UNIQUE,
display_name VARCHAR(120),
created_at DATETIME NOT NULL
);
CREATE TABLE categories (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(100) NOT NULL,
slug VARCHAR(120) NOT NULL UNIQUE
);
CREATE TABLE posts (
id INT PRIMARY KEY AUTO_INCREMENT,
author_id INT NOT NULL,
category_id INT,
title VARCHAR(200) NOT NULL,
slug VARCHAR(220) NOT NULL UNIQUE,
body TEXT NOT NULL,
status VARCHAR(20) NOT NULL,
published_at DATETIME,
FOREIGN KEY (author_id) REFERENCES users(id),
FOREIGN KEY (category_id) REFERENCES categories(id)
);
CREATE TABLE tags (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(60) NOT NULL UNIQUE
);
CREATE TABLE post_tags (
post_id INT NOT NULL,
tag_id INT NOT NULL,
PRIMARY KEY (post_id, tag_id),
FOREIGN KEY (post_id) REFERENCES posts(id),
FOREIGN KEY (tag_id) REFERENCES tags(id)
);
CREATE TABLE comments (
id INT PRIMARY KEY AUTO_INCREMENT,
post_id INT NOT NULL,
author_id INT,
parent_id INT,
body TEXT NOT NULL,
created_at DATETIME NOT NULL,
FOREIGN KEY (post_id) REFERENCES posts(id),
FOREIGN KEY (author_id) REFERENCES users(id),
FOREIGN KEY (parent_id) REFERENCES comments(id)
);