blocker

7 rows where train_id = 227

✎ 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
995 227 227 1630006640 1630010728 AlexisJazz Brennen Bearnes 1 0 289792 https://phabricator.wikimedia.org/T289792 open 2 2
996 227 227 1629919586 1629929393 Brennen Bearnes Urbanecm 0 1 289717 https://phabricator.wikimedia.org/T289717 resolved 0 0
997 227 227 1629920422 1629929148 Brennen Bearnes Zabe 0 1 289730 https://phabricator.wikimedia.org/T289730 resolved 0 0
998 227 227 1629919956 1629925407 Brennen Bearnes Urbanecm 0 1 289728 https://phabricator.wikimedia.org/T289728 resolved 0 0
999 227 227 1629903295 1629906457 Will Doran BPirkle 1 0 289692 https://phabricator.wikimedia.org/T289692 resolved 0 0
1000 227 227 1629260277 1629815735 Timo Tijhof Jon Robson 1 0 287410 https://phabricator.wikimedia.org/T287410 open -1 -1
1001 227 227 1629235327 1629248293 Timo Tijhof Jon Robson 0 1 89981 https://phabricator.wikimedia.org/T89981 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)
        );