blocker

5 rows where train_id = 151

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ train_id blocked unblocked blocker unblocker removed resolved task url status group_blocked group_unblocked
23 151 151 1623366644 1623367787 James D. Forrester James D. Forrester 0 1 284786 https://phabricator.wikimedia.org/T284786 resolved 2 2
24 151 151 1623162601 1623342842 Bartosz Dziewoński Peter Pelberg 0 1 284567 https://phabricator.wikimedia.org/T284567 resolved -1 1
25 151 151 1623314029 1623321822 Xiplus Urbanecm 0 1 284716 https://phabricator.wikimedia.org/T284716 resolved 1 1
26 151 151 1623268030 1623274949 DannyS712 Amir Sarabadani (WMDE) 0 1 284685 https://phabricator.wikimedia.org/T284685 resolved 1 1
27 151 151 1623097391 1623171894 Bartosz Dziewoński Jon Robson 1 0 284496 https://phabricator.wikimedia.org/T284496 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)
        );