blocker

6 rows where train_id = 149

✎ 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
59 149 149 1621450145 1621519849 Timo Tijhof Antoine "hashar" Musso 0 1 283196 https://phabricator.wikimedia.org/T283196 resolved 0 1
60 149 149 1621435553 1621519809 Antoine "hashar" Musso Antoine "hashar" Musso 0 1 283167 https://phabricator.wikimedia.org/T283167 resolved 1 1
61 149 149 1621438171 1621449187 Zabe Giacomo Alessandroni 0 1 283170 https://phabricator.wikimedia.org/T283170 resolved 1 0
62 149 149 1621438420 1621438493 Ahmon Dancy Zabe 0 0 283171 https://phabricator.wikimedia.org/T283171 duplicate 1 1
63 149 149 1621273110 1621279696 James D. Forrester Jon Robson 1 0 283014 https://phabricator.wikimedia.org/T283014 resolved -1 -1
64 149 149 1620937214 1621014350 Ahmon Dancy Umherirrender 0 1 282825 https://phabricator.wikimedia.org/T282825 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)
        );