blocker

4 rows where train_id = 42

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ train_id blocked unblocked blocker unblocker removed resolved task url status group_blocked group_unblocked
235 42 42 1576676229 1576684972 James D. Forrester James D. Forrester 0 1 241059 https://phabricator.wikimedia.org/T241059 resolved 0 1
236 42 42 1576674883 1576680812 James D. Forrester James D. Forrester 0 1 241057 https://phabricator.wikimedia.org/T241057 resolved 0 1
237 42 42 1576616854 1576666457 Timo Tijhof James D. Forrester 1 0 240961 https://phabricator.wikimedia.org/T240961 resolved 0 0
238 42 42 1576617476 1576649647 Timo Tijhof Timo Tijhof 1 0 240997 https://phabricator.wikimedia.org/T240997 resolved 0 0

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)
        );