product_contributors

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

20 rows where contributor_id = "CON_2EWZV5XKCEX0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0BFGZMAJQ9YG,CON_2EWZV5XKCEX0,2 Part 2 Volume 4 PRD_0BFGZMAJQ9YG Suzuka CON_2EWZV5XKCEX0 2  
PRD_0C8QZ57PTDTG,CON_2EWZV5XKCEX0,2 Volume 4 PRD_0C8QZ57PTDTG Suzuka CON_2EWZV5XKCEX0 2  
PRD_0D19J816R3D0,CON_2EWZV5XKCEX0,2 Volume 3 PRD_0D19J816R3D0 Suzuka CON_2EWZV5XKCEX0 2  
PRD_0FGQYSNAKE0G,CON_2EWZV5XKCEX0,2 Part 2 Volume 5 PRD_0FGQYSNAKE0G Suzuka CON_2EWZV5XKCEX0 2  
PRD_0TGSWQ55S28G,CON_2EWZV5XKCEX0,2 Part 2 Volume 2 PRD_0TGSWQ55S28G Suzuka CON_2EWZV5XKCEX0 2  
PRD_0WVHXH5VQDT0,CON_2EWZV5XKCEX0,2 Part 2 Volume 1 PRD_0WVHXH5VQDT0 Suzuka CON_2EWZV5XKCEX0 2  
PRD_11RPHZKJK7ZG,CON_2EWZV5XKCEX0,2 Part 2 Volume 10 PRD_11RPHZKJK7ZG Suzuka CON_2EWZV5XKCEX0 2  
PRD_15P9GZR1W1VG,CON_2EWZV5XKCEX0,2 Volume 1 PRD_15P9GZR1W1VG Suzuka CON_2EWZV5XKCEX0 2  
PRD_1EGAPE444KP0,CON_2EWZV5XKCEX0,2 Part 2 Volume 9 PRD_1EGAPE444KP0 Suzuka CON_2EWZV5XKCEX0 2  
PRD_1J4ADKGTTHJ0,CON_2EWZV5XKCEX0,2 Volume 7 PRD_1J4ADKGTTHJ0 Suzuka CON_2EWZV5XKCEX0 2  
PRD_1R792B5HT550,CON_2EWZV5XKCEX0,2 Part 2 Volume 3 PRD_1R792B5HT550 Suzuka CON_2EWZV5XKCEX0 2  
PRD_1TJV45864T70,CON_2EWZV5XKCEX0,2 Part 2 Volume 8 PRD_1TJV45864T70 Suzuka CON_2EWZV5XKCEX0 2  
PRD_1X830J0G04N0,CON_2EWZV5XKCEX0,2 Volume 2 PRD_1X830J0G04N0 Suzuka CON_2EWZV5XKCEX0 2  
PRD_23PVB0XKAAKG,CON_2EWZV5XKCEX0,2 Volume 5 PRD_23PVB0XKAAKG Suzuka CON_2EWZV5XKCEX0 2  
PRD_25H68ZE4HEKG,CON_2EWZV5XKCEX0,2 Part 2 Volume 6 PRD_25H68ZE4HEKG Suzuka CON_2EWZV5XKCEX0 2  
PRD_2M5E73BR0MXG,CON_2EWZV5XKCEX0,2 Volume 6 PRD_2M5E73BR0MXG Suzuka CON_2EWZV5XKCEX0 2  
PRD_2XW9AW57YR9G,CON_2EWZV5XKCEX0,2 Volume 7 PRD_2XW9AW57YR9G Suzuka CON_2EWZV5XKCEX0 2  
PRD_348356C7W6X0,CON_2EWZV5XKCEX0,2 Part 2 Volume 7 PRD_348356C7W6X0 Suzuka CON_2EWZV5XKCEX0 2  
PRD_34Q9918FDTC0,CON_2EWZV5XKCEX0,2 Volume 6 PRD_34Q9918FDTC0 Suzuka CON_2EWZV5XKCEX0 2  
PRD_3RB6BWJK16B0,CON_2EWZV5XKCEX0,2 Part 2 Volume 11 PRD_3RB6BWJK16B0 Suzuka CON_2EWZV5XKCEX0 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);