BookWalker

home / database

product_contributors

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

15 rows where contributor_id = "CON_1XQKY3GNCTR0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_10VD6RM4S3WG,CON_1XQKY3GNCTR0,1 Volume 1 PRD_10VD6RM4S3WG Unohana CON_1XQKY3GNCTR0 1  
PRD_1ATB89ZVDCBG,CON_1XQKY3GNCTR0,1 Volume 1 PRD_1ATB89ZVDCBG Unohana CON_1XQKY3GNCTR0 1  
PRD_1Q50SY3FZD6G,CON_1XQKY3GNCTR0,1 Chapter 6 PRD_1Q50SY3FZD6G Unohana CON_1XQKY3GNCTR0 1  
PRD_1R60ZJWCJVJ0,CON_1XQKY3GNCTR0,1 Volume 1 PRD_1R60ZJWCJVJ0 Unohana CON_1XQKY3GNCTR0 1  
PRD_1VVK4JWHVC5G,CON_1XQKY3GNCTR0,1 Chapter 2 PRD_1VVK4JWHVC5G Unohana CON_1XQKY3GNCTR0 1  
PRD_1Y83P5YM7B4G,CON_1XQKY3GNCTR0,1 Chapter 4 PRD_1Y83P5YM7B4G Unohana CON_1XQKY3GNCTR0 1  
PRD_29MZKWNQ4ZYG,CON_1XQKY3GNCTR0,1 Volume 1 PRD_29MZKWNQ4ZYG Unohana CON_1XQKY3GNCTR0 1  
PRD_2CSDRQW6MN10,CON_1XQKY3GNCTR0,1 Volume 1 PRD_2CSDRQW6MN10 Unohana CON_1XQKY3GNCTR0 1  
PRD_2FRZF30P5G90,CON_1XQKY3GNCTR0,1 Volume 1 PRD_2FRZF30P5G90 Unohana CON_1XQKY3GNCTR0 1  
PRD_30607AMASGQG,CON_1XQKY3GNCTR0,1 Neon Ginza Paradise PRD_30607AMASGQG Unohana CON_1XQKY3GNCTR0 1  
PRD_371ZE6AX0W9G,CON_1XQKY3GNCTR0,1 Hybrid Stardust PRD_371ZE6AX0W9G Unohana CON_1XQKY3GNCTR0 1  
PRD_3JF9N2P0NFG0,CON_1XQKY3GNCTR0,1 Chapter 3 PRD_3JF9N2P0NFG0 Unohana CON_1XQKY3GNCTR0 1  
PRD_3PXR0NGAHEQ0,CON_1XQKY3GNCTR0,1 Chapter 7 PRD_3PXR0NGAHEQ0 Unohana CON_1XQKY3GNCTR0 1  
PRD_3R0VXVFPSCN0,CON_1XQKY3GNCTR0,1 Chapter 5 PRD_3R0VXVFPSCN0 Unohana CON_1XQKY3GNCTR0 1  
PRD_3WHAFE9S5BM0,CON_1XQKY3GNCTR0,1 Chapter 1 PRD_3WHAFE9S5BM0 Unohana CON_1XQKY3GNCTR0 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.307ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS