BookWalker

home / database

product_contributors

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

12 rows where contributor_id = "CON_0GVYPC8EQC90"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_02DGBSD6J9H0,CON_0GVYPC8EQC90,1 Episode 11 PRD_02DGBSD6J9H0 Kidachi CON_0GVYPC8EQC90 1  
PRD_05QC80GY15MG,CON_0GVYPC8EQC90,1 Episode 02 PRD_05QC80GY15MG Kidachi CON_0GVYPC8EQC90 1  
PRD_085WVKJ0D4VG,CON_0GVYPC8EQC90,1 Episode 03 PRD_085WVKJ0D4VG Kidachi CON_0GVYPC8EQC90 1  
PRD_0CTF56CA93TG,CON_0GVYPC8EQC90,1 Episode 06 PRD_0CTF56CA93TG Kidachi CON_0GVYPC8EQC90 1  
PRD_0MWKB1Z3MTHG,CON_0GVYPC8EQC90,1 Episode 07 PRD_0MWKB1Z3MTHG Kidachi CON_0GVYPC8EQC90 1  
PRD_1FG9NHGJEWW0,CON_0GVYPC8EQC90,1 Episode 05 PRD_1FG9NHGJEWW0 Kidachi CON_0GVYPC8EQC90 1  
PRD_27E5QP1S3550,CON_0GVYPC8EQC90,1 Episode 12 PRD_27E5QP1S3550 Kidachi CON_0GVYPC8EQC90 1  
PRD_2D3QZGZFQ2A0,CON_0GVYPC8EQC90,1 Episode 01 PRD_2D3QZGZFQ2A0 Kidachi CON_0GVYPC8EQC90 1  
PRD_2ED7CXX5B3B0,CON_0GVYPC8EQC90,1 Episode 09 PRD_2ED7CXX5B3B0 Kidachi CON_0GVYPC8EQC90 1  
PRD_2N5VWAE0JS10,CON_0GVYPC8EQC90,1 Episode 08 PRD_2N5VWAE0JS10 Kidachi CON_0GVYPC8EQC90 1  
PRD_2PQ8JQCYPT20,CON_0GVYPC8EQC90,1 Episode 04 PRD_2PQ8JQCYPT20 Kidachi CON_0GVYPC8EQC90 1  
PRD_3DSGET3QCWKG,CON_0GVYPC8EQC90,1 Episode 10 PRD_3DSGET3QCWKG Kidachi CON_0GVYPC8EQC90 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 10.873ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS