BookWalker

home / database

product_contributors

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

14 rows where contributor_id = "CON_1VSJ2NBHF4KG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_08NAS2KW93ZG,CON_1VSJ2NBHF4KG,1 Valentine Bride PRD_08NAS2KW93ZG CHRISTINE RIMMER CON_1VSJ2NBHF4KG 1  
PRD_0FN7RDYZ19NG,CON_1VSJ2NBHF4KG,1 Prince and Future... Dad? PRD_0FN7RDYZ19NG CHRISTINE RIMMER CON_1VSJ2NBHF4KG 1  
PRD_0J144S15Q3W0,CON_1VSJ2NBHF4KG,1 Husband in Training PRD_0J144S15Q3W0 CHRISTINE RIMMER CON_1VSJ2NBHF4KG 1  
PRD_0QXCJK6RDZ10,CON_1VSJ2NBHF4KG,1 The Prince She Had To Marry PRD_0QXCJK6RDZ10 CHRISTINE RIMMER CON_1VSJ2NBHF4KG 1  
PRD_1AKQ58BXQSBG,CON_1VSJ2NBHF4KG,1 The Reluctant Princess PRD_1AKQ58BXQSBG CHRISTINE RIMMER CON_1VSJ2NBHF4KG 1  
PRD_1RX531XH72GG,CON_1VSJ2NBHF4KG,1 From Here to Paternity PRD_1RX531XH72GG CHRISTINE RIMMER CON_1VSJ2NBHF4KG 1  
PRD_1XKNMXN8N6AG,CON_1VSJ2NBHF4KG,1 Holiday Royale PRD_1XKNMXN8N6AG CHRISTINE RIMMER CON_1VSJ2NBHF4KG 1  
PRD_2B2X425C5DM0,CON_1VSJ2NBHF4KG,1 The Man Behind the Mask PRD_2B2X425C5DM0 CHRISTINE RIMMER CON_1VSJ2NBHF4KG 1  
PRD_2R4CT0GYT8QG,CON_1VSJ2NBHF4KG,1 The Marriage Medallion PRD_2R4CT0GYT8QG CHRISTINE RIMMER CON_1VSJ2NBHF4KG 1  
PRD_34CXFCRKX7E0,CON_1VSJ2NBHF4KG,1 The Prince'S Secret Baby PRD_34CXFCRKX7E0 CHRISTINE RIMMER CON_1VSJ2NBHF4KG 1  
PRD_36NW5GBX4YJG,CON_1VSJ2NBHF4KG,1 Marriage by Necessity PRD_36NW5GBX4YJG CHRISTINE RIMMER CON_1VSJ2NBHF4KG 1  
PRD_3BWM26ZBR56G,CON_1VSJ2NBHF4KG,1 The Bravo Billionaire PRD_3BWM26ZBR56G CHRISTINE RIMMER CON_1VSJ2NBHF4KG 1  
PRD_3NJQQHQEN30G,CON_1VSJ2NBHF4KG,1 Practically Married PRD_3NJQQHQEN30G CHRISTINE RIMMER CON_1VSJ2NBHF4KG 1  
PRD_3XHPQWZ1M4W0,CON_1VSJ2NBHF4KG,1 The Stranger and Tessa Jones PRD_3XHPQWZ1M4W0 CHRISTINE RIMMER CON_1VSJ2NBHF4KG 1  

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);
Powered by Datasette · Queries took 7.949ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS