labels_pull_requests

Table actions

3 rows where pull_requests_id = 1069866431

✎ View and edit SQL

This data as json, CSV (advanced)

Link labels_id pull_requests_id
508507365,1069866431 needs review 508507365 Don't cast NaN to integer 1069866431
1106764573,1069866431 topic-cftime 1106764573 Don't cast NaN to integer 1069866431
3061601155,1069866431 needs discussion 3061601155 Don't cast NaN to integer 1069866431

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