BookWalker

home / database

product_contributors

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

26 rows where contributor_id = "CON_09WENMMM9F00"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0090E339EAP0,CON_09WENMMM9F00,1 Chapter 5 PRD_0090E339EAP0 OU CON_09WENMMM9F00 1  
PRD_03FNEGA493Q0,CON_09WENMMM9F00,1 Chapter 9 PRD_03FNEGA493Q0 OU CON_09WENMMM9F00 1  
PRD_07VENQ8TV48G,CON_09WENMMM9F00,1 Chapter 8 PRD_07VENQ8TV48G OU CON_09WENMMM9F00 1  
PRD_08GGCJMFHKK0,CON_09WENMMM9F00,1 Chapter 10 PRD_08GGCJMFHKK0 OU CON_09WENMMM9F00 1  
PRD_0DBCVTGSYWM0,CON_09WENMMM9F00,1 Chapter 16 PRD_0DBCVTGSYWM0 OU CON_09WENMMM9F00 1  
PRD_0M19HR8Z17QG,CON_09WENMMM9F00,1 Chapter 4 PRD_0M19HR8Z17QG OU CON_09WENMMM9F00 1  
PRD_0NE6J96BHW1G,CON_09WENMMM9F00,1 Chapter 9 PRD_0NE6J96BHW1G OU CON_09WENMMM9F00 1  
PRD_0NV74FTTZQNG,CON_09WENMMM9F00,1 Chapter 7 PRD_0NV74FTTZQNG OU CON_09WENMMM9F00 1  
PRD_0YBJAZNACWV0,CON_09WENMMM9F00,1 Chapter 6 PRD_0YBJAZNACWV0 OU CON_09WENMMM9F00 1  
PRD_136C1VYDB5V0,CON_09WENMMM9F00,1 Chapter 6 PRD_136C1VYDB5V0 OU CON_09WENMMM9F00 1  
PRD_1CY6JXS3KWDG,CON_09WENMMM9F00,1 Chapter 11 PRD_1CY6JXS3KWDG OU CON_09WENMMM9F00 1  
PRD_1EX33S6V9H20,CON_09WENMMM9F00,1 Chapter 15 PRD_1EX33S6V9H20 OU CON_09WENMMM9F00 1  
PRD_1JQ6HCBJWR20,CON_09WENMMM9F00,1 Chapter 3 PRD_1JQ6HCBJWR20 OU CON_09WENMMM9F00 1  
PRD_24JAZZYKA0W0,CON_09WENMMM9F00,1 Chapter 7 PRD_24JAZZYKA0W0 OU CON_09WENMMM9F00 1  
PRD_28GTR61S0T7G,CON_09WENMMM9F00,1 Chapter 17 PRD_28GTR61S0T7G OU CON_09WENMMM9F00 1  
PRD_29QA6ANJHJK0,CON_09WENMMM9F00,1 Chapter 12 PRD_29QA6ANJHJK0 OU CON_09WENMMM9F00 1  
PRD_2CFYR3SDYSJG,CON_09WENMMM9F00,1 Chapter 2 PRD_2CFYR3SDYSJG OU CON_09WENMMM9F00 1  
PRD_2CGTDSMW4NDG,CON_09WENMMM9F00,1 Chapter 14 PRD_2CGTDSMW4NDG OU CON_09WENMMM9F00 1  
PRD_2F1RVRNW6RDG,CON_09WENMMM9F00,1 Chapter 2 PRD_2F1RVRNW6RDG OU CON_09WENMMM9F00 1  
PRD_2GNWEZAK6G5G,CON_09WENMMM9F00,1 Chapter 1 PRD_2GNWEZAK6G5G OU CON_09WENMMM9F00 1  
PRD_35FZMRTP09VG,CON_09WENMMM9F00,1 Chapter 8 PRD_35FZMRTP09VG OU CON_09WENMMM9F00 1  
PRD_38BHF8G0B6S0,CON_09WENMMM9F00,1 Chapter 4 PRD_38BHF8G0B6S0 OU CON_09WENMMM9F00 1  
PRD_3AJTV4AAKZ80,CON_09WENMMM9F00,1 Chapter 5 PRD_3AJTV4AAKZ80 OU CON_09WENMMM9F00 1  
PRD_3FY5A3YBWJQ0,CON_09WENMMM9F00,1 Chapter 3 PRD_3FY5A3YBWJQ0 OU CON_09WENMMM9F00 1  
PRD_3GW9BPTQTRHG,CON_09WENMMM9F00,1 Chapter 1 PRD_3GW9BPTQTRHG OU CON_09WENMMM9F00 1  
PRD_3H25WCJD6D5G,CON_09WENMMM9F00,1 Chapter 13 PRD_3H25WCJD6D5G OU CON_09WENMMM9F00 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 11.484ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS