Skip to main content

Minimal

The smallest useful diagram: two tables and one relationship.

Covers: Two tables, pk, increment, not null, unique, expression default, one inline ref

01-minimal.dbml
01-minimal.dbmlpublic.users.id < public.posts.user_idusersusersid integer · primary key · incrementidintegeremail varchar(255) · unique · not nullemailUNNvarchar(255)created_at timestamp · default: now()created_attimestamppostspostsid integer · primary key · incrementidintegeruser_id integer · foreign key · not nulluser_idNNintegertitle varchar(200) · not nulltitleNNvarchar(200)body textbodytext

Source​

examples/01-minimal.dbml
examples/01-minimal.dbml
// The smallest useful diagram: two tables and one relationship.

Table users {
id integer [pk, increment]
email varchar(255) [not null, unique]
created_at timestamp [default: `now()`]
}

Table posts {
id integer [pk, increment]
user_id integer [not null, ref: > users.id]
title varchar(200) [not null]
body text
}