BookWalker

home / database

product_contributors

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

19 rows where contributor_id = "CON_12QVEDSSE5RG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_047W9G6MBPT0,CON_12QVEDSSE5RG,1 Chapter 4 PRD_047W9G6MBPT0 Yuzu Kanzaki CON_12QVEDSSE5RG 1  
PRD_0FAZ6P20KMR0,CON_12QVEDSSE5RG,1 Chapter 3 PRD_0FAZ6P20KMR0 Yuzu Kanzaki CON_12QVEDSSE5RG 1  
PRD_0MWN1XZ2QQJG,CON_12QVEDSSE5RG,1 Chapter 2 PRD_0MWN1XZ2QQJG Yuzu Kanzaki CON_12QVEDSSE5RG 1  
PRD_0Q369X7DT5G0,CON_12QVEDSSE5RG,1 Chapter 5 PRD_0Q369X7DT5G0 Yuzu Kanzaki CON_12QVEDSSE5RG 1  
PRD_0T0K88J8JAE0,CON_12QVEDSSE5RG,1 Chapter 6 PRD_0T0K88J8JAE0 Yuzu Kanzaki CON_12QVEDSSE5RG 1  
PRD_0X7J5E9MT8C0,CON_12QVEDSSE5RG,1 Chapter 2 PRD_0X7J5E9MT8C0 Yuzu Kanzaki CON_12QVEDSSE5RG 1  
PRD_0YFHSP1TGVQG,CON_12QVEDSSE5RG,1 Chapter 2 PRD_0YFHSP1TGVQG Yuzu Kanzaki CON_12QVEDSSE5RG 1  
PRD_0YH3VVFJY9D0,CON_12QVEDSSE5RG,1 Chapter 4 PRD_0YH3VVFJY9D0 Yuzu Kanzaki CON_12QVEDSSE5RG 1  
PRD_1K8GEN9KQZTG,CON_12QVEDSSE5RG,1 Chapter 3 PRD_1K8GEN9KQZTG Yuzu Kanzaki CON_12QVEDSSE5RG 1  
PRD_23CTZRRSR83G,CON_12QVEDSSE5RG,1 Chapter 1 PRD_23CTZRRSR83G Yuzu Kanzaki CON_12QVEDSSE5RG 1  
PRD_23DF19C3T4T0,CON_12QVEDSSE5RG,1 Chapter 7 PRD_23DF19C3T4T0 Yuzu Kanzaki CON_12QVEDSSE5RG 1  
PRD_2ADXPE0WZMTG,CON_12QVEDSSE5RG,1 Chapter 6 PRD_2ADXPE0WZMTG Yuzu Kanzaki CON_12QVEDSSE5RG 1  
PRD_2EJSASX4DG40,CON_12QVEDSSE5RG,1 Chapter 6 PRD_2EJSASX4DG40 Yuzu Kanzaki CON_12QVEDSSE5RG 1  
PRD_2J6JX0JVD8W0,CON_12QVEDSSE5RG,1 Chapter 4 PRD_2J6JX0JVD8W0 Yuzu Kanzaki CON_12QVEDSSE5RG 1  
PRD_2PVZGMM8W50G,CON_12QVEDSSE5RG,1 Chapter 1 PRD_2PVZGMM8W50G Yuzu Kanzaki CON_12QVEDSSE5RG 1  
PRD_2RATFEY0S95G,CON_12QVEDSSE5RG,1 Chapter 1 PRD_2RATFEY0S95G Yuzu Kanzaki CON_12QVEDSSE5RG 1  
PRD_2WQCW3FS3DSG,CON_12QVEDSSE5RG,1 Chapter 5 PRD_2WQCW3FS3DSG Yuzu Kanzaki CON_12QVEDSSE5RG 1  
PRD_2WYAC5YQW9WG,CON_12QVEDSSE5RG,1 Chapter 3 PRD_2WYAC5YQW9WG Yuzu Kanzaki CON_12QVEDSSE5RG 1  
PRD_35D5PVM3E970,CON_12QVEDSSE5RG,1 Chapter 5 PRD_35D5PVM3E970 Yuzu Kanzaki CON_12QVEDSSE5RG 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.976ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS