BookWalker

home / database

product_contributors

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

15 rows where contributor_id = "CON_14EKBVWSMYYG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_009MR7YAJW8G,CON_14EKBVWSMYYG,18 Chapter 5 PRD_009MR7YAJW8G B-Ginga CON_14EKBVWSMYYG 18  
PRD_04Y7BTRCYVFG,CON_14EKBVWSMYYG,18 Chapter 3 PRD_04Y7BTRCYVFG B-Ginga CON_14EKBVWSMYYG 18  
PRD_0BCQNDNPTTEG,CON_14EKBVWSMYYG,18 Chapter 1 PRD_0BCQNDNPTTEG B-Ginga CON_14EKBVWSMYYG 18  
PRD_0P7A6T6J2G4G,CON_14EKBVWSMYYG,18 Chapter 13 PRD_0P7A6T6J2G4G B-Ginga CON_14EKBVWSMYYG 18  
PRD_0SAN302YAYAG,CON_14EKBVWSMYYG,18 Chapter 10 PRD_0SAN302YAYAG B-Ginga CON_14EKBVWSMYYG 18  
PRD_0TNTGD0MEZBG,CON_14EKBVWSMYYG,18 Chapter 11 PRD_0TNTGD0MEZBG B-Ginga CON_14EKBVWSMYYG 18  
PRD_0XV4EMW0PX9G,CON_14EKBVWSMYYG,18 Chapter 7 PRD_0XV4EMW0PX9G B-Ginga CON_14EKBVWSMYYG 18  
PRD_220C7XF5MXS0,CON_14EKBVWSMYYG,18 Chapter 6 PRD_220C7XF5MXS0 B-Ginga CON_14EKBVWSMYYG 18  
PRD_257FW3AHWVZ0,CON_14EKBVWSMYYG,18 Chapter 2 PRD_257FW3AHWVZ0 B-Ginga CON_14EKBVWSMYYG 18  
PRD_26PWJG9FGWR0,CON_14EKBVWSMYYG,18 Chapter 4 PRD_26PWJG9FGWR0 B-Ginga CON_14EKBVWSMYYG 18  
PRD_2HY2DHMD4HN0,CON_14EKBVWSMYYG,18 Chapter 14 PRD_2HY2DHMD4HN0 B-Ginga CON_14EKBVWSMYYG 18  
PRD_2MCJZ4HQ0GM0,CON_14EKBVWSMYYG,18 Chapter 12 PRD_2MCJZ4HQ0GM0 B-Ginga CON_14EKBVWSMYYG 18  
PRD_2RXDAQKSCZV0,CON_14EKBVWSMYYG,18 Chapter 9 PRD_2RXDAQKSCZV0 B-Ginga CON_14EKBVWSMYYG 18  
PRD_2ZKXMAD38YT0,CON_14EKBVWSMYYG,18 Chapter 8 PRD_2ZKXMAD38YT0 B-Ginga CON_14EKBVWSMYYG 18  
PRD_3BMY5FRAFT60,CON_14EKBVWSMYYG,18 Chapter 15 PRD_3BMY5FRAFT60 B-Ginga CON_14EKBVWSMYYG 18  

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