blocker

7 rows where train_id = 5

✎ 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
66 5 5 1596147798 1596478391 Brennen Bearnes Subramanya Sastry 0 1 259311 https://phabricator.wikimedia.org/T259311 resolved 1 2
67 5 5 1596474434 1596475521 Brennen Bearnes Brennen Bearnes 1 0 259536 https://phabricator.wikimedia.org/T259536 invalid 1 1
68 5 5 1596136799 1596148581 Brennen Bearnes Brennen Bearnes 1 0 258609 https://phabricator.wikimedia.org/T258609 resolved 1 1
69 5 5 1596107380 1596108823 Lars Wirzenius Urbanecm 1 0 259246 https://phabricator.wikimedia.org/T259246 resolved 1 1
70 5 5 1596029130 1596107404 Lars Wirzenius Lars Wirzenius 1 0 259126 https://phabricator.wikimedia.org/T259126 resolved 1 1
71 5 5 1596047142 1596050581 Lars Wirzenius Brennen Bearnes 1 0 259175 https://phabricator.wikimedia.org/T259175 resolved 0 0
72 5 5 1595942094 1595943548 Lars Wirzenius Lars Wirzenius 1 0 259023 https://phabricator.wikimedia.org/T259023 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)
        );