BookWalker

home / database

product_contributors

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

22 rows where contributor_id = "CON_1XDEG31FCS80"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_01CS2Q9R3PW0,CON_1XDEG31FCS80,1 Chapter 10 PRD_01CS2Q9R3PW0 OUMA CON_1XDEG31FCS80 1  
PRD_031JNEK298EG,CON_1XDEG31FCS80,1 Chapter 2 PRD_031JNEK298EG OUMA CON_1XDEG31FCS80 1  
PRD_039BG0D3B03G,CON_1XDEG31FCS80,1 Chapter 1 PRD_039BG0D3B03G OUMA CON_1XDEG31FCS80 1  
PRD_0AB7EMVS0BF0,CON_1XDEG31FCS80,1 Chapter 8 PRD_0AB7EMVS0BF0 OUMA CON_1XDEG31FCS80 1  
PRD_0AF9EE3ARXY0,CON_1XDEG31FCS80,1 Chapter 9 PRD_0AF9EE3ARXY0 OUMA CON_1XDEG31FCS80 1  
PRD_0J8RHT1XHRH0,CON_1XDEG31FCS80,1 Chapter 1 PRD_0J8RHT1XHRH0 OUMA CON_1XDEG31FCS80 1  
PRD_0MVE9GEDJGEG,CON_1XDEG31FCS80,1 Chapter 12 PRD_0MVE9GEDJGEG OUMA CON_1XDEG31FCS80 1  
PRD_0RRX9V1P4P30,CON_1XDEG31FCS80,1 Chapter 5 PRD_0RRX9V1P4P30 OUMA CON_1XDEG31FCS80 1  
PRD_16CFQCPCB1Q0,CON_1XDEG31FCS80,1 Chapter 1 PRD_16CFQCPCB1Q0 OUMA CON_1XDEG31FCS80 1  
PRD_1G4HX0E9DS40,CON_1XDEG31FCS80,1 Chapter 3 PRD_1G4HX0E9DS40 OUMA CON_1XDEG31FCS80 1  
PRD_1XHSW97HWFNG,CON_1XDEG31FCS80,1 Chapter 7 PRD_1XHSW97HWFNG OUMA CON_1XDEG31FCS80 1  
PRD_20GX8WZHVQX0,CON_1XDEG31FCS80,1 Chapter 9 PRD_20GX8WZHVQX0 OUMA CON_1XDEG31FCS80 1  
PRD_28MH0RJ86WDG,CON_1XDEG31FCS80,1 Chapter 8 PRD_28MH0RJ86WDG OUMA CON_1XDEG31FCS80 1  
PRD_2J8A19SC8ARG,CON_1XDEG31FCS80,1 Chapter 6 PRD_2J8A19SC8ARG OUMA CON_1XDEG31FCS80 1  
PRD_2P2QVWYDP5T0,CON_1XDEG31FCS80,1 Chapter 7 PRD_2P2QVWYDP5T0 OUMA CON_1XDEG31FCS80 1  
PRD_2YKKC30M11D0,CON_1XDEG31FCS80,1 Chapter 2 PRD_2YKKC30M11D0 OUMA CON_1XDEG31FCS80 1  
PRD_31C3AQVNE940,CON_1XDEG31FCS80,1 Chapter 4 PRD_31C3AQVNE940 OUMA CON_1XDEG31FCS80 1  
PRD_33S1PKPPTE50,CON_1XDEG31FCS80,1 Chapter 5 PRD_33S1PKPPTE50 OUMA CON_1XDEG31FCS80 1  
PRD_36DKYP9240ZG,CON_1XDEG31FCS80,1 Chapter 3 PRD_36DKYP9240ZG OUMA CON_1XDEG31FCS80 1  
PRD_3F3SY4R3J7MG,CON_1XDEG31FCS80,1 Chapter 6 PRD_3F3SY4R3J7MG OUMA CON_1XDEG31FCS80 1  
PRD_3KZ94QZ4FTMG,CON_1XDEG31FCS80,1 Chapter 4 PRD_3KZ94QZ4FTMG OUMA CON_1XDEG31FCS80 1  
PRD_3WWTTPE389MG,CON_1XDEG31FCS80,1 Chapter 11 PRD_3WWTTPE389MG OUMA CON_1XDEG31FCS80 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.081ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS