BookWalker

home / database

product_contributors

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

15 rows where contributor_id = "CON_1SV33HG76FB0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_0WA2584RSA4G,CON_1SV33HG76FB0,1 Volume 4 PRD_0WA2584RSA4G Youhei Yasumura CON_1SV33HG76FB0 1  
PRD_0XSHZBG46PPG,CON_1SV33HG76FB0,1 Volume 13 PRD_0XSHZBG46PPG Youhei Yasumura CON_1SV33HG76FB0 1  
PRD_19EA0VDAGHDG,CON_1SV33HG76FB0,2 Volume 1 PRD_19EA0VDAGHDG Youhei Yasumura CON_1SV33HG76FB0 2  
PRD_1C8GX33R474G,CON_1SV33HG76FB0,1 Volume 11 PRD_1C8GX33R474G Youhei Yasumura CON_1SV33HG76FB0 1  
PRD_1HCZC1MKJ340,CON_1SV33HG76FB0,1 Volume 12 PRD_1HCZC1MKJ340 Youhei Yasumura CON_1SV33HG76FB0 1  
PRD_1K2WHHQ97B2G,CON_1SV33HG76FB0,1 Volume 3 PRD_1K2WHHQ97B2G Youhei Yasumura CON_1SV33HG76FB0 1  
PRD_1NVW2A7X6020,CON_1SV33HG76FB0,1 Volume 7 PRD_1NVW2A7X6020 Youhei Yasumura CON_1SV33HG76FB0 1  
PRD_1PQ47RNM9PD0,CON_1SV33HG76FB0,1 Volume 2 PRD_1PQ47RNM9PD0 Youhei Yasumura CON_1SV33HG76FB0 1  
PRD_1R64MM1CWME0,CON_1SV33HG76FB0,1 Volume 10 PRD_1R64MM1CWME0 Youhei Yasumura CON_1SV33HG76FB0 1  
PRD_1Z48DFNJ0N9G,CON_1SV33HG76FB0,2 Volume 2 PRD_1Z48DFNJ0N9G Youhei Yasumura CON_1SV33HG76FB0 2  
PRD_20KGFZDCPJE0,CON_1SV33HG76FB0,1 Volume 8 PRD_20KGFZDCPJE0 Youhei Yasumura CON_1SV33HG76FB0 1  
PRD_2TE3SRV1KQHG,CON_1SV33HG76FB0,1 Volume 6 PRD_2TE3SRV1KQHG Youhei Yasumura CON_1SV33HG76FB0 1  
PRD_3CFFBKMVFG80,CON_1SV33HG76FB0,1 Volume 9 PRD_3CFFBKMVFG80 Youhei Yasumura CON_1SV33HG76FB0 1  
PRD_3K3WDRKXFRGG,CON_1SV33HG76FB0,1 Volume 5 PRD_3K3WDRKXFRGG Youhei Yasumura CON_1SV33HG76FB0 1  
PRD_3P05WN92XJ80,CON_1SV33HG76FB0,1 Volume 1 PRD_3P05WN92XJ80 Youhei Yasumura CON_1SV33HG76FB0 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.465ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS