product_contributors

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

6 rows where contributor_id = "CON_2DWY3G7766AG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0R3PQ06TMWRG,CON_2DWY3G7766AG,1 Highly Compromised Position PRD_0R3PQ06TMWRG SARA ORWIG CON_2DWY3G7766AG 1  
PRD_1B91D0QGVYF0,CON_2DWY3G7766AG,1 Tempting the Texas Tycoon PRD_1B91D0QGVYF0 SARA ORWIG CON_2DWY3G7766AG 1  
PRD_1VA46E5QGX80,CON_2DWY3G7766AG,1 Pregnant at the Wedding PRD_1VA46E5QGX80 SARA ORWIG CON_2DWY3G7766AG 1  
PRD_2NNH3SFWYR50,CON_2DWY3G7766AG,1 Seduced by the Wealthy Playboy PRD_2NNH3SFWYR50 SARA ORWIG CON_2DWY3G7766AG 1  
PRD_3YCF9R2PYZX0,CON_2DWY3G7766AG,1 Marrying the Lone Star Maverick PRD_3YCF9R2PYZX0 SARA ORWIG CON_2DWY3G7766AG 1  
PRD_3YEY7F182J30,CON_2DWY3G7766AG,1 Wed To The Texan PRD_3YEY7F182J30 SARA ORWIG CON_2DWY3G7766AG 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);