blocker

5 rows where train_id = 170

✎ 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
786 170 170 1464314454 1464813513 Mukunda Modell Timo Tijhof 1 1 135656 https://phabricator.wikimedia.org/T135656 resolved 2 2
787 170 170 1464813513 1464820116 Timo Tijhof Timo Tijhof 0 1 136738 https://phabricator.wikimedia.org/T136738 resolved 2 2
788 170 170 1464204283 1464205160 Mukunda Modell Gergő Tisza 1 1 136124 https://phabricator.wikimedia.org/T136124 resolved 1 1
789 170 170 1464205160 1464205220 Gergő Tisza Gergő Tisza 1 0 136233 https://phabricator.wikimedia.org/T136233 duplicate 1 1
790 170 170 1463598270 1463675450 Timo Tijhof Bartosz Dziewoński 1 0 121793 https://phabricator.wikimedia.org/T121793 declined -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)
        );