BookWalker

home / database

product_contributors

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

16 rows where contributor_id = "CON_2EJTCGBEGS2G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0W0VG5N1ZNJ0,CON_2EJTCGBEGS2G,1 Volume 8 PRD_0W0VG5N1ZNJ0 Izumi Tsubaki CON_2EJTCGBEGS2G 1  
PRD_0XV3GRW1M08G,CON_2EJTCGBEGS2G,1 Volume 16 PRD_0XV3GRW1M08G Izumi Tsubaki CON_2EJTCGBEGS2G 1  
PRD_1MEW6TX66PNG,CON_2EJTCGBEGS2G,1 Volume 5 PRD_1MEW6TX66PNG Izumi Tsubaki CON_2EJTCGBEGS2G 1  
PRD_1YTD96289TFG,CON_2EJTCGBEGS2G,1 Volume 13 PRD_1YTD96289TFG Izumi Tsubaki CON_2EJTCGBEGS2G 1  
PRD_20JHK42FJQEG,CON_2EJTCGBEGS2G,1 Volume 3 PRD_20JHK42FJQEG Izumi Tsubaki CON_2EJTCGBEGS2G 1  
PRD_22KW4KJYV3Z0,CON_2EJTCGBEGS2G,1 Volume 2 PRD_22KW4KJYV3Z0 Izumi Tsubaki CON_2EJTCGBEGS2G 1  
PRD_2BN550GAQ230,CON_2EJTCGBEGS2G,1 Volume 4 PRD_2BN550GAQ230 Izumi Tsubaki CON_2EJTCGBEGS2G 1  
PRD_2KDW13W9ZS4G,CON_2EJTCGBEGS2G,1 Volume 14 PRD_2KDW13W9ZS4G Izumi Tsubaki CON_2EJTCGBEGS2G 1  
PRD_2P8CCQFPEJ7G,CON_2EJTCGBEGS2G,1 Volume 11 PRD_2P8CCQFPEJ7G Izumi Tsubaki CON_2EJTCGBEGS2G 1  
PRD_2R4M0TAYQ4ZG,CON_2EJTCGBEGS2G,1 Volume 10 PRD_2R4M0TAYQ4ZG Izumi Tsubaki CON_2EJTCGBEGS2G 1  
PRD_2VZ513K90TPG,CON_2EJTCGBEGS2G,1 Volume 15 PRD_2VZ513K90TPG Izumi Tsubaki CON_2EJTCGBEGS2G 1  
PRD_330BCP9M4K9G,CON_2EJTCGBEGS2G,1 Volume 7 PRD_330BCP9M4K9G Izumi Tsubaki CON_2EJTCGBEGS2G 1  
PRD_37HBDE6R5ZJG,CON_2EJTCGBEGS2G,1 Volume 9 PRD_37HBDE6R5ZJG Izumi Tsubaki CON_2EJTCGBEGS2G 1  
PRD_3GHJTPC8X8DG,CON_2EJTCGBEGS2G,1 Volume 6 PRD_3GHJTPC8X8DG Izumi Tsubaki CON_2EJTCGBEGS2G 1  
PRD_3TX6R1CJW4G0,CON_2EJTCGBEGS2G,1 Volume 12 PRD_3TX6R1CJW4G0 Izumi Tsubaki CON_2EJTCGBEGS2G 1  
PRD_3YMX0ADHEFW0,CON_2EJTCGBEGS2G,1 Volume 1 PRD_3YMX0ADHEFW0 Izumi Tsubaki CON_2EJTCGBEGS2G 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 8.329ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS