BookWalker

home / database

product_contributors

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

12 rows where contributor_id = "CON_33STDQTJHY60"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_01R11YS84TV0,CON_33STDQTJHY60,1 Chapter 3 PRD_01R11YS84TV0 Saya Endo CON_33STDQTJHY60 1  
PRD_0968THX0RK6G,CON_33STDQTJHY60,1 Chapter 6 PRD_0968THX0RK6G Saya Endo CON_33STDQTJHY60 1  
PRD_0PZG32R9SCAG,CON_33STDQTJHY60,1 Chapter 9 PRD_0PZG32R9SCAG Saya Endo CON_33STDQTJHY60 1  
PRD_0QH4DWVKB630,CON_33STDQTJHY60,1 Chapter 8 PRD_0QH4DWVKB630 Saya Endo CON_33STDQTJHY60 1  
PRD_0T7MZFNNQ520,CON_33STDQTJHY60,1 Chapter 7 PRD_0T7MZFNNQ520 Saya Endo CON_33STDQTJHY60 1  
PRD_12VM7NYH5AR0,CON_33STDQTJHY60,1 Chapter 5 PRD_12VM7NYH5AR0 Saya Endo CON_33STDQTJHY60 1  
PRD_1HBKZBSXCP90,CON_33STDQTJHY60,1 Chapter 4 PRD_1HBKZBSXCP90 Saya Endo CON_33STDQTJHY60 1  
PRD_1Y7EBS406EBG,CON_33STDQTJHY60,1 Chapter 12 PRD_1Y7EBS406EBG Saya Endo CON_33STDQTJHY60 1  
PRD_1YBRKTFKCW90,CON_33STDQTJHY60,1 Chapter 11 PRD_1YBRKTFKCW90 Saya Endo CON_33STDQTJHY60 1  
PRD_2619T78D2SAG,CON_33STDQTJHY60,1 Chapter 2 PRD_2619T78D2SAG Saya Endo CON_33STDQTJHY60 1  
PRD_2AKFXS2BRA40,CON_33STDQTJHY60,1 Chapter 1 PRD_2AKFXS2BRA40 Saya Endo CON_33STDQTJHY60 1  
PRD_2YNR0HAF10KG,CON_33STDQTJHY60,1 Chapter 10 PRD_2YNR0HAF10KG Saya Endo CON_33STDQTJHY60 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 9.697ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS