TdlM / taskmaster

Menu
  • Make shortlink

team_tasks

2 rows where task = 233

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ task team win
39 Identify the link and do it 100 times 233 Alice and Russell 11
40 Identify the link and do it 100 times 233 Asim, Liza and Tim 12 ✓

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.777ms