blocker

6 rows where train_id = 12

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unblocked, 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
88 12 12 1600957945 1600963461 Urbanecm Urbanecm 0 1 263750 https://phabricator.wikimedia.org/T263750 resolved 1 1
89 12 12 1600885097 1600903817 Tyler Cipriani Ahmon Dancy 1 0 263675 https://phabricator.wikimedia.org/T263675 resolved 0 1
90 12 12 1600871243 1600876733 James D. Forrester Urbanecm 1 1 263642 https://phabricator.wikimedia.org/T263642 resolved 0 0
91 12 12 1600864642 1600903817 Mukunda Modell Ahmon Dancy 1 0 263601 https://phabricator.wikimedia.org/T263601 resolved 0 1
92 12 12 1600808526 1600903817 Mukunda Modell Ahmon Dancy 1 0 263592 https://phabricator.wikimedia.org/T263592 open 0 1
93 12 12 1600253549 1600634879 James D. Forrester DannyS712 1 1 263014 https://phabricator.wikimedia.org/T263014 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)
        );