BookWalker

home / database

product_contributors

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

10 rows where contributor_id = "CON_1TGMBQEZ6NB0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_033AGZZS4P7G,CON_1TGMBQEZ6NB0,1 Volume 2 PRD_033AGZZS4P7G CHIHIRO YUZUKI CON_1TGMBQEZ6NB0 1  
PRD_0GVW4WDB94FG,CON_1TGMBQEZ6NB0,0 Chapter 4 PRD_0GVW4WDB94FG CHIHIRO YUZUKI CON_1TGMBQEZ6NB0 0  
PRD_0VYZ128QH2DG,CON_1TGMBQEZ6NB0,0 Chapter 2 PRD_0VYZ128QH2DG CHIHIRO YUZUKI CON_1TGMBQEZ6NB0 0  
PRD_0XG40PDAV45G,CON_1TGMBQEZ6NB0,1 Volume 3 PRD_0XG40PDAV45G CHIHIRO YUZUKI CON_1TGMBQEZ6NB0 1  
PRD_11NMTSD5BDG0,CON_1TGMBQEZ6NB0,1 Volume 4 PRD_11NMTSD5BDG0 CHIHIRO YUZUKI CON_1TGMBQEZ6NB0 1  
PRD_1TDJ0B20XZC0,CON_1TGMBQEZ6NB0,0 Chapter 5 PRD_1TDJ0B20XZC0 CHIHIRO YUZUKI CON_1TGMBQEZ6NB0 0  
PRD_2NHQ8SSJK3Y0,CON_1TGMBQEZ6NB0,0 Chapter 3 PRD_2NHQ8SSJK3Y0 CHIHIRO YUZUKI CON_1TGMBQEZ6NB0 0  
PRD_3ACQCHP01A20,CON_1TGMBQEZ6NB0,1 Volume 1 PRD_3ACQCHP01A20 CHIHIRO YUZUKI CON_1TGMBQEZ6NB0 1  
PRD_3HS1DG0GCX0G,CON_1TGMBQEZ6NB0,0 Chapter 6 PRD_3HS1DG0GCX0G CHIHIRO YUZUKI CON_1TGMBQEZ6NB0 0  
PRD_3MPZF5DH5RAG,CON_1TGMBQEZ6NB0,0 Chapter 1 PRD_3MPZF5DH5RAG CHIHIRO YUZUKI CON_1TGMBQEZ6NB0 0  

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 7.956ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS