blocker

4 rows where train_id = 155

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: blocker, unblocker, status, group_blocked, group_unblocked

id ▼ train_id blocked unblocked blocker unblocker removed resolved task url status group_blocked group_unblocked
749 155 155 1626304897 1626362373 Ahmon Dancy Ahmon Dancy 1 0 286679 https://phabricator.wikimedia.org/T286679 open 1 1
750 155 155 1626208797 1626302129 Ahmon Dancy Brennen Bearnes 1 0 286521 https://phabricator.wikimedia.org/T286521 resolved -1 1
751 155 155 1625243321 1626206802 Timo Tijhof Jon Robson 1 0 286040 https://phabricator.wikimedia.org/T286040 resolved -1 -1
752 155 155 1625375735 1625420994 DannyS712 Brennen Bearnes 1 0 286140 https://phabricator.wikimedia.org/T286140 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)
        );