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
- Paste CREATE TABLE statements or a Prisma schema
- Tables, columns and references are pulled out and drawn
- Follow the arrows to see which table points at which
- 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