SQL to ERD — Your Schema, Visualized

CREATE TABLE users (
    id         BIGINT PRIMARY KEY,
    name       VARCHAR(255) NOT NULL,
    email      VARCHAR(255) UNIQUE,
    created_at TIMESTAMP
);

CREATE TABLE posts (
    id         BIGINT PRIMARY KEY,
    user_id    BIGINT REFERENCES users(id),
    title      VARCHAR(255) NOT NULL,
    published  BOOLEAN DEFAULT false
);

CREATE TABLE comments (
    id         BIGINT PRIMARY KEY,
    post_id    BIGINT REFERENCES posts(id),
    user_id    BIGINT REFERENCES users(id),
    body       TEXT NOT NULL
);