product_contributors

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

13 rows where contributor_id = "CON_39EEZVZ0B6M0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_12NQ8BB9EM7G,CON_39EEZVZ0B6M0,2 Jordan St Claire: Dark and Dangerous PRD_12NQ8BB9EM7G RIE NAKAMURA CON_39EEZVZ0B6M0 2  
PRD_14JYAA34W57G,CON_39EEZVZ0B6M0,2 Six-Month Mistress PRD_14JYAA34W57G RIE NAKAMURA CON_39EEZVZ0B6M0 2  
PRD_16HZP58W504G,CON_39EEZVZ0B6M0,2 Acquired by Her Greek Boss PRD_16HZP58W504G RIE NAKAMURA CON_39EEZVZ0B6M0 2  
PRD_1RJZ8HAVGAP0,CON_39EEZVZ0B6M0,2 A Daughter's Dilemma PRD_1RJZ8HAVGAP0 RIE NAKAMURA CON_39EEZVZ0B6M0 2  
PRD_1YVZS88FZV0G,CON_39EEZVZ0B6M0,2 No Quiet Refuge PRD_1YVZS88FZV0G RIE NAKAMURA CON_39EEZVZ0B6M0 2  
PRD_1YY819KV2960,CON_39EEZVZ0B6M0,2 A Marriage Fit For A Sinner PRD_1YY819KV2960 RIE NAKAMURA CON_39EEZVZ0B6M0 2  
PRD_2W5537P541EG,CON_39EEZVZ0B6M0,2 Her New Year Baby Secret PRD_2W5537P541EG RIE NAKAMURA CON_39EEZVZ0B6M0 2  
PRD_2WM7GY3XG85G,CON_39EEZVZ0B6M0,2 Dreaming PRD_2WM7GY3XG85G RIE NAKAMURA CON_39EEZVZ0B6M0 2  
PRD_309CJG82DF60,CON_39EEZVZ0B6M0,2 Desire Never Changes PRD_309CJG82DF60 RIE NAKAMURA CON_39EEZVZ0B6M0 2  
PRD_30PFNYG16VXG,CON_39EEZVZ0B6M0,2 Playboy's Lesson PRD_30PFNYG16VXG RIE NAKAMURA CON_39EEZVZ0B6M0 2  
PRD_32D5JZ0WR9M0,CON_39EEZVZ0B6M0,2 The Reluctant Duke PRD_32D5JZ0WR9M0 RIE NAKAMURA CON_39EEZVZ0B6M0 2  
PRD_397CJJNXDQ7G,CON_39EEZVZ0B6M0,2 Bought for Marriage PRD_397CJJNXDQ7G RIE NAKAMURA CON_39EEZVZ0B6M0 2  
PRD_3N5VX6A9FT3G,CON_39EEZVZ0B6M0,2 The Greek'S Billion-Dollar Baby PRD_3N5VX6A9FT3G RIE NAKAMURA CON_39EEZVZ0B6M0 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);