product_contributors

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

8 rows where contributor_id = "CON_05YJ0YQ1WKR0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_04JY9E7W3450,CON_05YJ0YQ1WKR0,1 2nd Date PRD_04JY9E7W3450 Makiko Nagaoka CON_05YJ0YQ1WKR0 1  
PRD_07KXX25SZKZG,CON_05YJ0YQ1WKR0,1 7th Date PRD_07KXX25SZKZG Makiko Nagaoka CON_05YJ0YQ1WKR0 1  
PRD_0J6CDEAA7TBG,CON_05YJ0YQ1WKR0,1 1st Date PRD_0J6CDEAA7TBG Makiko Nagaoka CON_05YJ0YQ1WKR0 1  
PRD_23WQR5SNQYG0,CON_05YJ0YQ1WKR0,1 3rd Date PRD_23WQR5SNQYG0 Makiko Nagaoka CON_05YJ0YQ1WKR0 1  
PRD_2TR8PYYQ39VG,CON_05YJ0YQ1WKR0,1 4th Date PRD_2TR8PYYQ39VG Makiko Nagaoka CON_05YJ0YQ1WKR0 1  
PRD_2WQG8BFVE3ZG,CON_05YJ0YQ1WKR0,1 6th Date PRD_2WQG8BFVE3ZG Makiko Nagaoka CON_05YJ0YQ1WKR0 1  
PRD_3KT2H54PGG50,CON_05YJ0YQ1WKR0,1 5th Date PRD_3KT2H54PGG50 Makiko Nagaoka CON_05YJ0YQ1WKR0 1  
PRD_3QAP7GZYK9A0,CON_05YJ0YQ1WKR0,1 8th Date PRD_3QAP7GZYK9A0 Makiko Nagaoka CON_05YJ0YQ1WKR0 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);