blocker

3 rows where train_id = 7

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: blocker, removed, resolved, group_blocked, group_unblocked

id ▼ train_id blocked unblocked blocker unblocker removed resolved task url status group_blocked group_unblocked
78 7 7 1597157332 1597168113 Antoine "hashar" Musso Tyler Cipriani 0 1 260145 https://phabricator.wikimedia.org/T260145 resolved -1 0
79 7 7 1597160960 1597164941 Antoine "hashar" Musso Antoine "hashar" Musso 1 0 260155 https://phabricator.wikimedia.org/T260155 resolved 0 0
80 7 7 1596713504 1596876820 Lucas Werkmeister (WMDE) Taavi Väänänen 1 0 259744 https://phabricator.wikimedia.org/T259744 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)
        );