blocker

5 rows where train_id = 11

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ train_id blocked unblocked blocker unblocker removed resolved task url status group_blocked group_unblocked
83 11 11 1600280224 1600333696 Jon Robson Gilles Dubuc 0 1 263047 https://phabricator.wikimedia.org/T263047 resolved 1 1
84 11 11 1600270457 1600282440 Brennen Bearnes Brennen Bearnes 1 0 263034 https://phabricator.wikimedia.org/T263034 resolved 1 1
85 11 11 1600252796 1600253489 Lars Wirzenius Lars Wirzenius 1 0 263014 https://phabricator.wikimedia.org/T263014 resolved 0 0
86 11 11 1600159716 1600251334 Lars Wirzenius Lars Wirzenius 0 1 262900 https://phabricator.wikimedia.org/T262900 resolved -1 -1
87 11 11 1600199369 1600199389 Timo Tijhof Timo Tijhof 0 1 258001 https://phabricator.wikimedia.org/T258001 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)
        );