BookWalker

home / database

product_contributors

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

10 rows where contributor_id = "CON_1ZHRPTZ6R520"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0DEJ3Q4698FG,CON_1ZHRPTZ6R520,1 Volume 3 PRD_0DEJ3Q4698FG Yukiru Sugisaki CON_1ZHRPTZ6R520 1  
PRD_15MSZSH59KWG,CON_1ZHRPTZ6R520,1 Volume 2 PRD_15MSZSH59KWG Yukiru Sugisaki CON_1ZHRPTZ6R520 1  
PRD_19TS8GPQ9HQG,CON_1ZHRPTZ6R520,1 Volume 1 PRD_19TS8GPQ9HQG Yukiru Sugisaki CON_1ZHRPTZ6R520 1  
PRD_1AT5XTTR79AG,CON_1ZHRPTZ6R520,1 Volume 7 PRD_1AT5XTTR79AG Yukiru Sugisaki CON_1ZHRPTZ6R520 1  
PRD_1G3ZNB9VR5C0,CON_1ZHRPTZ6R520,1 Volume 2 PRD_1G3ZNB9VR5C0 Yukiru Sugisaki CON_1ZHRPTZ6R520 1  
PRD_1RHVAD37QD6G,CON_1ZHRPTZ6R520,1 Volume 6 PRD_1RHVAD37QD6G Yukiru Sugisaki CON_1ZHRPTZ6R520 1  
PRD_1ZXW9NYFRZE0,CON_1ZHRPTZ6R520,1 Volume 1 PRD_1ZXW9NYFRZE0 Yukiru Sugisaki CON_1ZHRPTZ6R520 1  
PRD_25MGM56K3HHG,CON_1ZHRPTZ6R520,1 Volume 5 PRD_25MGM56K3HHG Yukiru Sugisaki CON_1ZHRPTZ6R520 1  
PRD_27QVS8YTBWDG,CON_1ZHRPTZ6R520,1 Volume 1 PRD_27QVS8YTBWDG Yukiru Sugisaki CON_1ZHRPTZ6R520 1  
PRD_2GSR5PJ3HZNG,CON_1ZHRPTZ6R520,1 Volume 4 PRD_2GSR5PJ3HZNG Yukiru Sugisaki CON_1ZHRPTZ6R520 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 10.729ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS