blocker

3 rows where train_id = 259

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: blocker, unblocker, status, group_blocked, group_unblocked

id ▼ train_id blocked unblocked blocker unblocker removed resolved task url status group_blocked group_unblocked
1185 259 259 1651417101 1651417117 Taavi Väänänen Taavi Väänänen 1 0 307302 https://phabricator.wikimedia.org/T307302 resolved 2 2
1186 259 259 1650973690 1650974828 Urbanecm Urbanecm 1 0 306878 https://phabricator.wikimedia.org/T306878 resolved -1 -1
1187 259 259 1650973478 1650973712 Urbanecm Urbanecm 1 0 306882 https://phabricator.wikimedia.org/T306882 duplicate -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)
        );