blocker

5 rows where train_id = 22

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: blocker, unblocker, group_blocked, group_unblocked

id ▼ train_id blocked unblocked blocker unblocker removed resolved task url status group_blocked group_unblocked
142 22 22 1610567704 1610633645 Timo Tijhof Lars Wirzenius 0 1 271978 https://phabricator.wikimedia.org/T271978 resolved 1 2
143 22 22 1610547914 1610627563 Lars Wirzenius Lars Wirzenius 0 1 271933 https://phabricator.wikimedia.org/T271933 resolved 1 1
144 22 22 1610547935 1610554065 Lars Wirzenius Urbanecm 0 1 271932 https://phabricator.wikimedia.org/T271932 resolved 1 1
145 22 22 1610497778 1610548300 skizzerz Lars Wirzenius 0 1 271873 https://phabricator.wikimedia.org/T271873 resolved 0 1
146 22 22 1610453403 1610543450 Lars Wirzenius ariel 0 1 271804 https://phabricator.wikimedia.org/T271804 resolved -1 0

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