BookWalker

home / database

product_contributors

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

7 rows where contributor_id = "CON_3ZDFX0A33Z8G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_08739WYWXBEG,CON_3ZDFX0A33Z8G,2 Volume 7: The World's Strongest Little Brother Vs. The Evil God?! PRD_08739WYWXBEG An2A CON_3ZDFX0A33Z8G 2  
PRD_0FYMYTBCSRWG,CON_3ZDFX0A33Z8G,2 Volume 2: The Half-Baked Vampire vs. the Strongest Little Sister?! PRD_0FYMYTBCSRWG An2A CON_3ZDFX0A33Z8G 2  
PRD_17SANNJAPYM0,CON_3ZDFX0A33Z8G,2 Volume 6: Humanity's Extinction Actually Happens This Time With the Evil God's Revival?! PRD_17SANNJAPYM0 An2A CON_3ZDFX0A33Z8G 2  
PRD_1E36X028WDN0,CON_3ZDFX0A33Z8G,2 Volume 4: The Melancholy of the High School Girl Light Novel Author?! PRD_1E36X028WDN0 An2A CON_3ZDFX0A33Z8G 2  
PRD_1JF78D4Q273G,CON_3ZDFX0A33Z8G,2 Volume 3: Humanity's Extinction Happens During Summer Vacation?! PRD_1JF78D4Q273G An2A CON_3ZDFX0A33Z8G 2  
PRD_2T31RTTSVR6G,CON_3ZDFX0A33Z8G,2 Volume 1: The World's Strongest Little Brother PRD_2T31RTTSVR6G An2A CON_3ZDFX0A33Z8G 2  
PRD_2X4RAM19P5NG,CON_3ZDFX0A33Z8G,2 Volume 5: The Strongest Little Brother's Commonplace Encounters with the Bizarre?! PRD_2X4RAM19P5NG An2A CON_3ZDFX0A33Z8G 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 9.485ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS