product_contributors

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

13 rows where contributor_id = "CON_0853CX2S9560"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0VNYHNP33CX0,CON_0853CX2S9560,2 Dr. Charming PRD_0VNYHNP33CX0 Mio Natsuki CON_0853CX2S9560 2  
PRD_1642BQRJ56FG,CON_0853CX2S9560,2 A Very Special Proposal PRD_1642BQRJ56FG Mio Natsuki CON_0853CX2S9560 2  
PRD_1MD252JJ112G,CON_0853CX2S9560,2 The Duke's New Year's Resolution PRD_1MD252JJ112G Mio Natsuki CON_0853CX2S9560 2  
PRD_1QQGXA6YXCZ0,CON_0853CX2S9560,2 Sleeping with a Stranger PRD_1QQGXA6YXCZ0 Mio Natsuki CON_0853CX2S9560 2  
PRD_1X7R8E5YMWDG,CON_0853CX2S9560,2 Miss independence PRD_1X7R8E5YMWDG Mio Natsuki CON_0853CX2S9560 2  
PRD_2BJVRJW985PG,CON_0853CX2S9560,2 Captive in His Castle PRD_2BJVRJW985PG Mio Natsuki CON_0853CX2S9560 2  
PRD_2CRCX8V3NT80,CON_0853CX2S9560,2 Gentle Deception PRD_2CRCX8V3NT80 Mio Natsuki CON_0853CX2S9560 2  
PRD_2QMR0V747410,CON_0853CX2S9560,2 Kept by Her Greek Boss PRD_2QMR0V747410 Mio Natsuki CON_0853CX2S9560 2  
PRD_2QR2XHSTKHQG,CON_0853CX2S9560,2 The Magnate's Mistress PRD_2QR2XHSTKHQG Mio Natsuki CON_0853CX2S9560 2  
PRD_320GJW6FJ0E0,CON_0853CX2S9560,2 Innocent 'Til Proven Otherwise PRD_320GJW6FJ0E0 Mio Natsuki CON_0853CX2S9560 2  
PRD_3KEQ7GGB99D0,CON_0853CX2S9560,2 The Hot-Blooded Groom PRD_3KEQ7GGB99D0 Mio Natsuki CON_0853CX2S9560 2  
PRD_3KG11NY3PRAG,CON_0853CX2S9560,2 Bedded for Pleasure, Purchased for Pregnancy PRD_3KG11NY3PRAG Mio Natsuki CON_0853CX2S9560 2  
PRD_3QKJFZ7XXZH0,CON_0853CX2S9560,2 Manhattan Boss, Diamond Proposal PRD_3QKJFZ7XXZH0 Mio Natsuki CON_0853CX2S9560 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);