blocker

5 rows where train_id = 15

✎ 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
109 15 15 1603301353 1603302202 Greg Grossmeier Pchelolo 0 1 266021 https://phabricator.wikimedia.org/T266021 resolved 1 1
110 15 15 1603274582 1603275322 Lars Wirzenius Lars Wirzenius 1 0 266108 https://phabricator.wikimedia.org/T266108 resolved 0 0
111 15 15 1603215429 1603216364 Ahmon Dancy Chris Danis 1 0 266052 https://phabricator.wikimedia.org/T266052 resolved 0 0
112 15 15 1603213532 1603216314 Lars Wirzenius Chris Danis 1 0 266051 https://phabricator.wikimedia.org/T266051 resolved 0 0
113 15 15 1602781750 1603148107 Jon Robson Jon Robson 1 0 256173 https://phabricator.wikimedia.org/T256173 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)
        );