issues_labels

Table actions

3 rows where issues_id = 445862501

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Link labels_id issues_id
445862501,729585263 small 729585263 Documentation for ArrayFacet (facet by JSON array) 445862501
445862501,750789605 documentation 750789605 Documentation for ArrayFacet (facet by JSON array) 445862501
445862501,1382668283 faceting 1382668283 Documentation for ArrayFacet (facet by JSON array) 445862501

Advanced export

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

CSV options: 

CREATE TABLE [issues_labels] (
   [labels_id] INTEGER REFERENCES [labels]([id]),
   [issues_id] INTEGER REFERENCES [issues]([id]),
   PRIMARY KEY ([issues_id], [labels_id])
);
CREATE INDEX [idx_issues_labels_issues_id]
                ON [issues_labels] ([issues_id]);
CREATE INDEX [idx_issues_labels_labels_id]
                ON [issues_labels] ([labels_id]);