blocker

5 rows where train_id = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
18 1 1 1618349462 1618392333 Urbanecm Urbanecm 0 1 280082 https://phabricator.wikimedia.org/T280082 resolved 0 0
19 1 1 1618261727 1618347360 Bartosz Dziewoński Urbanecm 1 0 279604 https://phabricator.wikimedia.org/T279604 resolved -1 0
20 1 1 1618246933 1618261727 Urbanecm Bartosz Dziewoński 1 0 279949 https://phabricator.wikimedia.org/T279949 duplicate -1 -1
21 1 1 1617836796 1617927590 Dan Duvall Elena 0 1 279113 https://phabricator.wikimedia.org/T279113 resolved -1 -1
22 1 1 1617644389 1617734180 Jon Robson Jon Robson 0 1 279008 https://phabricator.wikimedia.org/T279008 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)
        );