blocker

3 rows where train_id = 153

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: removed, resolved, group_blocked, group_unblocked

id ▼ train_id blocked unblocked blocker unblocker removed resolved task url status group_blocked group_unblocked
15 153 153 1625219939 1625222370 James D. Forrester James D. Forrester 0 1 285579 https://phabricator.wikimedia.org/T285579 resolved 2 2
16 153 153 1625151920 1625169434 Brennen Bearnes Brennen Bearnes 1 0 285951 https://phabricator.wikimedia.org/T285951 resolved 1 2
17 153 153 1625154932 1625156633 Sam Reed Sam Reed 1 0 285959 https://phabricator.wikimedia.org/T285959 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)
        );