This data as json, CSV (advanced)
Link | list | user |
---|---|---|
1011410290309828608,7832552 | JSK Board of Visitors 1011410290309828608 | Kinsey Wilson 7832552 |
1011410290309828608,14192329 | JSK Board of Visitors 1011410290309828608 | Karen Wickre ☕️💻👀 14192329 |
1011410290309828608,15674801 | JSK Board of Visitors 1011410290309828608 | Emilio Garcia-Ruiz 15674801 |
1011410290309828608,29006114 | JSK Board of Visitors 1011410290309828608 | Latoya Peterson 29006114 |
1011410290309828608,32995666 | JSK Board of Visitors 1011410290309828608 | Maria Ronderos 32995666 |
1011410290309828608,80784646 | JSK Board of Visitors 1011410290309828608 | Krishna Bharat 80784646 |
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]) );