BookWalker

home / database

product_contributors

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

16 rows where contributor_id = "CON_1N643VAZNGV0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_082M5F393E10,CON_1N643VAZNGV0,2 Volume 16 PRD_082M5F393E10 Chimaki Kuori CON_1N643VAZNGV0 2  
PRD_0ENJD52HQNTG,CON_1N643VAZNGV0,2 Volume 2 PRD_0ENJD52HQNTG Chimaki Kuori CON_1N643VAZNGV0 2  
PRD_0HGFGSESRZKG,CON_1N643VAZNGV0,2 Volume 3 PRD_0HGFGSESRZKG Chimaki Kuori CON_1N643VAZNGV0 2  
PRD_0S8T8FD02G50,CON_1N643VAZNGV0,2 Volume 12 PRD_0S8T8FD02G50 Chimaki Kuori CON_1N643VAZNGV0 2  
PRD_0ZVMMBSCFGD0,CON_1N643VAZNGV0,2 Volume 5 PRD_0ZVMMBSCFGD0 Chimaki Kuori CON_1N643VAZNGV0 2  
PRD_1HKR92PR3A00,CON_1N643VAZNGV0,2 Volume 15 PRD_1HKR92PR3A00 Chimaki Kuori CON_1N643VAZNGV0 2  
PRD_1HV2THNZGZ2G,CON_1N643VAZNGV0,2 Volume 11 PRD_1HV2THNZGZ2G Chimaki Kuori CON_1N643VAZNGV0 2  
PRD_1JRYY0M23MZG,CON_1N643VAZNGV0,2 Volume 14 PRD_1JRYY0M23MZG Chimaki Kuori CON_1N643VAZNGV0 2  
PRD_1MY3X220M8B0,CON_1N643VAZNGV0,2 Volume 1 PRD_1MY3X220M8B0 Chimaki Kuori CON_1N643VAZNGV0 2  
PRD_1Q637VW34CEG,CON_1N643VAZNGV0,2 Volume 13 PRD_1Q637VW34CEG Chimaki Kuori CON_1N643VAZNGV0 2  
PRD_1R1ZM08AHFVG,CON_1N643VAZNGV0,2 Volume 4 PRD_1R1ZM08AHFVG Chimaki Kuori CON_1N643VAZNGV0 2  
PRD_22CSQHFJGWPG,CON_1N643VAZNGV0,2 Volume 9 PRD_22CSQHFJGWPG Chimaki Kuori CON_1N643VAZNGV0 2  
PRD_241P9GW2VZH0,CON_1N643VAZNGV0,2 Volume 10 PRD_241P9GW2VZH0 Chimaki Kuori CON_1N643VAZNGV0 2  
PRD_2E74DMA1XCC0,CON_1N643VAZNGV0,2 Volume 6 PRD_2E74DMA1XCC0 Chimaki Kuori CON_1N643VAZNGV0 2  
PRD_2M2N2YJ1GYJ0,CON_1N643VAZNGV0,2 Volume 8 PRD_2M2N2YJ1GYJ0 Chimaki Kuori CON_1N643VAZNGV0 2  
PRD_3TSFC7Z2EBZG,CON_1N643VAZNGV0,2 Volume 7 PRD_3TSFC7Z2EBZG Chimaki Kuori CON_1N643VAZNGV0 2  

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