blocker

6 rows where train_id = 14

✎ 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
103 14 14 1602717495 1602788507 Jon Robson Jon Robson 1 0 256173 https://phabricator.wikimedia.org/T256173 open 1 1
104 14 14 1602770335 1602777313 Urbanecm Urbanecm 0 1 265606 https://phabricator.wikimedia.org/T265606 resolved 1 1
105 14 14 1602748863 1602772152 DannyS712 Urbanecm 1 0 265570 https://phabricator.wikimedia.org/T265570 resolved 1 1
106 14 14 1602699435 1602718745 Jon Robson James D. Forrester 0 1 263599 https://phabricator.wikimedia.org/T263599 resolved 0 1
107 14 14 1602708007 1602711427 Jon Robson Jon Robson 0 1 265543 https://phabricator.wikimedia.org/T265543 resolved 0 0
108 14 14 1602192151 1602619164 Antoine "hashar" Musso Dan Duvall 1 1 263177 https://phabricator.wikimedia.org/T263177 resolved -1 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)
        );