BookWalker

home / database

product_contributors

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

14 rows where contributor_id = "CON_3NDZG196ZFHG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0KN0Q0CSE950,CON_3NDZG196ZFHG,1 Chapter 6 PRD_0KN0Q0CSE950 Mihoko Kojima CON_3NDZG196ZFHG 1  
PRD_0KVR4NZWM8P0,CON_3NDZG196ZFHG,1 Chapter 9 PRD_0KVR4NZWM8P0 Mihoko Kojima CON_3NDZG196ZFHG 1  
PRD_0P88P8S6GQN0,CON_3NDZG196ZFHG,1 Chapter 11 PRD_0P88P8S6GQN0 Mihoko Kojima CON_3NDZG196ZFHG 1  
PRD_0PBK2KE3A840,CON_3NDZG196ZFHG,1 Chapter 4 PRD_0PBK2KE3A840 Mihoko Kojima CON_3NDZG196ZFHG 1  
PRD_0SEJZSAFJPA0,CON_3NDZG196ZFHG,1 Volume 1 PRD_0SEJZSAFJPA0 Mihoko Kojima CON_3NDZG196ZFHG 1  
PRD_0TR2C685PQB0,CON_3NDZG196ZFHG,1 Chapter 2 PRD_0TR2C685PQB0 Mihoko Kojima CON_3NDZG196ZFHG 1  
PRD_1DDRYQXM0ANG,CON_3NDZG196ZFHG,1 Chapter 7 PRD_1DDRYQXM0ANG Mihoko Kojima CON_3NDZG196ZFHG 1  
PRD_1DJHJBCZP86G,CON_3NDZG196ZFHG,1 Volume 3 PRD_1DJHJBCZP86G Mihoko Kojima CON_3NDZG196ZFHG 1  
PRD_2G2B8AZYC9MG,CON_3NDZG196ZFHG,1 Chapter 5 PRD_2G2B8AZYC9MG Mihoko Kojima CON_3NDZG196ZFHG 1  
PRD_2G30XYE1JQ5G,CON_3NDZG196ZFHG,1 Chapter 12 PRD_2G30XYE1JQ5G Mihoko Kojima CON_3NDZG196ZFHG 1  
PRD_2MGVVXS088VG,CON_3NDZG196ZFHG,1 Chapter 3 PRD_2MGVVXS088VG Mihoko Kojima CON_3NDZG196ZFHG 1  
PRD_2MHK8H8BYP4G,CON_3NDZG196ZFHG,1 Chapter 10 PRD_2MHK8H8BYP4G Mihoko Kojima CON_3NDZG196ZFHG 1  
PRD_2V1A6GVAMQTG,CON_3NDZG196ZFHG,1 Volume 2 PRD_2V1A6GVAMQTG Mihoko Kojima CON_3NDZG196ZFHG 1  
PRD_3F4G4DJQ2A60,CON_3NDZG196ZFHG,1 Chapter 8 PRD_3F4G4DJQ2A60 Mihoko Kojima CON_3NDZG196ZFHG 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 9.765ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS