BookWalker

home / database

product_contributors

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

18 rows where contributor_id = "CON_3HBQNE3CH66G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0724SR9YA770,CON_3HBQNE3CH66G,1 Chapter 10 PRD_0724SR9YA770 Yoko Ueda CON_3HBQNE3CH66G 1  
PRD_09BPK9RQYTH0,CON_3HBQNE3CH66G,1 Chapter 15 PRD_09BPK9RQYTH0 Yoko Ueda CON_3HBQNE3CH66G 1  
PRD_0BGQBBB0P660,CON_3HBQNE3CH66G,1 Chapter 5 PRD_0BGQBBB0P660 Yoko Ueda CON_3HBQNE3CH66G 1  
PRD_0E17PY5AJ550,CON_3HBQNE3CH66G,1 Chapter 9 PRD_0E17PY5AJ550 Yoko Ueda CON_3HBQNE3CH66G 1  
PRD_15850ZGYZ8GG,CON_3HBQNE3CH66G,1 Chapter 17 PRD_15850ZGYZ8GG Yoko Ueda CON_3HBQNE3CH66G 1  
PRD_184CBM5AV1R0,CON_3HBQNE3CH66G,1 Chapter 14 PRD_184CBM5AV1R0 Yoko Ueda CON_3HBQNE3CH66G 1  
PRD_1ERQX8675090,CON_3HBQNE3CH66G,1 Chapter 8 PRD_1ERQX8675090 Yoko Ueda CON_3HBQNE3CH66G 1  
PRD_1H46K40PT3B0,CON_3HBQNE3CH66G,1 Chapter 3 PRD_1H46K40PT3B0 Yoko Ueda CON_3HBQNE3CH66G 1  
PRD_1JQP1H7CY440,CON_3HBQNE3CH66G,1 Chapter 6 PRD_1JQP1H7CY440 Yoko Ueda CON_3HBQNE3CH66G 1  
PRD_1NTHYQ2S62A0,CON_3HBQNE3CH66G,1 Chapter 2 PRD_1NTHYQ2S62A0 Yoko Ueda CON_3HBQNE3CH66G 1  
PRD_2CBX77CWDQQ0,CON_3HBQNE3CH66G,1 Chapter 7 PRD_2CBX77CWDQQ0 Yoko Ueda CON_3HBQNE3CH66G 1  
PRD_2CEEF8MFG5MG,CON_3HBQNE3CH66G,1 Chapter 4 PRD_2CEEF8MFG5MG Yoko Ueda CON_3HBQNE3CH66G 1  
PRD_2KBF0T0Q3FY0,CON_3HBQNE3CH66G,1 Chapter 11 PRD_2KBF0T0Q3FY0 Yoko Ueda CON_3HBQNE3CH66G 1  
PRD_30J2W27QN920,CON_3HBQNE3CH66G,1 Chapter 16 PRD_30J2W27QN920 Yoko Ueda CON_3HBQNE3CH66G 1  
PRD_35K8RKD6B2RG,CON_3HBQNE3CH66G,1 Chapter 18 PRD_35K8RKD6B2RG Yoko Ueda CON_3HBQNE3CH66G 1  
PRD_3N1Y4BSZT800,CON_3HBQNE3CH66G,1 Chapter 13 PRD_3N1Y4BSZT800 Yoko Ueda CON_3HBQNE3CH66G 1  
PRD_3N4BCB1B165G,CON_3HBQNE3CH66G,1 Chapter 12 PRD_3N4BCB1B165G Yoko Ueda CON_3HBQNE3CH66G 1  
PRD_3QD94EKVR3TG,CON_3HBQNE3CH66G,1 Chapter 1 PRD_3QD94EKVR3TG Yoko Ueda CON_3HBQNE3CH66G 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.125ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS