These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Task & Kanban Board
- Data model
The tables behind Task & Kanban Board
Task & Kanban Board ships with 21 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 21
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Boards and workflow
Boards, board memberships, Columns, Swimlanes, Tasks.
Tasks and ownership
Tasks, task assignees, Users, import jobs, notification deliveries.
Checklists and dependencies
Task checklist items, task dependencies, Tasks, task events.
Reviews and approvals
Transition requests, Tasks, Columns, task checklist items, task events.
Team collaboration
Task comments, task attachments, task participants, board memberships, notification deliveries.
Flow insights
Board snapshots, task events, Tasks, notification deliveries.
Every table, by feature
- Boards and workflow5
- Tasks and ownership5
- Checklists and dependencies4
- Reviews and approvals5
- Team collaboration5
- Flow insights4
- Shared and settings4
- Boards
The team workflow container; existing tasks preserve reviewed workflow revisions.
Linked to Teams, Users - Board memberships
Board-specific role and scope; deactivation removes effective access immediately.
Linked to Boards, Users - Columns
Ordered workflow columns; task status derives from the current column category.
Linked to Boards - Swimlanes
Optional custom board lanes; owner and priority modes derive lanes from task fields.
Linked to Boards - Tasks
Canonical work item. One column owns the workflow position; filters and lanes never duplicate the task.
Linked to Boards, Columns, Swimlanes, Users
- Tasks
Canonical work item. One column owns the workflow position; filters and lanes never duplicate the task.
Linked to Boards, Columns, Swimlanes, Users - Task assignees
Additional collaborators on a task; Owner remains the single accountable person.
Linked to Tasks, Users - Users
Authenticated users in this workspace; contact addresses never grant a role.
- Import jobs
Previewed task imports into one board; rows retain stable source identity on resulting Tasks.
Linked to Boards, Users - Notification deliveries
Observable reminder and mention delivery attempts; delivery does not approve or complete a task.
Linked to Tasks, Users
- Task checklist items
Concrete steps required to complete a task; completion carries the acting identity and time.
Linked to Tasks, Users - Task dependencies
One canonical blocking edge; inverse labels are derived views, not independent edges.
Linked to Tasks, Users - Tasks
Canonical work item. One column owns the workflow position; filters and lanes never duplicate the task.
Linked to Boards, Columns, Swimlanes, Users - Task events
Append-only task changes and completed cycle evidence.
Linked to Tasks, Boards, Users, Columns
- Transition requests
Independent review of a specific task revision and destination; the request is not a completed move.
Linked to Tasks, Columns, Users - Tasks
Canonical work item. One column owns the workflow position; filters and lanes never duplicate the task.
Linked to Boards, Columns, Swimlanes, Users - Columns
Ordered workflow columns; task status derives from the current column category.
Linked to Boards - Task checklist items
Concrete steps required to complete a task; completion carries the acting identity and time.
Linked to Tasks, Users - Task events
Append-only task changes and completed cycle evidence.
Linked to Tasks, Boards, Users, Columns
- Task comments
Discussion inherits the task audience; attachments and mentions cannot grant access.
Linked to Tasks, Users - Task attachments
Protected files with the task’s effective access boundary.
Linked to Tasks, Users - Task participants
Explicit shared-task guest access; cannot widen the parent board audience.
Linked to Tasks, Users - Board memberships
Board-specific role and scope; deactivation removes effective access immediately.
Linked to Boards, Users - Notification deliveries
Observable reminder and mention delivery attempts; delivery does not approve or complete a task.
Linked to Tasks, Users
- Board snapshots
Dated board metrics derived from retained events and explicit cycle definitions.
Linked to Boards - Task events
Append-only task changes and completed cycle evidence.
Linked to Tasks, Boards, Users, Columns - Tasks
Canonical work item. One column owns the workflow position; filters and lanes never duplicate the task.
Linked to Boards, Columns, Swimlanes, Users - Notification deliveries
Observable reminder and mention delivery attempts; delivery does not approve or complete a task.
Linked to Tasks, Users
Keys and references
Task current column owns position and derives Status. Child rows belong to the canonical task, and board references agree. Transition requests binds task and workflow revisions. Task events uniquely records operations and numbered cycles. Import jobs plus source row identity prevents duplicate creation.
Migration order
- Map verified Users, Teams and explicit board memberships; test guest restrictions.
- Load Boards, Columns, Swimlanes and Labels with reviewed moves and WIP policies.
- Review import mappings and reconcile owner, position, dates and source row identity.
- Load checklists, directed dependencies and protected conversation without widening audiences.
- Preserve task cycles and events; do not invent historical timing from current fields.
- Configure notifications; verify independent review, concurrent WIP, guest revocation and repeated imports.
Set up Task & Kanban Board your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.