BookWalker

home / database

product_contributors

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

14 rows where contributor_id = "CON_1DJSSH9FRSEG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_01M1D4CZ01F0,CON_1DJSSH9FRSEG,1 Volume 4 PRD_01M1D4CZ01F0 IWATOBINEKO CON_1DJSSH9FRSEG 1  
PRD_0AQ7B564MRYG,CON_1DJSSH9FRSEG,1 Volume 5 PRD_0AQ7B564MRYG IWATOBINEKO CON_1DJSSH9FRSEG 1  
PRD_0MRSZ69K71S0,CON_1DJSSH9FRSEG,1 Volume 1 PRD_0MRSZ69K71S0 IWATOBINEKO CON_1DJSSH9FRSEG 1  
PRD_0Y44SQW3DZ5G,CON_1DJSSH9FRSEG,1 Chapter 5 PRD_0Y44SQW3DZ5G IWATOBINEKO CON_1DJSSH9FRSEG 1  
PRD_1AJQ9ERRKY40,CON_1DJSSH9FRSEG,1 Volume 3 PRD_1AJQ9ERRKY40 IWATOBINEKO CON_1DJSSH9FRSEG 1  
PRD_1QZ7KV5YVA90,CON_1DJSSH9FRSEG,1 Chapter 6 PRD_1QZ7KV5YVA90 IWATOBINEKO CON_1DJSSH9FRSEG 1  
PRD_1TDPXE717980,CON_1DJSSH9FRSEG,1 Chapter 4 PRD_1TDPXE717980 IWATOBINEKO CON_1DJSSH9FRSEG 1  
PRD_1YZM01SZWT9G,CON_1DJSSH9FRSEG,1 Chapter 3 PRD_1YZM01SZWT9G IWATOBINEKO CON_1DJSSH9FRSEG 1  
PRD_27GEF6BCKXV0,CON_1DJSSH9FRSEG,1 Chapter 2 PRD_27GEF6BCKXV0 IWATOBINEKO CON_1DJSSH9FRSEG 1  
PRD_2A6YTS4PZWT0,CON_1DJSSH9FRSEG,1 Chapter 1 PRD_2A6YTS4PZWT0 IWATOBINEKO CON_1DJSSH9FRSEG 1  
PRD_2CHK1D77AMYG,CON_1DJSSH9FRSEG,1 Volume 7 PRD_2CHK1D77AMYG IWATOBINEKO CON_1DJSSH9FRSEG 1  
PRD_3HK2JHKEPXM0,CON_1DJSSH9FRSEG,1 Chapter 7 PRD_3HK2JHKEPXM0 IWATOBINEKO CON_1DJSSH9FRSEG 1  
PRD_3JW6N7X0V580,CON_1DJSSH9FRSEG,1 Volume 2 PRD_3JW6N7X0V580 IWATOBINEKO CON_1DJSSH9FRSEG 1  
PRD_3VWNKTKQRYF0,CON_1DJSSH9FRSEG,1 Volume 6 PRD_3VWNKTKQRYF0 IWATOBINEKO CON_1DJSSH9FRSEG 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.39ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS