blocker

6 rows where train_id = 228

✎ View and edit SQL

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
1002 228 228 1630014419 1630019917 Brennen Bearnes AlexisJazz 1 1 289792 https://phabricator.wikimedia.org/T289792 invalid -1 -1
1003 228 228 1630077904 1630528113 Ahmon Dancy Mukunda Modell 1 0 289697 https://phabricator.wikimedia.org/T289697 open -1 1
1004 228 228 1630074992 1630525003 Ahmon Dancy Mukunda Modell 1 0 289806 https://phabricator.wikimedia.org/T289806 open -1 0
1005 228 228 1630441848 1630523935 Timo Tijhof Jon Robson 1 0 262067 https://phabricator.wikimedia.org/T262067 open 0 0
1006 228 228 1630469747 1630495215 Mukunda Modell Timo Tijhof 0 1 290120 https://phabricator.wikimedia.org/T290120 resolved 0 0
1007 228 228 1629915967 1630073978 Brennen Bearnes Bartosz Dziewoński 0 1 289625 https://phabricator.wikimedia.org/T289625 resolved -1 -1

Advanced export

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

CSV options: 

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)
        );