logo
ExamplesEditorPricingDocs
37.1kSign in

Trello kanban board database schema

How a kanban board app models its data: boards, lists and cards with fractional positions, labels, checklists and check items, card members and watchers, attachments and covers, power-ups, templates and an activity feed.

Trello Boards ER diagram

Trello kanban board database schema n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 users idBIGINT usernameVARCHAR emailVARCHAR full_nameVARCHAR avatar_urlVARCHAR timezoneVARCHAR created_atTIMESTAMPTZ boards idBIGINT nameVARCHAR descriptionTEXT owner_idBIGINT visibilityVARCHAR backgroundVARCHAR is_templateBOOLEAN template_source_b…BIGINT closed_atTIMESTAMPTZ created_atTIMESTAMPTZ board_members board_idBIGINT user_idBIGINT roleVARCHAR starredBOOLEAN joined_atTIMESTAMPTZ lists idBIGINT board_idBIGINT nameVARCHAR positionNUMERIC wip_limitSMALLINT subscribedBOOLEAN archived_atTIMESTAMPTZ created_atTIMESTAMPTZ cards idBIGINT board_idBIGINT list_idBIGINT short_linkCHAR nameVARCHAR descriptionTEXT positionNUMERIC due_atTIMESTAMPTZ start_atTIMESTAMPTZ due_completeBOOLEAN coverJSONB subscribed_countINTEGER archived_atTIMESTAMPTZ created_by_idBIGINT created_atTIMESTAMPTZ updated_atTIMESTAMPTZ labels idBIGINT board_idBIGINT nameVARCHAR colorVARCHAR positionNUMERIC card_labels card_idBIGINT label_idBIGINT added_atTIMESTAMPTZ checklists idBIGINT card_idBIGINT nameVARCHAR positionNUMERIC source_checklist_…BIGINT check_items idBIGINT checklist_idBIGINT nameVARCHAR positionNUMERIC checked_atTIMESTAMPTZ checked_by_idBIGINT due_atTIMESTAMPTZ assignee_idBIGINT card_members card_idBIGINT user_idBIGINT relationVARCHAR added_atTIMESTAMPTZ attachments idBIGINT card_idBIGINT uploaded_by_idBIGINT kindVARCHAR storage_keyVARCHAR urlVARCHAR filenameVARCHAR mime_typeVARCHAR byte_sizeBIGINT created_atTIMESTAMPTZ board_power_ups board_idBIGINT power_up_keyVARCHAR settingsJSONB enabled_by_idBIGINT enabled_atTIMESTAMPTZ card_activity idBIGINT board_idBIGINT card_idBIGINT actor_idBIGINT actionVARCHAR dataJSONB created_atTIMESTAMPTZ

Related database schemas

PostgreSQL
Productivity

Calendar and scheduling database schema

How a calendar app models its data: calendars and sharing, events with their own time zones, RRULE recurrence with exception dates and per-occurrence overrides, attendees and RSVP, reminders, working hours and a free-busy index.

PostgreSQL
Productivity

Dropbox-style file storage & sync database schema

How a cloud drive models its data: a folder tree, versioned files, content-addressed blocks that deduplicate identical uploads to a single copy, shares and expiring public links, per-device sync cursors, trash retention and quota accounting.

SQLite
Productivity

Habit tracker app database schema

A small local-first SQLite schema for habit tracking: habits with date-versioned schedules, one row per completion, pauses that skip a streak instead of breaking it, reminders, and streaks derived from check-ins rather than stored as a counter.

SQLite
Productivity

Note-taking app database schema with backlinks

A local-first SQLite notes database: notebooks and notes, wiki-style backlinks parsed from note bodies into a link graph, tags, attachments, a full-text search index, revision history and last-writer-wins sync with a conflict record.