This data as json, CSV (advanced)
Link | list | user |
---|---|---|
29527592,48193439 | JSK Alumni Network 29527592 | drigarcia 48193439 |
92193784,48193439 | JSK-Fellows2013 92193784 | drigarcia 48193439 |
97640575,48193439 | JSK@ONA13 97640575 | drigarcia 48193439 |
JSON shape: default, array, newline-delimited, object
CREATE TABLE [list_members] ( [list] INTEGER REFERENCES [lists]([id]), [user] INTEGER REFERENCES [users]([id]), PRIMARY KEY ([list], [user]) );