blocker

3 rows where train_id = 390

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: group_blocked, group_unblocked

id ▼ train_id blocked unblocked blocker unblocker removed resolved task url status group_blocked group_unblocked
1560 390 390 1740615366 1740686481 Bryan Davis Bartosz Dziewoński 1 0 387414 https://phabricator.wikimedia.org/T387414 duplicate 1 1
1561 390 390 1740593957 1740686263 David Lynch Jdlrobson-WMF 1 0 387351 https://phabricator.wikimedia.org/T387351 open 0 1
1562 390 390 1740524759 1740531647 MusikAnimal MusikAnimal 1 0 387253 https://phabricator.wikimedia.org/T387253 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)
        );