blocker

5 rows where train_id = 102

✎ 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
542 102 102 1551809154 1552005965 Antoine "hashar" Musso Bryan Davis 0 1 217692 https://phabricator.wikimedia.org/T217692 resolved 0 2
543 102 102 1551970056 1551970080 Antoine "hashar" Musso Antoine "hashar" Musso 1 0 217835 https://phabricator.wikimedia.org/T217835 resolved 2 2
544 102 102 1551878124 1551901922 Antoine "hashar" Musso Antoine "hashar" Musso 1 0 217766 https://phabricator.wikimedia.org/T217766 resolved 0 0
545 102 102 1551808912 1551875145 Antoine "hashar" Musso Antoine "hashar" Musso 0 1 217689 https://phabricator.wikimedia.org/T217689 resolved 0 0
546 102 102 1551288476 1551348712 Adam_WMDE Alaa Sarhan 0 1 217241 https://phabricator.wikimedia.org/T217241 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)
        );