BookWalker

home / database

product_contributors

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

20 rows where contributor_id = "CON_1YPMF2XKFC1G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_034TQRP8YPN0,CON_1YPMF2XKFC1G,1 Chapter 15 PRD_034TQRP8YPN0 Financier amai CON_1YPMF2XKFC1G 1  
PRD_0424WXT54TWG,CON_1YPMF2XKFC1G,1 Chapter 8 PRD_0424WXT54TWG Financier amai CON_1YPMF2XKFC1G 1  
PRD_05RSCVBEBYSG,CON_1YPMF2XKFC1G,1 Chapter 7 PRD_05RSCVBEBYSG Financier amai CON_1YPMF2XKFC1G 1  
PRD_0D979491EJS0,CON_1YPMF2XKFC1G,1 Chapter 17 PRD_0D979491EJS0 Financier amai CON_1YPMF2XKFC1G 1  
PRD_1075SMNZ861G,CON_1YPMF2XKFC1G,1 Chapter 6 PRD_1075SMNZ861G Financier amai CON_1YPMF2XKFC1G 1  
PRD_121GE323TXW0,CON_1YPMF2XKFC1G,1 Chapter 16 PRD_121GE323TXW0 Financier amai CON_1YPMF2XKFC1G 1  
PRD_1BA4PTHBG47G,CON_1YPMF2XKFC1G,1 Chapter 11 PRD_1BA4PTHBG47G Financier amai CON_1YPMF2XKFC1G 1  
PRD_21CD811DWN4G,CON_1YPMF2XKFC1G,1 Chapter 14 PRD_21CD811DWN4G Financier amai CON_1YPMF2XKFC1G 1  
PRD_234DR09XTVE0,CON_1YPMF2XKFC1G,1 Chapter 4 PRD_234DR09XTVE0 Financier amai CON_1YPMF2XKFC1G 1  
PRD_2ABCN65A2SC0,CON_1YPMF2XKFC1G,1 Chapter 1 PRD_2ABCN65A2SC0 Financier amai CON_1YPMF2XKFC1G 1  
PRD_2D702BHZHVF0,CON_1YPMF2XKFC1G,1 Chapter 5 PRD_2D702BHZHVF0 Financier amai CON_1YPMF2XKFC1G 1  
PRD_2EPHGRQNNW80,CON_1YPMF2XKFC1G,1 Chapter 10 PRD_2EPHGRQNNW80 Financier amai CON_1YPMF2XKFC1G 1  
PRD_2F70M2RAC6M0,CON_1YPMF2XKFC1G,1 Chapter 12 PRD_2F70M2RAC6M0 Financier amai CON_1YPMF2XKFC1G 1  
PRD_2NAHK324KBXG,CON_1YPMF2XKFC1G,1 Chapter 20 PRD_2NAHK324KBXG Financier amai CON_1YPMF2XKFC1G 1  
PRD_2NGKG7GFPY90,CON_1YPMF2XKFC1G,1 Chapter 3 PRD_2NGKG7GFPY90 Financier amai CON_1YPMF2XKFC1G 1  
PRD_2QA0PN9NC90G,CON_1YPMF2XKFC1G,1 Chapter 18 PRD_2QA0PN9NC90G Financier amai CON_1YPMF2XKFC1G 1  
PRD_2R123TDHJX80,CON_1YPMF2XKFC1G,1 Chapter 2 PRD_2R123TDHJX80 Financier amai CON_1YPMF2XKFC1G 1  
PRD_2VY74F55QWJ0,CON_1YPMF2XKFC1G,1 Chapter 13 PRD_2VY74F55QWJ0 Financier amai CON_1YPMF2XKFC1G 1  
PRD_2WQXDDFVYWF0,CON_1YPMF2XKFC1G,1 Chapter 9 PRD_2WQXDDFVYWF0 Financier amai CON_1YPMF2XKFC1G 1  
PRD_3KY274T0FWWG,CON_1YPMF2XKFC1G,1 Chapter 19 PRD_3KY274T0FWWG Financier amai CON_1YPMF2XKFC1G 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 7.961ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS