bug_bug_patch

2 rows where bug_id = 42

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ bug_id bug_patch_id
50 Add a link: both "Yes" and "No" can be selected 42 47 47
53 Add a link: both "Yes" and "No" can be selected 42 50 50

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE bug_bug_patch (
            id INTEGER PRIMARY KEY,
            bug_id INTEGER NOT NULL,
            bug_patch_id INTEGER NOT NULL,
            FOREIGN KEY(bug_id) REFERENCES bug(id),
            FOREIGN KEY(bug_patch_id) REFERENCES bug_patch(id)
        );