Database Schema Designer
Visual entity-relationship diagram builder. Drag tables, define columns with types and constraints, draw relationships. Export as SQL CREATE statements, Prisma schema, or download the diagram as PNG.
4Tables
16Total Columns
3Relationships
Templates:
Relationships
posts.user_idusers.idOne-to-Manycomments.post_idposts.idOne-to-Manycomments.user_idusers.idOne-to-Manyschema.sql
CREATE TABLE users (id SERIAL PRIMARY KEY,name VARCHAR(255) NOT NULL,email VARCHAR(255) NOT NULL UNIQUE,created_at TIMESTAMP NOT NULL DEFAULT NOW());CREATE TABLE posts (id SERIAL PRIMARY KEY,title VARCHAR(255) NOT NULL,body TEXT NOT NULL,user_id INT NOT NULL,created_at TIMESTAMP NOT NULL DEFAULT NOW(),FOREIGN KEY (user_id) REFERENCES users(id));CREATE TABLE comments (id SERIAL PRIMARY KEY,post_id INT NOT NULL,user_id INT NOT NULL,body TEXT NOT NULL,created_at TIMESTAMP NOT NULL DEFAULT NOW(),FOREIGN KEY (post_id) REFERENCES posts(id),FOREIGN KEY (user_id) REFERENCES users(id));CREATE TABLE categories (id SERIAL PRIMARY KEY,name VARCHAR(255) NOT NULL UNIQUE);