blocker

3 rows where train_id = 91

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unblocker, group_blocked, group_unblocked

id ▼ train_id blocked unblocked blocker unblocker removed resolved task url status group_blocked group_unblocked
501 91 91 1541674033 1541708282 Amir Sarabadani (WMDE) Tyler Cipriani 0 1 209036 https://phabricator.wikimedia.org/T209036 resolved 1 1
502 91 91 1541622785 1541628982 Tyler Cipriani Tyler Cipriani 0 1 208995 https://phabricator.wikimedia.org/T208995 resolved 1 1
503 91 91 1541457706 1541468186 James D. Forrester James D. Forrester 0 1 208809 https://phabricator.wikimedia.org/T208809 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)
        );