blocker

6 rows where train_id = 239

✎ 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
1066 239 239 1639599707 1639664162 Antoine "hashar" Musso Martin Urbanec / Urbanecm 0 1 297827 https://phabricator.wikimedia.org/T297827 resolved 1 0
1067 239 239 1639600603   Antoine "hashar" Musso null 0 0 297828 https://phabricator.wikimedia.org/T297828 open 1 2
1068 239 239 1639073450 1639586075 Roan Kattouw Antoine "hashar" Musso 0 1 297421 https://phabricator.wikimedia.org/T297421 resolved -1 0
1069 239 239 1639432205 1639516991 Roan Kattouw Elena 0 1 297529 https://phabricator.wikimedia.org/T297529 resolved -1 0
1070 239 239 1639169371   Ahmon Dancy null 0 0 297517 https://phabricator.wikimedia.org/T297517 open -1 2
1071 239 239 1639065660 1639073462 Jon Robson Roan Kattouw 1 0 251974 https://phabricator.wikimedia.org/T251974 open -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)
        );