product_contributors

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

21 rows where contributor_id = "CON_3FNBMAP68R00"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_06T79QPE8D8G,CON_3FNBMAP68R00,2 Volume 19 PRD_06T79QPE8D8G Fuyuyuki CON_3FNBMAP68R00 2  
PRD_086HYBFTMGWG,CON_3FNBMAP68R00,2 Volume 16 PRD_086HYBFTMGWG Fuyuyuki CON_3FNBMAP68R00 2  
PRD_0D2FV22SG95G,CON_3FNBMAP68R00,2 Volume 5 PRD_0D2FV22SG95G Fuyuyuki CON_3FNBMAP68R00 2  
PRD_0DCNJDBFTZV0,CON_3FNBMAP68R00,2 Short Story Chronicles PRD_0DCNJDBFTZV0 Fuyuyuki CON_3FNBMAP68R00 2  
PRD_0FSNW5X8W08G,CON_3FNBMAP68R00,2 Volume 12 PRD_0FSNW5X8W08G Fuyuyuki CON_3FNBMAP68R00 2  
PRD_0SFYYHGCD7DG,CON_3FNBMAP68R00,2 Volume 4 PRD_0SFYYHGCD7DG Fuyuyuki CON_3FNBMAP68R00 2  
PRD_0XK9G3205Z40,CON_3FNBMAP68R00,2 Volume 20 PRD_0XK9G3205Z40 Fuyuyuki CON_3FNBMAP68R00 2  
PRD_1HX73V3HCAEG,CON_3FNBMAP68R00,2 Volume 18 PRD_1HX73V3HCAEG Fuyuyuki CON_3FNBMAP68R00 2  
PRD_1J2SJEA2X2MG,CON_3FNBMAP68R00,2 Volume 15 PRD_1J2SJEA2X2MG Fuyuyuki CON_3FNBMAP68R00 2  
PRD_21HF3CP20JS0,CON_3FNBMAP68R00,2 Volume 7 PRD_21HF3CP20JS0 Fuyuyuki CON_3FNBMAP68R00 2  
PRD_27KBP9QFNRZG,CON_3FNBMAP68R00,2 Volume 6 PRD_27KBP9QFNRZG Fuyuyuki CON_3FNBMAP68R00 2  
PRD_2899XPD71V3G,CON_3FNBMAP68R00,2 Volume 1 PRD_2899XPD71V3G Fuyuyuki CON_3FNBMAP68R00 2  
PRD_29GJT095KD30,CON_3FNBMAP68R00,2 Volume 14 PRD_29GJT095KD30 Fuyuyuki CON_3FNBMAP68R00 2  
PRD_2B1QTX6Z4Q1G,CON_3FNBMAP68R00,2 Volume 9 PRD_2B1QTX6Z4Q1G Fuyuyuki CON_3FNBMAP68R00 2  
PRD_2BQ1JMV2PJEG,CON_3FNBMAP68R00,2 Volume 3 PRD_2BQ1JMV2PJEG Fuyuyuki CON_3FNBMAP68R00 2  
PRD_2MS324F4DE60,CON_3FNBMAP68R00,2 Volume 10 PRD_2MS324F4DE60 Fuyuyuki CON_3FNBMAP68R00 2  
PRD_32Q242ZP76C0,CON_3FNBMAP68R00,2 Volume 2 PRD_32Q242ZP76C0 Fuyuyuki CON_3FNBMAP68R00 2  
PRD_3CAP00M6AP7G,CON_3FNBMAP68R00,2 Volume 11 PRD_3CAP00M6AP7G Fuyuyuki CON_3FNBMAP68R00 2  
PRD_3NX5GT0BMQB0,CON_3FNBMAP68R00,2 Volume 8 PRD_3NX5GT0BMQB0 Fuyuyuki CON_3FNBMAP68R00 2  
PRD_3SVHCC8Q87TG,CON_3FNBMAP68R00,2 Volume 17 PRD_3SVHCC8Q87TG Fuyuyuki CON_3FNBMAP68R00 2  
PRD_3T7MZKYCT47G,CON_3FNBMAP68R00,2 Volume 13 PRD_3T7MZKYCT47G Fuyuyuki CON_3FNBMAP68R00 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);