BookWalker

home / database

product_contributors

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

13 rows where contributor_id = "CON_0YDKS6RDETMG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_045NSZ0WNZAG,CON_0YDKS6RDETMG,1 Chapter 2 PRD_045NSZ0WNZAG Susu Katoh CON_0YDKS6RDETMG 1  
PRD_0AS5QDBY6SEG,CON_0YDKS6RDETMG,1 Leave the Sacrifice at the Gate PRD_0AS5QDBY6SEG Susu Katoh CON_0YDKS6RDETMG 1  
PRD_0S2CH953QVKG,CON_0YDKS6RDETMG,1 Continued (2) PRD_0S2CH953QVKG Susu Katoh CON_0YDKS6RDETMG 1  
PRD_0TDW7PBSBVCG,CON_0YDKS6RDETMG,1 Continued (3) PRD_0TDW7PBSBVCG Susu Katoh CON_0YDKS6RDETMG 1  
PRD_0XGZWW75KTJG,CON_0YDKS6RDETMG,1 Continued (1) PRD_0XGZWW75KTJG Susu Katoh CON_0YDKS6RDETMG 1  
PRD_10D7YQB2F9D0,CON_0YDKS6RDETMG,1 Chapter 6 PRD_10D7YQB2F9D0 Susu Katoh CON_0YDKS6RDETMG 1  
PRD_17DV8D7SHHT0,CON_0YDKS6RDETMG,1 Continued (4) PRD_17DV8D7SHHT0 Susu Katoh CON_0YDKS6RDETMG 1  
PRD_1JB81WR0C5NG,CON_0YDKS6RDETMG,1 Chapter 4 PRD_1JB81WR0C5NG Susu Katoh CON_0YDKS6RDETMG 1  
PRD_1PSRKFTA84MG,CON_0YDKS6RDETMG,1 Chapter 3 PRD_1PSRKFTA84MG Susu Katoh CON_0YDKS6RDETMG 1  
PRD_2C208J93E560,CON_0YDKS6RDETMG,1 Chapter 5 PRD_2C208J93E560 Susu Katoh CON_0YDKS6RDETMG 1  
PRD_2Y3G3R9ZVXHG,CON_0YDKS6RDETMG,1 Continued (5) PRD_2Y3G3R9ZVXHG Susu Katoh CON_0YDKS6RDETMG 1  
PRD_307VZBSAJGW0,CON_0YDKS6RDETMG,1 Continued (6) PRD_307VZBSAJGW0 Susu Katoh CON_0YDKS6RDETMG 1  
PRD_3Q135R5FP340,CON_0YDKS6RDETMG,1 Chapter 1 PRD_3Q135R5FP340 Susu Katoh CON_0YDKS6RDETMG 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.642ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS