TdlM / taskmaster

Menu
  • Make shortlink

team_tasks

2 rows where task = 769

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ task team win
179 Cross the finish line while connected to your team 769 Sue and Susan 35
180 Cross the finish line while connected to your team 769 Julian, Lucy and Sam 36 ✓

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE team_tasks (
   id   INTEGER PRIMARY KEY,
   task INTEGER REFERENCES tasks(id),
   team INTEGER REFERENCES teams(id),
   win  INTEGER
);
Powered by Datasette · Queries took 4.625ms