TdlM / taskmaster

Menu
  • Make shortlink

team_tasks

2 rows where task = 238

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ task team win
41 Knock over the ducks without leaving the carpet 238 Alice and Russell 11
42 Knock over the ducks without leaving the carpet 238 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 5.429ms