labels_pull_requests

Table actions

1 row where pull_requests_id = 341037589

✎ View and edit SQL

This data as json, CSV (advanced)

Link labels_id pull_requests_id
536144505,341037589 topic-performance 536144505 2x~5x speed up for isel() in most cases 341037589

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