product_contributors

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

21 rows where contributor_id = "CON_24Y1DTWNARS0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_02ETYP5TZ1W0,CON_24Y1DTWNARS0,2 Volume 12 PRD_02ETYP5TZ1W0 Neko Hinotsuki CON_24Y1DTWNARS0 2  
PRD_07S46Z11T1Y0,CON_24Y1DTWNARS0,2 Volume 17 PRD_07S46Z11T1Y0 Neko Hinotsuki CON_24Y1DTWNARS0 2  
PRD_0MDZY89BFJE0,CON_24Y1DTWNARS0,2 Volume 7 PRD_0MDZY89BFJE0 Neko Hinotsuki CON_24Y1DTWNARS0 2  
PRD_0NBYN5GRMMVG,CON_24Y1DTWNARS0,2 Volume 10 PRD_0NBYN5GRMMVG Neko Hinotsuki CON_24Y1DTWNARS0 2  
PRD_0TWSS9KHDZR0,CON_24Y1DTWNARS0,2 Volume 6 PRD_0TWSS9KHDZR0 Neko Hinotsuki CON_24Y1DTWNARS0 2  
PRD_0WTR8XTG1E90,CON_24Y1DTWNARS0,2 Volume 8 PRD_0WTR8XTG1E90 Neko Hinotsuki CON_24Y1DTWNARS0 2  
PRD_0ZG9499NJMA0,CON_24Y1DTWNARS0,2 Volume 1 PRD_0ZG9499NJMA0 Neko Hinotsuki CON_24Y1DTWNARS0 2  
PRD_152V71KQ7S5G,CON_24Y1DTWNARS0,2 Volume 18 PRD_152V71KQ7S5G Neko Hinotsuki CON_24Y1DTWNARS0 2  
PRD_17TX4WGR4DY0,CON_24Y1DTWNARS0,2 Volume 20 PRD_17TX4WGR4DY0 Neko Hinotsuki CON_24Y1DTWNARS0 2  
PRD_18A7ZTRHGMHG,CON_24Y1DTWNARS0,2 Volume 11 PRD_18A7ZTRHGMHG Neko Hinotsuki CON_24Y1DTWNARS0 2  
PRD_1EZGT93KJQ50,CON_24Y1DTWNARS0,2 Volume 13 PRD_1EZGT93KJQ50 Neko Hinotsuki CON_24Y1DTWNARS0 2  
PRD_1YDQJ1TBV5P0,CON_24Y1DTWNARS0,2 Volume 19 PRD_1YDQJ1TBV5P0 Neko Hinotsuki CON_24Y1DTWNARS0 2  
PRD_2005604S8PXG,CON_24Y1DTWNARS0,2 Volume 5 PRD_2005604S8PXG Neko Hinotsuki CON_24Y1DTWNARS0 2  
PRD_2CVDWJDZ83M0,CON_24Y1DTWNARS0,2 Volume 21 PRD_2CVDWJDZ83M0 Neko Hinotsuki CON_24Y1DTWNARS0 2  
PRD_2N32TQ9KHZRG,CON_24Y1DTWNARS0,2 Volume 4 PRD_2N32TQ9KHZRG Neko Hinotsuki CON_24Y1DTWNARS0 2  
PRD_2Y0Z7BJ3VT9G,CON_24Y1DTWNARS0,2 Volume 3 PRD_2Y0Z7BJ3VT9G Neko Hinotsuki CON_24Y1DTWNARS0 2  
PRD_3FCDW2HG1WQ0,CON_24Y1DTWNARS0,2 Volume 9 PRD_3FCDW2HG1WQ0 Neko Hinotsuki CON_24Y1DTWNARS0 2  
PRD_3NM5CDR4TWKG,CON_24Y1DTWNARS0,2 Volume 2 PRD_3NM5CDR4TWKG Neko Hinotsuki CON_24Y1DTWNARS0 2  
PRD_3SVKHE8QRGA0,CON_24Y1DTWNARS0,2 Volume 14 PRD_3SVKHE8QRGA0 Neko Hinotsuki CON_24Y1DTWNARS0 2  
PRD_3TY8D3E7KFEG,CON_24Y1DTWNARS0,2 Volume 16 PRD_3TY8D3E7KFEG Neko Hinotsuki CON_24Y1DTWNARS0 2  
PRD_3YHX8BG51JQG,CON_24Y1DTWNARS0,2 Volume 15 PRD_3YHX8BG51JQG Neko Hinotsuki CON_24Y1DTWNARS0 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);