BookWalker

home / database

product_contributors

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

13 rows where contributor_id = "CON_0NZ2H63G0WM0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_0H3HH09VM820,CON_0NZ2H63G0WM0,0 Chapter 1 PRD_0H3HH09VM820 SAYURI SHICHIFUKU CON_0NZ2H63G0WM0 0  
PRD_0VH9EPEGDQF0,CON_0NZ2H63G0WM0,24 Chapter 4 PRD_0VH9EPEGDQF0 SAYURI SHICHIFUKU CON_0NZ2H63G0WM0 24  
PRD_0X6XBZ4HVYV0,CON_0NZ2H63G0WM0,24 Chapter 2 PRD_0X6XBZ4HVYV0 SAYURI SHICHIFUKU CON_0NZ2H63G0WM0 24  
PRD_123WVQ5VTDFG,CON_0NZ2H63G0WM0,0 Chapter 3 PRD_123WVQ5VTDFG SAYURI SHICHIFUKU CON_0NZ2H63G0WM0 0  
PRD_1SBJ0P44ETR0,CON_0NZ2H63G0WM0,24 My Beloved Stepbrother -The Possessive Love of the Sadistic Marquis PRD_1SBJ0P44ETR0 SAYURI SHICHIFUKU CON_0NZ2H63G0WM0 24  
PRD_28D8JV7J44P0,CON_0NZ2H63G0WM0,0 Chapter 5 PRD_28D8JV7J44P0 SAYURI SHICHIFUKU CON_0NZ2H63G0WM0 0  
PRD_2GQWGPQB3TD0,CON_0NZ2H63G0WM0,0 Chapter 4 PRD_2GQWGPQB3TD0 SAYURI SHICHIFUKU CON_0NZ2H63G0WM0 0  
PRD_2GT9RQYPP9JG,CON_0NZ2H63G0WM0,0 Chapter 2 PRD_2GT9RQYPP9JG SAYURI SHICHIFUKU CON_0NZ2H63G0WM0 0  
PRD_2H1E2WMK3310,CON_0NZ2H63G0WM0,24 Chapter 3 PRD_2H1E2WMK3310 SAYURI SHICHIFUKU CON_0NZ2H63G0WM0 24  
PRD_2N86MDZKF8ZG,CON_0NZ2H63G0WM0,24 Chapter 5 PRD_2N86MDZKF8ZG SAYURI SHICHIFUKU CON_0NZ2H63G0WM0 24  
PRD_2NTBNGY0NG5G,CON_0NZ2H63G0WM0,24 Chapter 6 PRD_2NTBNGY0NG5G SAYURI SHICHIFUKU CON_0NZ2H63G0WM0 24  
PRD_2TZXMAXXS0HG,CON_0NZ2H63G0WM0,0 Chapter 6 PRD_2TZXMAXXS0HG SAYURI SHICHIFUKU CON_0NZ2H63G0WM0 0  
PRD_2WSAJPTCXYBG,CON_0NZ2H63G0WM0,24 Chapter 1 PRD_2WSAJPTCXYBG SAYURI SHICHIFUKU CON_0NZ2H63G0WM0 24  

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.581ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS