BookWalker

home / database

product_contributors

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

19 rows where contributor_id = "CON_1PT0NAEZ1B0G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_00AM08WYJFW0,CON_1PT0NAEZ1B0G,1 Chapter 2 PRD_00AM08WYJFW0 ISOTETSU CON_1PT0NAEZ1B0G 1  
PRD_0BATNDGZQZWG,CON_1PT0NAEZ1B0G,1 Volume 1 PRD_0BATNDGZQZWG ISOTETSU CON_1PT0NAEZ1B0G 1  
PRD_0FVN00J1KY3G,CON_1PT0NAEZ1B0G,1 Volume 1 PRD_0FVN00J1KY3G ISOTETSU CON_1PT0NAEZ1B0G 1  
PRD_0KKV38BW64S0,CON_1PT0NAEZ1B0G,1 Chapter 5 PRD_0KKV38BW64S0 ISOTETSU CON_1PT0NAEZ1B0G 1  
PRD_0P0AEV5623R0,CON_1PT0NAEZ1B0G,1 Chapter 3 PRD_0P0AEV5623R0 ISOTETSU CON_1PT0NAEZ1B0G 1  
PRD_0S7NB10JA1Y0,CON_1PT0NAEZ1B0G,1 Chapter 6 PRD_0S7NB10JA1Y0 ISOTETSU CON_1PT0NAEZ1B0G 1  
PRD_0TPTRE78E2Z0,CON_1PT0NAEZ1B0G,1 Chapter 10 PRD_0TPTRE78E2Z0 ISOTETSU CON_1PT0NAEZ1B0G 1  
PRD_0XM5PM2MP0X0,CON_1PT0NAEZ1B0G,1 Chapter 4 PRD_0XM5PM2MP0X0 ISOTETSU CON_1PT0NAEZ1B0G 1  
PRD_1DAKAZRYR49G,CON_1PT0NAEZ1B0G,1 Chapter 6 PRD_1DAKAZRYR49G ISOTETSU CON_1PT0NAEZ1B0G 1  
PRD_1EM0ZCYMW5AG,CON_1PT0NAEZ1B0G,1 Chapter 8 PRD_1EM0ZCYMW5AG ISOTETSU CON_1PT0NAEZ1B0G 1  
PRD_23XCFYDSMFCG,CON_1PT0NAEZ1B0G,1 Chapter 3 PRD_23XCFYDSMFCG ISOTETSU CON_1PT0NAEZ1B0G 1  
PRD_26KWTHF3GFKG,CON_1PT0NAEZ1B0G,1 Chapter 1 PRD_26KWTHF3GFKG ISOTETSU CON_1PT0NAEZ1B0G 1  
PRD_2AXJW31T9ZD0,CON_1PT0NAEZ1B0G,1 Volume 2 PRD_2AXJW31T9ZD0 ISOTETSU CON_1PT0NAEZ1B0G 1  
PRD_2HV3NJT1438G,CON_1PT0NAEZ1B0G,1 Chapter 4 PRD_2HV3NJT1438G ISOTETSU CON_1PT0NAEZ1B0G 1  
PRD_2M9J75MB02FG,CON_1PT0NAEZ1B0G,1 Chapter 2 PRD_2M9J75MB02FG ISOTETSU CON_1PT0NAEZ1B0G 1  
PRD_2RY2JRPDC1EG,CON_1PT0NAEZ1B0G,1 Chapter 1 PRD_2RY2JRPDC1EG ISOTETSU CON_1PT0NAEZ1B0G 1  
PRD_2ZCXWBKQ80DG,CON_1PT0NAEZ1B0G,1 Chapter 5 PRD_2ZCXWBKQ80DG ISOTETSU CON_1PT0NAEZ1B0G 1  
PRD_38CR62FQY6V0,CON_1PT0NAEZ1B0G,1 Chapter 9 PRD_38CR62FQY6V0 ISOTETSU CON_1PT0NAEZ1B0G 1  
PRD_3CX8HN9ST5T0,CON_1PT0NAEZ1B0G,1 Chapter 7 PRD_3CX8HN9ST5T0 ISOTETSU CON_1PT0NAEZ1B0G 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.748ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS