BookWalker

home / database

product_contributors

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

16 rows where contributor_id = "CON_1PQQEY5YNW20"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_11F0E9T7YGV0,CON_1PQQEY5YNW20,1 Episode 1-4 PRD_11F0E9T7YGV0 Roka Tokutomi CON_1PQQEY5YNW20 1  
PRD_12YHWPRXJHM0,CON_1PQQEY5YNW20,1 Episode 1-6 PRD_12YHWPRXJHM0 Roka Tokutomi CON_1PQQEY5YNW20 1  
PRD_15XGSWM9TZT0,CON_1PQQEY5YNW20,1 Episode 1-2 PRD_15XGSWM9TZT0 Roka Tokutomi CON_1PQQEY5YNW20 1  
PRD_18J3BFPC6YS0,CON_1PQQEY5YNW20,1 Volume 2 PRD_18J3BFPC6YS0 Roka Tokutomi CON_1PQQEY5YNW20 1  
PRD_1GMQ99152NG0,CON_1PQQEY5YNW20,1 Episode 2-7 PRD_1GMQ99152NG0 Roka Tokutomi CON_1PQQEY5YNW20 1  
PRD_1Q57MW3FEMQ0,CON_1PQQEY5YNW20,1 Episode 2-5 PRD_1Q57MW3FEMQ0 Roka Tokutomi CON_1PQQEY5YNW20 1  
PRD_1VVP7GWHAKP0,CON_1PQQEY5YNW20,1 Episode 2-3 PRD_1VVP7GWHAKP0 Roka Tokutomi CON_1PQQEY5YNW20 1  
PRD_1Y86H3YVPJN0,CON_1PQQEY5YNW20,1 Episode 2-1 PRD_1Y86H3YVPJN0 Roka Tokutomi CON_1PQQEY5YNW20 1  
PRD_337SNZB2GGBG,CON_1PQQEY5YNW20,1 Episode 1-5 PRD_337SNZB2GGBG Roka Tokutomi CON_1PQQEY5YNW20 1  
PRD_37M80J54WZAG,CON_1PQQEY5YNW20,1 Episode 1-3 PRD_37M80J54WZAG Roka Tokutomi CON_1PQQEY5YNW20 1  
PRD_3AARJ57ERY9G,CON_1PQQEY5YNW20,1 Episode 1-1 PRD_3AARJ57ERY9G Roka Tokutomi CON_1PQQEY5YNW20 1  
PRD_3EVBXR0H4X8G,CON_1PQQEY5YNW20,1 Volume 1 PRD_3EVBXR0H4X8G Roka Tokutomi CON_1PQQEY5YNW20 1  
PRD_3NJED6JCCK6G,CON_1PQQEY5YNW20,1 Episode 2-4 PRD_3NJED6JCCK6G Roka Tokutomi CON_1PQQEY5YNW20 1  
PRD_3PXZ3KGA0M7G,CON_1PQQEY5YNW20,1 Episode 2-6 PRD_3PXZ3KGA0M7G Roka Tokutomi CON_1PQQEY5YNW20 1  
PRD_3R0YRSFP8J5G,CON_1PQQEY5YNW20,1 Episode 2-2 PRD_3R0YRSFP8J5G Roka Tokutomi CON_1PQQEY5YNW20 1  
PRD_3WH9AC9RMH4G,CON_1PQQEY5YNW20,1 Episode 1-7 PRD_3WH9AC9RMH4G Roka Tokutomi CON_1PQQEY5YNW20 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);
Powered by Datasette · Queries took 8.268ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS