product_contributors

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

5 rows where product_id = "PRD_21DPNK0J3KG0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_21DPNK0J3KG0,CON_0EFZ59J799M0,1 Ghost in the Shell: Global Neural Network PRD_21DPNK0J3KG0 ALEX DE CAMPI CON_0EFZ59J799M0 1  
PRD_21DPNK0J3KG0,CON_1NTA09CE6V7G,1 Ghost in the Shell: Global Neural Network PRD_21DPNK0J3KG0 MAX GLADSTONE CON_1NTA09CE6V7G 1  
PRD_21DPNK0J3KG0,CON_1PQ5ZA1TRKF0,2 Ghost in the Shell: Global Neural Network PRD_21DPNK0J3KG0 DUSTIN NGUYEN CON_1PQ5ZA1TRKF0 2  
PRD_21DPNK0J3KG0,CON_2S6S396HYCS0,1 Ghost in the Shell: Global Neural Network PRD_21DPNK0J3KG0 BRENDEN FLETCHER CON_2S6S396HYCS0 1  
PRD_21DPNK0J3KG0,CON_2T3GT9VXG42G,2 Ghost in the Shell: Global Neural Network PRD_21DPNK0J3KG0 GIANNIS MILONOGIANNIS CON_2T3GT9VXG42G 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);