product_contributors

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

11 rows where contributor_id = "CON_2W7V9PRKYM70"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_00Q493GK4A2G,CON_2W7V9PRKYM70,1 I Don't Know How to Give Birth! PRD_00Q493GK4A2G Ayami Kazama CON_2W7V9PRKYM70 1  
PRD_0BRSR0Z33010,CON_2W7V9PRKYM70,2 Volume 5 PRD_0BRSR0Z33010 Ayami Kazama CON_2W7V9PRKYM70 2  
PRD_0EWAK4QEWEB0,CON_2W7V9PRKYM70,2 Volume 2 PRD_0EWAK4QEWEB0 Ayami Kazama CON_2W7V9PRKYM70 2  
PRD_0NYPKTM1RD70,CON_2W7V9PRKYM70,2 Volume 9 PRD_0NYPKTM1RD70 Ayami Kazama CON_2W7V9PRKYM70 2  
PRD_0WMYDH7FXZ10,CON_2W7V9PRKYM70,2 Volume 7 PRD_0WMYDH7FXZ10 Ayami Kazama CON_2W7V9PRKYM70 2  
PRD_1MH1MTZ2N0Z0,CON_2W7V9PRKYM70,2 Volume 8 PRD_1MH1MTZ2N0Z0 Ayami Kazama CON_2W7V9PRKYM70 2  
PRD_1T7K13BXFSN0,CON_2W7V9PRKYM70,2 Volume 1 PRD_1T7K13BXFSN0 Ayami Kazama CON_2W7V9PRKYM70 2  
PRD_2E2ZVJF8YZM0,CON_2W7V9PRKYM70,2 Volume 10 PRD_2E2ZVJF8YZM0 Ayami Kazama CON_2W7V9PRKYM70 2  
PRD_2RSG6WS926P0,CON_2W7V9PRKYM70,2 Volume 3 PRD_2RSG6WS926P0 Ayami Kazama CON_2W7V9PRKYM70 2  
PRD_2S7SVC428JVG,CON_2W7V9PRKYM70,2 Volume 4 PRD_2S7SVC428JVG Ayami Kazama CON_2W7V9PRKYM70 2  
PRD_3D6358S2WEYG,CON_2W7V9PRKYM70,2 Volume 6 PRD_3D6358S2WEYG Ayami Kazama CON_2W7V9PRKYM70 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);