blocker

6 rows where train_id = 253

✎ 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
1158 253 253 1647946201 1647954488 Antoine "hashar" Musso Giuseppe Lavagetto 0 1 304414 https://phabricator.wikimedia.org/T304414 resolved 0 0
1159 253 253 1647893164 1647895476 Dan Duvall Dan Duvall 1 0 304353 https://phabricator.wikimedia.org/T304353 open -1 -1
1160 253 253 1647879109 1647882034 Brennen Bearnes Zabe 0 1 304331 https://phabricator.wikimedia.org/T304331 resolved -1 -1
1161 253 253 1647867391 1647875067 Antoine "hashar" Musso Antoine "hashar" Musso 0 1 281451 https://phabricator.wikimedia.org/T281451 resolved -1 -1
1162 253 253 1647867697 1647874956 Jaime Nuche Antoine "hashar" Musso 0 1 304307 https://phabricator.wikimedia.org/T304307 resolved -1 -1
1163 253 253 1647852173 1647856617 Antoine "hashar" Musso Antoine "hashar" Musso 1 0 304286 https://phabricator.wikimedia.org/T304286 open -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)
        );