BookWalker

home / database

product_contributors

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

18 rows where contributor_id = "CON_3SVA8CB83ZC0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0KF0H33QJ3MG,CON_3SVA8CB83ZC0,1 Chapter 7 PRD_0KF0H33QJ3MG Itachisana CON_3SVA8CB83ZC0 1  
PRD_0S0JSXS660SG,CON_3SVA8CB83ZC0,1 Chapter 1 PRD_0S0JSXS660SG Itachisana CON_3SVA8CB83ZC0 1  
PRD_0TJ2EAZ3T1TG,CON_3SVA8CB83ZC0,1 Chapter 3 PRD_0TJ2EAZ3T1TG Itachisana CON_3SVA8CB83ZC0 1  
PRD_10XY5EST4710,CON_3SVA8CB83ZC0,1 Chapter 16 PRD_10XY5EST4710 Itachisana CON_3SVA8CB83ZC0 1  
PRD_17JEG1VW0600,CON_3SVA8CB83ZC0,1 Chapter 14 PRD_17JEG1VW0600 Itachisana CON_3SVA8CB83ZC0 1  
PRD_1A0S3MN6C570,CON_3SVA8CB83ZC0,1 Chapter 12 PRD_1A0S3MN6C570 Itachisana CON_3SVA8CB83ZC0 1  
PRD_1D7RRTGJM350,CON_3SVA8CB83ZC0,1 Chapter 8 PRD_1D7RRTGJM350 Itachisana CON_3SVA8CB83ZC0 1  
PRD_1EH8D7Q88460,CON_3SVA8CB83ZC0,1 Chapter 10 PRD_1EH8D7Q88460 Itachisana CON_3SVA8CB83ZC0 1  
PRD_1N8CYM0BKTW0,CON_3SVA8CB83ZC0,1 Chapter 2 PRD_1N8CYM0BKTW0 Itachisana CON_3SVA8CB83ZC0 1  
PRD_1PVXK161QVX0,CON_3SVA8CB83ZC0,1 Chapter 5 PRD_1PVXK161QVX0 Itachisana CON_3SVA8CB83ZC0 1  
PRD_1SYZ872DZS30,CON_3SVA8CB83ZC0,1 Chapter 4 PRD_1SYZ872DZS30 Itachisana CON_3SVA8CB83ZC0 1  
PRD_23VRNR21XGAG,CON_3SVA8CB83ZC0,1 Chapter 17 PRD_23VRNR21XGAG Itachisana CON_3SVA8CB83ZC0 1  
PRD_2DW5F5NTDWEG,CON_3SVA8CB83ZC0,1 Chapter 9 PRD_2DW5F5NTDWEG Itachisana CON_3SVA8CB83ZC0 1  
PRD_2HMBADJMG240,CON_3SVA8CB83ZC0,1 Chapter 6 PRD_2HMBADJMG240 Itachisana CON_3SVA8CB83ZC0 1  
PRD_3156ZQ8Z27GG,CON_3SVA8CB83ZC0,1 Chapter 15 PRD_3156ZQ8Z27GG Itachisana CON_3SVA8CB83ZC0 1  
PRD_32MPC4EMSRHG,CON_3SVA8CB83ZC0,1 Chapter 18 PRD_32MPC4EMSRHG Itachisana CON_3SVA8CB83ZC0 1  
PRD_35VH9AA1E6QG,CON_3SVA8CB83ZC0,1 Chapter 13 PRD_35VH9AA1E6QG Itachisana CON_3SVA8CB83ZC0 1  
PRD_3881MX4BA5PG,CON_3SVA8CB83ZC0,1 Chapter 11 PRD_3881MX4BA5PG Itachisana CON_3SVA8CB83ZC0 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.208ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS