contributors
1 row where user_id = 1322974
This data as json, CSV (advanced)
| Link | repo_id | user_id | contributions |
|---|---|---|---|
| 13221727,1322974 | xarray 13221727 | anntzer 1322974 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [contributors] (
[repo_id] INTEGER REFERENCES [repos]([id]),
[user_id] INTEGER REFERENCES [users]([id]),
[contributions] INTEGER,
PRIMARY KEY ([repo_id], [user_id])
);
CREATE INDEX [idx_contributors_user_id]
ON [contributors] ([user_id]);
CREATE INDEX [idx_contributors_repo_id]
ON [contributors] ([repo_id]);