Table relations

DDL · Prisma · entity relationships · export as mermaid

표 관계 보기

CREATE TABLE 이나 Prisma 스키마를 붙여넣으면 표·칸·이어짐을 그림과 글로 보여 줍니다

CREATE TABLE 이나 Prisma 스키마
요약
표 2개 · 이어짐 1개

[users]  열쇠: id
  id : INT   열쇠
  email : VARCHAR(255)   필수 · 하나뿐
  city_id : INT   → cities

[cities]  열쇠: id
  id : INT   열쇠
  name : VARCHAR(80)   필수
mermaid 원문 (깃허브·노션에 붙이면 그려집니다)
표 2개 · 이어짐 1개

Paste CREATE TABLE statements or a Prisma schema and it draws how the tables reference each other, so you can see at a glance which table points where.

How to use it

  1. Paste CREATE TABLE statements or a Prisma schema
  2. Tables, columns and references are pulled out and drawn
  3. Follow the arrows to see which table points at which
  4. Copy the mermaid erDiagram text into your own docs

Common questions

Which formats does it read?
SQL CREATE TABLE statements and Prisma schemas. From both it pulls only tables, columns and references, and turns them into the same diagram.
Why not just read it by hand?
The first thing you want from a new schema is which table points where, and tracing CREATE TABLE by eye to collect REFERENCES is not work for a human.
Is my schema uploaded anywhere?
No. Reading and drawing both finish inside your browser.

Other tools

Stays on your device What you enter is handled inside your browser only — nothing is stored or sent anywhere.

This tool page states where what you enter goes — see the badge above. All tools · KarmoLab · Who made this · Built with AI. View source