product_contributors

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

17 rows where contributor_id = "CON_02H3P8YX9VXG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_03N4YK6E5X40,CON_02H3P8YX9VXG,2 Spaniard's Seduction PRD_03N4YK6E5X40 NEI NOWAKI CON_02H3P8YX9VXG 2  
PRD_0EHXSKV1XS9G,CON_02H3P8YX9VXG,2 The Wicked Truth PRD_0EHXSKV1XS9G NEI NOWAKI CON_02H3P8YX9VXG 2  
PRD_0QT12JQ1GKY0,CON_02H3P8YX9VXG,2 The Beauty Within PRD_0QT12JQ1GKY0 NEI NOWAKI CON_02H3P8YX9VXG 2  
PRD_1742EV5RZS50,CON_02H3P8YX9VXG,2 Ruthless in all PRD_1742EV5RZS50 NEI NOWAKI CON_02H3P8YX9VXG 2  
PRD_1EYR0TT96W7G,CON_02H3P8YX9VXG,2 The Untamed Sheik PRD_1EYR0TT96W7G NEI NOWAKI CON_02H3P8YX9VXG 2  
PRD_1QABWZJE1NMG,CON_02H3P8YX9VXG,2 The Earl'S Forbidden Ward PRD_1QABWZJE1NMG NEI NOWAKI CON_02H3P8YX9VXG 2  
PRD_21FR6GDBTSE0,CON_02H3P8YX9VXG,2 The Wedding Game PRD_21FR6GDBTSE0 NEI NOWAKI CON_02H3P8YX9VXG 2  
PRD_23BFQ6CB2PNG,CON_02H3P8YX9VXG,2 Every Girl's Secret Fantasy PRD_23BFQ6CB2PNG NEI NOWAKI CON_02H3P8YX9VXG 2  
PRD_2J8YEHSEQ0YG,CON_02H3P8YX9VXG,2 His Christmas Virgin PRD_2J8YEHSEQ0YG NEI NOWAKI CON_02H3P8YX9VXG 2  
PRD_2MGF3Z87B9S0,CON_02H3P8YX9VXG,2 The Bride'S Portion PRD_2MGF3Z87B9S0 NEI NOWAKI CON_02H3P8YX9VXG 2  
PRD_2X71KZABYNQG,CON_02H3P8YX9VXG,2 His Christmas Eve Proposal PRD_2X71KZABYNQG NEI NOWAKI CON_02H3P8YX9VXG 2  
PRD_2YGWD0KSJ6W0,CON_02H3P8YX9VXG,2 Just Say Yes! PRD_2YGWD0KSJ6W0 NEI NOWAKI CON_02H3P8YX9VXG 2  
PRD_31Y2XSZ9GRF0,CON_02H3P8YX9VXG,2 Pregnancy Proposal PRD_31Y2XSZ9GRF0 NEI NOWAKI CON_02H3P8YX9VXG 2  
PRD_3AB4FW0H1YR0,CON_02H3P8YX9VXG,2 Mistletoe Mistress PRD_3AB4FW0H1YR0 NEI NOWAKI CON_02H3P8YX9VXG 2  
PRD_3N8M57DMJ810,CON_02H3P8YX9VXG,2 A Gift For A Lion PRD_3N8M57DMJ810 NEI NOWAKI CON_02H3P8YX9VXG 2  
PRD_3RDB17K67ADG,CON_02H3P8YX9VXG,2 The Virgin's Secret PRD_3RDB17K67ADG NEI NOWAKI CON_02H3P8YX9VXG 2  
PRD_3W7CCMG5PSRG,CON_02H3P8YX9VXG,2 Her Prince's Secret Son PRD_3W7CCMG5PSRG NEI NOWAKI CON_02H3P8YX9VXG 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);