Skip to main content

Sticky notes

Sticky notes on the canvas: single-line, multi-line, colored, transparent (color: none), with custom properties, alongside a table note for contrast.

Covers: Sticky notes: single-line, multi-line, color, transparent color: none, custom properties; contrasted with a table note

07-sticky-notes.dbml
07-sticky-notes.dbmlsingle_line_noteThis is a single line notemultiple_lines_noteThis is a multiple lines noteThis string can span overmultiple lines. - job_runs are pruned after 90days- exit_code null means the runis still goingreminderRemember to add a retry_countcolumn before the v2 schedulerships.floating_titleSchedulerreview_statusReviewed by the platform teamin Q3.public.jobs.id < public.job_runs.job_idjobs Table note: belongs to the table, not to the canvas.jobshas noteid integer · primary key · incrementidintegername varchar(100) · not nullnameNNvarchar(100)schedule varchar(64) cron expressionschedulevarchar(64)last_run_at timestamplast_run_attimestampjob_runsjob_runsid bigint · primary key · incrementidbigintjob_id integer · foreign key · not nulljob_idNNintegerstarted_at timestamp · not nullstarted_atNNtimestampfinished_at timestampfinished_attimestampexit_code integerexit_codeinteger

Source​

examples/07-sticky-notes.dbml
examples/07-sticky-notes.dbml
// Sticky notes on the canvas: single-line, multi-line, colored, transparent
// (color: none), with custom properties, alongside a table note for contrast.

Table jobs {
id integer [pk, increment]
name varchar(100) [not null]
schedule varchar(64) [note: 'cron expression']
last_run_at timestamp

Note: 'Table note: belongs to the table, not to the canvas.'
}

Table job_runs {
id bigint [pk, increment]
job_id integer [not null, ref: > jobs.id]
started_at timestamp [not null]
finished_at timestamp
exit_code integer
}

Note single_line_note {
'This is a single line note'
}

Note multiple_lines_note {
'''
This is a multiple lines note
This string can span over multiple lines.

- job_runs are pruned after 90 days
- exit_code null means the run is still going
'''
}

Note reminder [color: #F4D03F] {
'Remember to add a retry_count column before the v2 scheduler ships.'
}

Note floating_title [color: none] {
'Scheduler'
}

Note review_status [author: 'docs', reviewed: false, color: #AED6F1] {
'Reviewed by the platform team in Q3.'
}