BookWalker

home / database

product_contributors

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

16 rows where contributor_id = "CON_1TGYJDGXR3NG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_080S81PK4TZG,CON_1TGYJDGXR3NG,1 Chapter 4 PRD_080S81PK4TZG Kazusa Naruse CON_1TGYJDGXR3NG 1  
PRD_0BRGG002W0DG,CON_1TGYJDGXR3NG,1 Chapter 5 PRD_0BRGG002W0DG Kazusa Naruse CON_1TGYJDGXR3NG 1  
PRD_0CH9VMGN0SYG,CON_1TGYJDGXR3NG,1 Chapter 3 PRD_0CH9VMGN0SYG Kazusa Naruse CON_1TGYJDGXR3NG 1  
PRD_0P54C50SFQP0,CON_1TGYJDGXR3NG,1 Chapter 5 PRD_0P54C50SFQP0 Kazusa Naruse CON_1TGYJDGXR3NG 1  
PRD_19R56XYXR8T0,CON_1TGYJDGXR3NG,1 Chapter 2 PRD_19R56XYXR8T0 Kazusa Naruse CON_1TGYJDGXR3NG 1  
PRD_1DR95J820PTG,CON_1TGYJDGXR3NG,1 Chapter 2 PRD_1DR95J820PTG Kazusa Naruse CON_1TGYJDGXR3NG 1  
PRD_1JZJD7WF4FKG,CON_1TGYJDGXR3NG,1 Chapter 1 PRD_1JZJD7WF4FKG Kazusa Naruse CON_1TGYJDGXR3NG 1  
PRD_1K7R57JZCRXG,CON_1TGYJDGXR3NG,1 Chapter 1 PRD_1K7R57JZCRXG Kazusa Naruse CON_1TGYJDGXR3NG 1  
PRD_211AM5Z6RGWG,CON_1TGYJDGXR3NG,1 Chapter 3 PRD_211AM5Z6RGWG Kazusa Naruse CON_1TGYJDGXR3NG 1  
PRD_284NHBTK0Y2G,CON_1TGYJDGXR3NG,1 Chapter 4 PRD_284NHBTK0Y2G Kazusa Naruse CON_1TGYJDGXR3NG 1  
PRD_2BVPQQ4E6T80,CON_1TGYJDGXR3NG,1 Chapter 6 PRD_2BVPQQ4E6T80 Kazusa Naruse CON_1TGYJDGXR3NG 1  
PRD_2E811A1G2SF0,CON_1TGYJDGXR3NG,1 Chapter 5 PRD_2E811A1G2SF0 Kazusa Naruse CON_1TGYJDGXR3NG 1  
PRD_2KS8DHFVW31G,CON_1TGYJDGXR3NG,1 Chapter 2 PRD_2KS8DHFVW31G Kazusa Naruse CON_1TGYJDGXR3NG 1  
PRD_372220DPY9BG,CON_1TGYJDGXR3NG,1 Chapter 3 PRD_372220DPY9BG Kazusa Naruse CON_1TGYJDGXR3NG 1  
PRD_38BJCAG0VZ8G,CON_1TGYJDGXR3NG,1 Chapter 4 PRD_38BJCAG0VZ8G Kazusa Naruse CON_1TGYJDGXR3NG 1  
PRD_3E1DZ6936Q9G,CON_1TGYJDGXR3NG,1 Chapter 1 PRD_3E1DZ6936Q9G Kazusa Naruse CON_1TGYJDGXR3NG 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 10.193ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS