BookWalker

home / database

product_contributors

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

20 rows where contributor_id = "CON_3CTVJWPW2NVG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_03J3RE8QJ7RG,CON_3CTVJWPW2NVG,1 Chapter 3 PRD_03J3RE8QJ7RG como CON_3CTVJWPW2NVG 1  
PRD_0D9W64Y2WAB0,CON_3CTVJWPW2NVG,1 Chapter 10 PRD_0D9W64Y2WAB0 como CON_3CTVJWPW2NVG 1  
PRD_0MV3474KTTW0,CON_3CTVJWPW2NVG,1 Chapter 4 PRD_0MV3474KTTW0 como CON_3CTVJWPW2NVG 1  
PRD_0PFTXKVDXD6G,CON_3CTVJWPW2NVG,1 Chapter 3 PRD_0PFTXKVDXD6G como CON_3CTVJWPW2NVG 1  
PRD_0V51FTZAGBXG,CON_3CTVJWPW2NVG,1 Chapter 7 PRD_0V51FTZAGBXG como CON_3CTVJWPW2NVG 1  
PRD_0V9KQT6P6S30,CON_3CTVJWPW2NVG,1 Chapter 3 PRD_0V9KQT6P6S30 como CON_3CTVJWPW2NVG 1  
PRD_1216RQ20YMZ0,CON_3CTVJWPW2NVG,1 Chapter 5 PRD_1216RQ20YMZ0 como CON_3CTVJWPW2NVG 1  
PRD_13H6ECB49F3G,CON_3CTVJWPW2NVG,1 Chapter 5 PRD_13H6ECB49F3G como CON_3CTVJWPW2NVG 1  
PRD_16QHABWATKY0,CON_3CTVJWPW2NVG,1 Chapter 4 PRD_16QHABWATKY0 como CON_3CTVJWPW2NVG 1  
PRD_1FCSPRY2MWEG,CON_3CTVJWPW2NVG,1 Chapter 8 PRD_1FCSPRY2MWEG como CON_3CTVJWPW2NVG 1  
PRD_1R1RS28B1RB0,CON_3CTVJWPW2NVG,1 Chapter 2 PRD_1R1RS28B1RB0 como CON_3CTVJWPW2NVG 1  
PRD_28GJQWWYRA5G,CON_3CTVJWPW2NVG,1 Chapter 2 PRD_28GJQWWYRA5G como CON_3CTVJWPW2NVG 1  
PRD_2GM902XCY3KG,CON_3CTVJWPW2NVG,1 Chapter 4 PRD_2GM902XCY3KG como CON_3CTVJWPW2NVG 1  
PRD_2N0BYHQGRTKG,CON_3CTVJWPW2NVG,1 Chapter 2 PRD_2N0BYHQGRTKG como CON_3CTVJWPW2NVG 1  
PRD_2PKRKYTEWTCG,CON_3CTVJWPW2NVG,1 Chapter 5 PRD_2PKRKYTEWTCG como CON_3CTVJWPW2NVG 1  
PRD_2SPT84HV4SJG,CON_3CTVJWPW2NVG,1 Chapter 1 PRD_2SPT84HV4SJG como CON_3CTVJWPW2NVG 1  
PRD_3767CPY6NZGG,CON_3CTVJWPW2NVG,1 Chapter 1 PRD_3767CPY6NZGG como CON_3CTVJWPW2NVG 1  
PRD_3DM0F197JWY0,CON_3CTVJWPW2NVG,1 Chapter 9 PRD_3DM0F197JWY0 como CON_3CTVJWPW2NVG 1  
PRD_3H8529YPJMP0,CON_3CTVJWPW2NVG,1 Chapter 6 PRD_3H8529YPJMP0 como CON_3CTVJWPW2NVG 1  
PRD_3T3ZGT8WX5YG,CON_3CTVJWPW2NVG,1 Chapter 1 PRD_3T3ZGT8WX5YG como CON_3CTVJWPW2NVG 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.321ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS