authors_books
1 row where books_id = "arthur-c-clarke/2001-a-space-odyssey"
This data as json, CSV (advanced)
Link | authors_id | books_id |
---|---|---|
arthur-c-clarke,arthur-c-clarke/2001-a-space-odyssey | Arthur C. Clarke arthur-c-clarke | 2001: A Space Odyssey arthur-c-clarke/2001-a-space-odyssey |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [authors_books] ( [authors_id] TEXT REFERENCES [authors]([id]), [books_id] TEXT REFERENCES [books]([id]), PRIMARY KEY ([authors_id], [books_id]) );