blocker

7 rows where train_id = 152

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unblocker, removed, resolved, status, group_blocked, group_unblocked

id ▼ train_id blocked unblocked blocker unblocker removed resolved task url status group_blocked group_unblocked
28 152 152 1624955786 1624972726 Giuseppe Lavagetto Giuseppe Lavagetto 0 1 285634 https://phabricator.wikimedia.org/T285634 resolved 2 2
29 152 152 1624478514 1624567222 Dan Duvall Dan Duvall 0 1 285431 https://phabricator.wikimedia.org/T285431 resolved 0 2
30 152 152 1623376972 1624388512 Sam Reed Dan Duvall 1 0 271011 https://phabricator.wikimedia.org/T271011 open -1 -1
31 152 152 1623978068 1624386627 Timo Tijhof Dan Duvall 1 0 285118 https://phabricator.wikimedia.org/T285118 resolved -1 -1
32 152 152 1623352746 1624269580 Jeena Huneidi Amir Sarabadani (WMDE) 0 1 284777 https://phabricator.wikimedia.org/T284777 resolved -1 -1
33 152 152 1623999533 1624032721 Amir Sarabadani (WMDE) Zabe 1 0 285125 https://phabricator.wikimedia.org/T285125 duplicate -1 -1
34 152 152 1624001329 1624031938 AlexisJazz Zabe 0 1 285127 https://phabricator.wikimedia.org/T285127 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)
        );