Name: Drizzle Erd
Author: hiroppy

Drizzle Erd | Skills Pool

erDiagram
    TABLE_NAME {
        type column_name PK "Primary Key"
        type column_name FK "Foreign Key"
        type column_name UK "Unique"
        type column_name "nullable"
    }

    TABLE_A ||--o{ TABLE_B : "has many"
    TABLE_A ||--|| TABLE_C : "has one"
    TABLE_A }o--|| TABLE_D : "belongs to"

erDiagram
    %% Master Tables

    %% Transaction Tables

    %% Snapshot Tables

    %% Relations

export const users = sqliteTable("users", {
  id: integer("id").primaryKey(),
  name: text("name").notNull(),
  email: text("email").unique(),
});

export const posts = sqliteTable("posts", {
  id: integer("id").primaryKey(),
  userId: integer("user_id").references(() => users.id),
  title: text("title").notNull(),
});

erDiagram
    users {
        int id PK
        string name
        string email UK
    }

    posts {
        int id PK
        int user_id FK
        string title
    }

    users ||--o{ posts : "has many"

%% === Master Tables ===
%% === Transaction Tables ===

Symbol	Meaning
`\|\|`	Exactly one
`o\|`	Zero or one
`}o`	Zero or many
`}\|`	One or many

Drizzle	Mermaid
`text()`	string
`integer()`	int
`real()`	float
`blob()`	blob
`boolean` mode	boolean

Drizzle Erd

Drizzle ERD Generator

When to Use

Process

Mermaid ERD Syntax

Drizzle Erd

Drizzle ERD Generator

When to Use

Process

Mermaid ERD Syntax

Relationship Notation

Type Mapping

Output Template

Example

Quick Reference

Column Markers

Grouping

Postgres Patterns

Postgres Patterns

Database Migrations

Postgres Patterns

Postgres Patterns

Jpa Patterns