blocker

2 rows where train_id = 154

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ train_id blocked unblocked blocker unblocker removed resolved task url status group_blocked group_unblocked
747 154 154 1626136701 1626858967 Timo Tijhof Daniel Kinzler 1 0 286490 https://phabricator.wikimedia.org/T286490 open -1 0
748 154 154 1626302129 1626364400 Brennen Bearnes Timo Tijhof 1 0 286521 https://phabricator.wikimedia.org/T286521 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)
        );