labels_pull_requests

Table actions

3 rows where pull_requests_id = 1295123787

✎ View and edit SQL

This data as json, CSV (advanced)

Link labels_id pull_requests_id
536144505,1295123787 topic-performance 536144505 Use read1 instead of read to get magic number 1295123787
3061601155,1295123787 needs discussion 3061601155 Use read1 instead of read to get magic number 1295123787
4429774983,1295123787 io 4429774983 Use read1 instead of read to get magic number 1295123787

Advanced export

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

CSV options: 

CREATE TABLE [labels_pull_requests] (
   [labels_id] INTEGER REFERENCES [labels]([id]),
   [pull_requests_id] INTEGER REFERENCES [pull_requests]([id]),
   PRIMARY KEY ([labels_id], [pull_requests_id])
);
CREATE INDEX [idx_labels_pull_requests_pull_requests_id]
    ON [labels_pull_requests] ([pull_requests_id]);
CREATE INDEX [idx_labels_pull_requests_labels_id]
    ON [labels_pull_requests] ([labels_id]);