BookWalker

home / database

product_contributors

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

22 rows where contributor_id = "CON_3D2J6CSRZXZG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0521437CCP9G,CON_3D2J6CSRZXZG,1 Volume 2 PRD_0521437CCP9G Tomo Kurahashi CON_3D2J6CSRZXZG 1  
PRD_0C10192RMMFG,CON_3D2J6CSRZXZG,1 Volume 1 PRD_0C10192RMMFG Tomo Kurahashi CON_3D2J6CSRZXZG 1  
PRD_0G5DEV640HPG,CON_3D2J6CSRZXZG,1 Chapter 3 PRD_0G5DEV640HPG Tomo Kurahashi CON_3D2J6CSRZXZG 1  
PRD_0K3A1KG55F80,CON_3D2J6CSRZXZG,1 Chapter 1 PRD_0K3A1KG55F80 Tomo Kurahashi CON_3D2J6CSRZXZG 1  
PRD_0WBKG8JZYHE0,CON_3D2J6CSRZXZG,1 Chapter 4 PRD_0WBKG8JZYHE0 Tomo Kurahashi CON_3D2J6CSRZXZG 1  
PRD_10MJXYHTXJT0,CON_3D2J6CSRZXZG,1 Chapter 9 PRD_10MJXYHTXJT0 Tomo Kurahashi CON_3D2J6CSRZXZG 1  
PRD_176G0GBHK3VG,CON_3D2J6CSRZXZG,1 Chapter 8 PRD_176G0GBHK3VG Tomo Kurahashi CON_3D2J6CSRZXZG 1  
PRD_1BVXT4D75GR0,CON_3D2J6CSRZXZG,1 Chapter 5 PRD_1BVXT4D75GR0 Tomo Kurahashi CON_3D2J6CSRZXZG 1  
PRD_1E8C5QF91ZZ0,CON_3D2J6CSRZXZG,1 Chapter 3 PRD_1E8C5QF91ZZ0 Tomo Kurahashi CON_3D2J6CSRZXZG 1  
PRD_1HQ88V9FXANG,CON_3D2J6CSRZXZG,1 Chapter 5 PRD_1HQ88V9FXANG Tomo Kurahashi CON_3D2J6CSRZXZG 1  
PRD_1M5RTEAHS9MG,CON_3D2J6CSRZXZG,1 Chapter 3 PRD_1M5RTEAHS9MG Tomo Kurahashi CON_3D2J6CSRZXZG 1  
PRD_1RTB514M58VG,CON_3D2J6CSRZXZG,1 Chapter 1 PRD_1RTB514M58VG Tomo Kurahashi CON_3D2J6CSRZXZG 1  
PRD_2AHY9FPEV91G,CON_3D2J6CSRZXZG,1 Chapter 7 PRD_2AHY9FPEV91G Tomo Kurahashi CON_3D2J6CSRZXZG 1  
PRD_2KXTNJQ72H70,CON_3D2J6CSRZXZG,1 Chapter 4 PRD_2KXTNJQ72H70 Tomo Kurahashi CON_3D2J6CSRZXZG 1  
PRD_2TNDTPR9B5WG,CON_3D2J6CSRZXZG,1 Chapter 2 PRD_2TNDTPR9B5WG Tomo Kurahashi CON_3D2J6CSRZXZG 1  
PRD_32FA4M6NZJAG,CON_3D2J6CSRZXZG,1 Chapter 10 PRD_32FA4M6NZJAG Tomo Kurahashi CON_3D2J6CSRZXZG 1  
PRD_35FRSTTPH2B0,CON_3D2J6CSRZXZG,1 Chapter 6 PRD_35FRSTTPH2B0 Tomo Kurahashi CON_3D2J6CSRZXZG 1  
PRD_3835KEW43ZFG,CON_3D2J6CSRZXZG,1 Chapter 4 PRD_3835KEW43ZFG Tomo Kurahashi CON_3D2J6CSRZXZG 1  
PRD_3CHMY1YEFYEG,CON_3D2J6CSRZXZG,1 Chapter 2 PRD_3CHMY1YEFYEG Tomo Kurahashi CON_3D2J6CSRZXZG 1  
PRD_3DMJ38424JQG,CON_3D2J6CSRZXZG,1 Chapter 5 PRD_3DMJ38424JQG Tomo Kurahashi CON_3D2J6CSRZXZG 1  
PRD_3NS613QV08EG,CON_3D2J6CSRZXZG,1 Chapter 1 PRD_3NS613QV08EG Tomo Kurahashi CON_3D2J6CSRZXZG 1  
PRD_3TD3CRNQ7840,CON_3D2J6CSRZXZG,1 Chapter 2 PRD_3TD3CRNQ7840 Tomo Kurahashi CON_3D2J6CSRZXZG 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.659ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS