This data as json, CSV (advanced)
Link | list | user |
---|---|---|
29527154,20392133 | JSK-Fellows2011 29527154 | Dan Archer 20392133 |
29527592,20392133 | JSK Alumni Network 29527592 | Dan Archer 20392133 |
76545315,20392133 | JSK ONA14 76545315 | Dan Archer 20392133 |
94529842,20392133 | JSK Fellows Projects 94529842 | Dan Archer 20392133 |
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]) );