🗺️ 스키마 시각화

SQL DDL에서 ERD 요약과 Mermaid 다이어그램을 생성합니다

SQL DDL 입력

users

idINT PRIMARY KEYPK

emailVARCHAR(255) NOT NULL

created_atTIMESTAMP

projects

idINT PRIMARY KEYPK

owner_idINT

nameVARCHAR(120)

created_atTIMESTAMP

Foreign Keys

owner_id → users.id

project_members

idINT PRIMARY KEYPK

project_idINT

user_idINT

roleVARCHAR(40)

Foreign Keys

project_id → projects.id
user_id → users.id

Mermaid 출력

erDiagram
  USERS {
INT PRIMARY KEY id PK
VARCHAR(255) NOT NULL email
TIMESTAMP created_at
  }
  PROJECTS {
INT PRIMARY KEY id PK
INT owner_id
VARCHAR(120) name
TIMESTAMP created_at
  }
  PROJECT_MEMBERS {
INT PRIMARY KEY id PK
INT project_id
INT user_id
VARCHAR(40) role
  }
  PROJECTS }o--|| USERS : "owner_id"
  PROJECT_MEMBERS }o--|| PROJECTS : "project_id"
  PROJECT_MEMBERS }o--|| USERS : "user_id"