BookWalker

home / database

product_contributors

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

15 rows where contributor_id = "CON_2F0C4K1GSHKG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_025J08M5DH8G,CON_2F0C4K1GSHKG,1 Volume 11 PRD_025J08M5DH8G Yamato Nadeshiko CON_2F0C4K1GSHKG 1  
PRD_058XXEKHNZEG,CON_2F0C4K1GSHKG,1 Volume 7 PRD_058XXEKHNZEG Yamato Nadeshiko CON_2F0C4K1GSHKG 1  
PRD_05FE5FVWRDC0,CON_2F0C4K1GSHKG,1 Volume 1 PRD_05FE5FVWRDC0 Yamato Nadeshiko CON_2F0C4K1GSHKG 1  
PRD_06T2KVPF9GFG,CON_2F0C4K1GSHKG,1 Volume 10 PRD_06T2KVPF9GFG Yamato Nadeshiko CON_2F0C4K1GSHKG 1  
PRD_09SC81DVHYDG,CON_2F0C4K1GSHKG,1 Volume 6 PRD_09SC81DVHYDG Yamato Nadeshiko CON_2F0C4K1GSHKG 1  
PRD_0ZQ3PNT31J9G,CON_2F0C4K1GSHKG,1 Volume 12 PRD_0ZQ3PNT31J9G Yamato Nadeshiko CON_2F0C4K1GSHKG 1  
PRD_18GXQBEG0THG,CON_2F0C4K1GSHKG,1 Volume 4 PRD_18GXQBEG0THG Yamato Nadeshiko CON_2F0C4K1GSHKG 1  
PRD_20JTTH7ABHR0,CON_2F0C4K1GSHKG,1 Volume 9 PRD_20JTTH7ABHR0 Yamato Nadeshiko CON_2F0C4K1GSHKG 1  
PRD_2BG5QQ2PKZY0,CON_2F0C4K1GSHKG,1 Kyoto Date Chapter PRD_2BG5QQ2PKZY0 Yamato Nadeshiko CON_2F0C4K1GSHKG 1  
PRD_2E6M1BWRZYX0,CON_2F0C4K1GSHKG,1 Volume 5 PRD_2E6M1BWRZYX0 Yamato Nadeshiko CON_2F0C4K1GSHKG 1  
PRD_2KT9NJJFZPN0,CON_2F0C4K1GSHKG,1 Volume 2 PRD_2KT9NJJFZPN0 Yamato Nadeshiko CON_2F0C4K1GSHKG 1  
PRD_2SFVWBBY3KT0,CON_2F0C4K1GSHKG,1 Volume 2 PRD_2SFVWBBY3KT0 Yamato Nadeshiko CON_2F0C4K1GSHKG 1  
PRD_2XWAFY50FJS0,CON_2F0C4K1GSHKG,1 Shorty Senpai Falls in Love PRD_2XWAFY50FJS0 Yamato Nadeshiko CON_2F0C4K1GSHKG 1  
PRD_37TTKE296V30,CON_2F0C4K1GSHKG,1 Volume 8 PRD_37TTKE296V30 Yamato Nadeshiko CON_2F0C4K1GSHKG 1  
PRD_3JVHMY6EEB1G,CON_2F0C4K1GSHKG,1 Volume 3 PRD_3JVHMY6EEB1G Yamato Nadeshiko CON_2F0C4K1GSHKG 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 9.95ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS