blocker
5 rows where train_id = 15
This data as json, CSV (advanced)
Suggested facets: blocker, unblocker, removed, resolved, status, group_blocked, group_unblocked
id ▼ | train_id | blocked | unblocked | blocker | unblocker | removed | resolved | task | url | status | group_blocked | group_unblocked |
---|---|---|---|---|---|---|---|---|---|---|---|---|
109 | 15 15 | 1603301353 | 1603302202 | Greg Grossmeier | Pchelolo | 0 | 1 | 266021 | https://phabricator.wikimedia.org/T266021 | resolved | 1 | 1 |
110 | 15 15 | 1603274582 | 1603275322 | Lars Wirzenius | Lars Wirzenius | 1 | 0 | 266108 | https://phabricator.wikimedia.org/T266108 | resolved | 0 | 0 |
111 | 15 15 | 1603215429 | 1603216364 | Ahmon Dancy | Chris Danis | 1 | 0 | 266052 | https://phabricator.wikimedia.org/T266052 | resolved | 0 | 0 |
112 | 15 15 | 1603213532 | 1603216314 | Lars Wirzenius | Chris Danis | 1 | 0 | 266051 | https://phabricator.wikimedia.org/T266051 | resolved | 0 | 0 |
113 | 15 15 | 1602781750 | 1603148107 | Jon Robson | Jon Robson | 1 | 0 | 256173 | https://phabricator.wikimedia.org/T256173 | open | -1 | -1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE blocker ( id INTEGER PRIMARY KEY, train_id INTEGER NOT NULL, blocked INTEGER NOT NULL, unblocked INTEGER, blocker TEXT NOT NULL, unblocker TEXT, removed INTEGER NOT NULL, resolved INTEGER NOT NULL, task INTEGER NOT NULL, url TEXT NOT NULL, status TEXT NOT NULL, group_blocked INTEGER NOT NULL, group_unblocked INTEGER, CHECK (removed IN (0, 1)) CHECK (resolved IN (0, 1)) UNIQUE(train_id,blocked,task) FOREIGN KEY(train_id) REFERENCES train(id) );