BookWalker

home / database

product_contributors

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

16 rows where contributor_id = "CON_1JD3F6S41500"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_02VWF34AGSZG,CON_1JD3F6S41500,1 Chapter 1 PRD_02VWF34AGSZG Ituki Yaeba CON_1JD3F6S41500 1  
PRD_09GVWRZQCFKG,CON_1JD3F6S41500,1 Chapter 6 PRD_09GVWRZQCFKG Ituki Yaeba CON_1JD3F6S41500 1  
PRD_0GAZYXCBPHFG,CON_1JD3F6S41500,1 Chapter 5 PRD_0GAZYXCBPHFG Ituki Yaeba CON_1JD3F6S41500 1  
PRD_0RDDRZFDJR90,CON_1JD3F6S41500,1 Chapter 3 PRD_0RDDRZFDJR90 Ituki Yaeba CON_1JD3F6S41500 1  
PRD_0Y5DXGA0MTRG,CON_1JD3F6S41500,1 Chapter 3 PRD_0Y5DXGA0MTRG Ituki Yaeba CON_1JD3F6S41500 1  
PRD_0Z3WBJ8QZ780,CON_1JD3F6S41500,1 Chapter 1 PRD_0Z3WBJ8QZ780 Ituki Yaeba CON_1JD3F6S41500 1  
PRD_17D8VDDRPR3G,CON_1JD3F6S41500,1 Chapter 4 PRD_17D8VDDRPR3G Ituki Yaeba CON_1JD3F6S41500 1  
PRD_1NK99MK1WDQG,CON_1JD3F6S41500,1 Chapter 3 PRD_1NK99MK1WDQG Ituki Yaeba CON_1JD3F6S41500 1  
PRD_1WGMJEP67V10,CON_1JD3F6S41500,1 Chapter 4 PRD_1WGMJEP67V10 Ituki Yaeba CON_1JD3F6S41500 1  
PRD_1XHYYE8JPJ10,CON_1JD3F6S41500,1 Chapter 2 PRD_1XHYYE8JPJ10 Ituki Yaeba CON_1JD3F6S41500 1  
PRD_1ZZZG617BPA0,CON_1JD3F6S41500,1 Chapter 2 PRD_1ZZZG617BPA0 Ituki Yaeba CON_1JD3F6S41500 1  
PRD_28AVSYENK38G,CON_1JD3F6S41500,1 Chapter 5 PRD_28AVSYENK38G Ituki Yaeba CON_1JD3F6S41500 1  
PRD_2YTNH9SJGRRG,CON_1JD3F6S41500,1 Chapter 2 PRD_2YTNH9SJGRRG Ituki Yaeba CON_1JD3F6S41500 1  
PRD_358D8H2FY6NG,CON_1JD3F6S41500,1 Chapter 6 PRD_358D8H2FY6NG Ituki Yaeba CON_1JD3F6S41500 1  
PRD_3RYG3J7PK2G0,CON_1JD3F6S41500,1 Chapter 4 PRD_3RYG3J7PK2G0 Ituki Yaeba CON_1JD3F6S41500 1  
PRD_3W76AGG49PSG,CON_1JD3F6S41500,1 Chapter 1 PRD_3W76AGG49PSG Ituki Yaeba CON_1JD3F6S41500 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.519ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS