BookWalker

home / database

product_contributors

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

22 rows where contributor_id = "CON_3HAVAPBQZDCG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_05Q053NYAZGG,CON_3HAVAPBQZDCG,0 Chapter 4 PRD_05Q053NYAZGG Ajita CON_3HAVAPBQZDCG 0  
PRD_0K06G53FTM9G,CON_3HAVAPBQZDCG,2 Chapter 10 PRD_0K06G53FTM9G Ajita CON_3HAVAPBQZDCG 2  
PRD_0QPH3SWJ6K8G,CON_3HAVAPBQZDCG,2 Chapter 8 PRD_0QPH3SWJ6K8G Ajita CON_3HAVAPBQZDCG 2  
PRD_0S269AE30VR0,CON_3HAVAPBQZDCG,0 Chapter 8 PRD_0S269AE30VR0 Ajita CON_3HAVAPBQZDCG 0  
PRD_0TDQZQCS4WS0,CON_3HAVAPBQZDCG,0 Chapter 7 PRD_0TDQZQCS4WS0 Ajita CON_3HAVAPBQZDCG 0  
PRD_1B3X71R8CQS0,CON_3HAVAPBQZDCG,0 Chapter 5 PRD_1B3X71R8CQS0 Ajita CON_3HAVAPBQZDCG 0  
PRD_1EAEC9P0GPV0,CON_3HAVAPBQZDCG,2 Chapter 12 PRD_1EAEC9P0GPV0 Ajita CON_3HAVAPBQZDCG 2  
PRD_1EERMAYC74RG,CON_3HAVAPBQZDCG,2 Chapter 4 PRD_1EERMAYC74RG Ajita CON_3HAVAPBQZDCG 2  
PRD_1SKXFAX64BG0,CON_3HAVAPBQZDCG,2 Chapter 6 PRD_1SKXFAX64BG0 Ajita CON_3HAVAPBQZDCG 2  
PRD_1SPFQA4HASNG,CON_3HAVAPBQZDCG,2 Chapter 1 PRD_1SPFQA4HASNG Ajita CON_3HAVAPBQZDCG 2  
PRD_1W0DTXZ80AQ0,CON_3HAVAPBQZDCG,2 Chapter 5 PRD_1W0DTXZ80AQ0 Ajita CON_3HAVAPBQZDCG 2  
PRD_27FRCSASCZ10,CON_3HAVAPBQZDCG,0 Chapter 1 PRD_27FRCSASCZ10 Ajita CON_3HAVAPBQZDCG 0  
PRD_2J6WW7QMMNZ0,CON_3HAVAPBQZDCG,0 Chapter 3 PRD_2J6WW7QMMNZ0 Ajita CON_3HAVAPBQZDCG 0  
PRD_2M4F5EXM6W9G,CON_3HAVAPBQZDCG,0 Chapter 10 PRD_2M4F5EXM6W9G Ajita CON_3HAVAPBQZDCG 0  
PRD_2NZSM2FQ4KR0,CON_3HAVAPBQZDCG,2 Chapter 7 PRD_2NZSM2FQ4KR0 Ajita CON_3HAVAPBQZDCG 2  
PRD_2RTZG1ZY2V8G,CON_3HAVAPBQZDCG,0 Chapter 9 PRD_2RTZG1ZY2V8G Ajita CON_3HAVAPBQZDCG 0  
PRD_2W8YQKFD4H30,CON_3HAVAPBQZDCG,0 Chapter 2 PRD_2W8YQKFD4H30 Ajita CON_3HAVAPBQZDCG 0  
PRD_2ZBE3MS0ETFG,CON_3HAVAPBQZDCG,0 Chapter 6 PRD_2ZBE3MS0ETFG Ajita CON_3HAVAPBQZDCG 0  
PRD_329NK6EDE96G,CON_3HAVAPBQZDCG,2 Chapter 2 PRD_329NK6EDE96G Ajita CON_3HAVAPBQZDCG 2  
PRD_381G30FES490,CON_3HAVAPBQZDCG,2 Chapter 3 PRD_381G30FES490 Ajita CON_3HAVAPBQZDCG 2  
PRD_3CKP6J15YNAG,CON_3HAVAPBQZDCG,2 Chapter 11 PRD_3CKP6J15YNAG Ajita CON_3HAVAPBQZDCG 2  
PRD_3GA41VY04V00,CON_3HAVAPBQZDCG,2 Chapter 9 PRD_3GA41VY04V00 Ajita CON_3HAVAPBQZDCG 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.241ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS