product_contributors

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

8 rows where contributor_id = "CON_2GZ5VKM1GK90"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_1GP7Y0VW5610,CON_2GZ5VKM1GK90,1 Please Take Care of Willie PRD_1GP7Y0VW5610 Tracy Sinclair CON_2GZ5VKM1GK90 1  
PRD_1HP7144AZSYG,CON_2GZ5VKM1GK90,1 The Princess Gets Engaged PRD_1HP7144AZSYG Tracy Sinclair CON_2GZ5VKM1GK90 1  
PRD_1R40P7SPB1H0,CON_2GZ5VKM1GK90,1 An American Princess PRD_1R40P7SPB1H0 Tracy Sinclair CON_2GZ5VKM1GK90 1  
PRD_27A351N9FGR0,CON_2GZ5VKM1GK90,1 Pretend Engagement PRD_27A351N9FGR0 Tracy Sinclair CON_2GZ5VKM1GK90 1  
PRD_2GRHX6JZVBSG,CON_2GZ5VKM1GK90,1 Thank Heaven for Little Girls PRD_2GRHX6JZVBSG Tracy Sinclair CON_2GZ5VKM1GK90 1  
PRD_2GTWATNQTV50,CON_2GZ5VKM1GK90,1 Forgive and Forget PRD_2GTWATNQTV50 Tracy Sinclair CON_2GZ5VKM1GK90 1  
PRD_2PECBC9R6R6G,CON_2GZ5VKM1GK90,1 The Sultan'S Wives PRD_2PECBC9R6R6G Tracy Sinclair CON_2GZ5VKM1GK90 1  
PRD_3ZFQZ9WT3K9G,CON_2GZ5VKM1GK90,1 What She Did On Her Summer Vacation PRD_3ZFQZ9WT3K9G Tracy Sinclair CON_2GZ5VKM1GK90 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);