blocker

4 rows where train_id = 265

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unblocker, removed, resolved, status, group_blocked, group_unblocked

id ▼ train_id blocked unblocked blocker unblocker removed resolved task url status group_blocked group_unblocked
1218 265 265 1655402302 1655405028 Brennen Bearnes Brennen Bearnes 0 1 310747 https://phabricator.wikimedia.org/T310747 resolved 1 1
1219 265 265 1655141602 1655260257 Tyler Cipriani Tim Starling 0 1 310532 https://phabricator.wikimedia.org/T310532 resolved -1 -1
1220 265 265 1655216190 1655224666 James D. Forrester Brennen Bearnes 1 0 212129 https://phabricator.wikimedia.org/T212129 resolved -1 -1
1221 265 265 1654897806 1654911399 Jon Robson Seddon 1 0 310401 https://phabricator.wikimedia.org/T310401 open -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)
        );