BookWalker

home / database

product_contributors

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

23 rows where contributor_id = "CON_3ENXMKX6H9ZG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0D6364NB9FS0,CON_3ENXMKX6H9ZG,2 Chapter 7.2 PRD_0D6364NB9FS0 Haruichi CON_3ENXMKX6H9ZG 2  
PRD_0DKF2D9VMCC0,CON_3ENXMKX6H9ZG,2 Chapter 4.1 PRD_0DKF2D9VMCC0 Haruichi CON_3ENXMKX6H9ZG 2  
PRD_0JDEECAHZ9PG,CON_3ENXMKX6H9ZG,2 Chapter 3.2 PRD_0JDEECAHZ9PG Haruichi CON_3ENXMKX6H9ZG 2  
PRD_0P5P0DZVHCFG,CON_3ENXMKX6H9ZG,2 Chapter 9.2 PRD_0P5P0DZVHCFG Haruichi CON_3ENXMKX6H9ZG 2  
PRD_0Q5N6F81VPNG,CON_3ENXMKX6H9ZG,2 Chapter 5.2 PRD_0Q5N6F81VPNG Haruichi CON_3ENXMKX6H9ZG 2  
PRD_0SKSKPAZ3000,CON_3ENXMKX6H9ZG,2 Chapter 11.2 PRD_0SKSKPAZ3000 Haruichi CON_3ENXMKX6H9ZG 2  
PRD_0V0Q8F3QQ77G,CON_3ENXMKX6H9ZG,2 Chapter 1 PRD_0V0Q8F3QQ77G Haruichi CON_3ENXMKX6H9ZG 2  
PRD_0WY99VP0NHA0,CON_3ENXMKX6H9ZG,2 Chapter 10.2 PRD_0WY99VP0NHA0 Haruichi CON_3ENXMKX6H9ZG 2  
PRD_11G1R2TPE7J0,CON_3ENXMKX6H9ZG,2 Chapter 5.3 PRD_11G1R2TPE7J0 Haruichi CON_3ENXMKX6H9ZG 2  
PRD_15WFCAM5QHEG,CON_3ENXMKX6H9ZG,2 Chapter 9.3 PRD_15WFCAM5QHEG Haruichi CON_3ENXMKX6H9ZG 2  
PRD_1G42D2M8KTX0,CON_3ENXMKX6H9ZG,2 Chapter 11.1 PRD_1G42D2M8KTX0 Haruichi CON_3ENXMKX6H9ZG 2  
PRD_1NWN5X7HVAAG,CON_3ENXMKX6H9ZG,2 Chapter 2.1 PRD_1NWN5X7HVAAG Haruichi CON_3ENXMKX6H9ZG 2  
PRD_1PQS25GG99N0,CON_3ENXMKX6H9ZG,2 Chapter 2.2 PRD_1PQS25GG99N0 Haruichi CON_3ENXMKX6H9ZG 2  
PRD_1WYWTN49RJKG,CON_3ENXMKX6H9ZG,2 Chapter 8.3 PRD_1WYWTN49RJKG Haruichi CON_3ENXMKX6H9ZG 2  
PRD_1XQHDR1T6860,CON_3ENXMKX6H9ZG,2 Chapter 8.2 PRD_1XQHDR1T6860 Haruichi CON_3ENXMKX6H9ZG 2  
PRD_25J9X1BSM9A0,CON_3ENXMKX6H9ZG,2 Chapter 5.1 PRD_25J9X1BSM9A0 Haruichi CON_3ENXMKX6H9ZG 2  
PRD_2BRF6HVJ7C4G,CON_3ENXMKX6H9ZG,2 Chapter 10.1 PRD_2BRF6HVJ7C4G Haruichi CON_3ENXMKX6H9ZG 2  
PRD_2RYY4T8F7MMG,CON_3ENXMKX6H9ZG,2 Chapter 6.1 PRD_2RYY4T8F7MMG Haruichi CON_3ENXMKX6H9ZG 2  
PRD_2YQX74P6D7M0,CON_3ENXMKX6H9ZG,2 Chapter 9.1 PRD_2YQX74P6D7M0 Haruichi CON_3ENXMKX6H9ZG 2  
PRD_3187HVFBX78G,CON_3ENXMKX6H9ZG,2 Chapter 8.1 PRD_3187HVFBX78G Haruichi CON_3ENXMKX6H9ZG 2  
PRD_330AKXJNFG4G,CON_3ENXMKX6H9ZG,2 Chapter 3.1 PRD_330AKXJNFG4G Haruichi CON_3ENXMKX6H9ZG 2  
PRD_35D923MXDF50,CON_3ENXMKX6H9ZG,2 Chapter 7.1 PRD_35D923MXDF50 Haruichi CON_3ENXMKX6H9ZG 2  
PRD_3WPGDDRZ6STG,CON_3ENXMKX6H9ZG,2 Chapter 6.2 PRD_3WPGDDRZ6STG Haruichi CON_3ENXMKX6H9ZG 2  

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 11.834ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS