blocker

5 rows where train_id = 6

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ train_id blocked unblocked blocker unblocker removed resolved task url status group_blocked group_unblocked
73 6 6 1596792957 1596823433 Tacsipacsi Brennen Bearnes 1 0 259855 https://phabricator.wikimedia.org/T259855 resolved 2 2
74 6 6 1596743032 1596755027 C. Scott Ananian Brennen Bearnes 1 0 259832 https://phabricator.wikimedia.org/T259832 resolved 2 2
75 6 6 1596656709 1596735617 Brennen Bearnes Brennen Bearnes 1 0 259745 https://phabricator.wikimedia.org/T259745 resolved 0 1
76 6 6 1596657310 1596715365 Brennen Bearnes Lucas Werkmeister (WMDE) 1 0 259744 https://phabricator.wikimedia.org/T259744 resolved 0 0
77 6 6 1595959797 1595962623 Brennen Bearnes James D. Forrester 0 1 259023 https://phabricator.wikimedia.org/T259023 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)
        );