issues_labels

Table actions

4 rows where issues_id = 1623776623

✎ View and edit SQL

This data as json, CSV (advanced)

Link labels_id issues_id
1623776623,136299915 topic-documentation 136299915 Added an introduction to the reshaping documentation 1623776623
1623776623,1593475602 CI 1593475602 Added an introduction to the reshaping documentation 1623776623
1623776623,3200494968 dependencies 3200494968 Added an introduction to the reshaping documentation 1623776623
1623776623,3518936065 Automation 3518936065 Added an introduction to the reshaping documentation 1623776623

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]);