BookWalker

home / database

product_contributors

Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)

16 rows where contributor_id = "CON_34QRBK2D2VQ0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_03SYKE3S4RHG,CON_34QRBK2D2VQ0,1 Volume 6 PRD_03SYKE3S4RHG Ryosuke Asakura CON_34QRBK2D2VQ0 1  
PRD_05JYDKGAT72G,CON_34QRBK2D2VQ0,1 Volume 16 PRD_05JYDKGAT72G Ryosuke Asakura CON_34QRBK2D2VQ0 1  
PRD_05RSJP6DHAE0,CON_34QRBK2D2VQ0,1 Volume 12 PRD_05RSJP6DHAE0 Ryosuke Asakura CON_34QRBK2D2VQ0 1  
PRD_0ERQWCAY8FEG,CON_34QRBK2D2VQ0,1 Volume 15 PRD_0ERQWCAY8FEG Ryosuke Asakura CON_34QRBK2D2VQ0 1  
PRD_0HFNA9K51E70,CON_34QRBK2D2VQ0,1 Volume 8 PRD_0HFNA9K51E70 Ryosuke Asakura CON_34QRBK2D2VQ0 1  
PRD_0JNY55ZDP6GG,CON_34QRBK2D2VQ0,1 Volume 13 PRD_0JNY55ZDP6GG Ryosuke Asakura CON_34QRBK2D2VQ0 1  
PRD_0P4JFFBPKQC0,CON_34QRBK2D2VQ0,1 Volume 4 PRD_0P4JFFBPKQC0 Ryosuke Asakura CON_34QRBK2D2VQ0 1  
PRD_0PSRKKY1Z3T0,CON_34QRBK2D2VQ0,1 Volume 11 PRD_0PSRKKY1Z3T0 Ryosuke Asakura CON_34QRBK2D2VQ0 1  
PRD_0W80YQX1PK8G,CON_34QRBK2D2VQ0,1 Volume 10 PRD_0W80YQX1PK8G Ryosuke Asakura CON_34QRBK2D2VQ0 1  
PRD_12185SS1JD20,CON_34QRBK2D2VQ0,1 Volume 2 PRD_12185SS1JD20 Ryosuke Asakura CON_34QRBK2D2VQ0 1  
PRD_13D6RENTT340,CON_34QRBK2D2VQ0,1 Volume 9 PRD_13D6RENTT340 Ryosuke Asakura CON_34QRBK2D2VQ0 1  
PRD_1GY51HGXDX9G,CON_34QRBK2D2VQ0,1 Volume 14 PRD_1GY51HGXDX9G Ryosuke Asakura CON_34QRBK2D2VQ0 1  
PRD_1YEY6Q9YWG60,CON_34QRBK2D2VQ0,1 Volume 1 PRD_1YEY6Q9YWG60 Ryosuke Asakura CON_34QRBK2D2VQ0 1  
PRD_2K24V2QP134G,CON_34QRBK2D2VQ0,1 Volume 5 PRD_2K24V2QP134G Ryosuke Asakura CON_34QRBK2D2VQ0 1  
PRD_3S6WVCH5GY70,CON_34QRBK2D2VQ0,1 Volume 7 PRD_3S6WVCH5GY70 Ryosuke Asakura CON_34QRBK2D2VQ0 1  
PRD_3WJ9G8AKXGCG,CON_34QRBK2D2VQ0,1 Volume 3 PRD_3WJ9G8AKXGCG Ryosuke Asakura CON_34QRBK2D2VQ0 1  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE product_contributors (
      product_id TEXT NOT NULL,
      contributor_id TEXT NOT NULL,
      role INTEGER NOT NULL,
      name_override TEXT,
      PRIMARY KEY (product_id, contributor_id, role),
      FOREIGN KEY (product_id) REFERENCES products(id),
      FOREIGN KEY (contributor_id) REFERENCES contributors(id)
    );
CREATE INDEX idx_product_contributors_contributor ON product_contributors(contributor_id);
Powered by Datasette · Queries took 10.222ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS