product_contributors

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

17 rows where contributor_id = "CON_3F6JD3M82YVG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_00CFAB1Q6XD0,CON_3F6JD3M82YVG,7 Volume 1 PRD_00CFAB1Q6XD0 Chi Bui CON_3F6JD3M82YVG 7  
PRD_072ZNY3S2WC0,CON_3F6JD3M82YVG,7 Volume 4 PRD_072ZNY3S2WC0 Chi Bui CON_3F6JD3M82YVG 7  
PRD_0BFV6TBC5ND0,CON_3F6JD3M82YVG,7 Chapter 7 PRD_0BFV6TBC5ND0 Chi Bui CON_3F6JD3M82YVG 7  
PRD_0FH9QF4EP610,CON_3F6JD3M82YVG,7 Volume 1 PRD_0FH9QF4EP610 Chi Bui CON_3F6JD3M82YVG 7  
PRD_0FWBGD4P1MC0,CON_3F6JD3M82YVG,7 Chapter 5 PRD_0FWBGD4P1MC0 Chi Bui CON_3F6JD3M82YVG 7  
PRD_0P6ZP8MFDBB0,CON_3F6JD3M82YVG,7 Chapter 1 PRD_0P6ZP8MFDBB0 Chi Bui CON_3F6JD3M82YVG 7  
PRD_0XZWRR4CTYE0,CON_3F6JD3M82YVG,7 Volume 2 PRD_0XZWRR4CTYE0 Chi Bui CON_3F6JD3M82YVG 7  
PRD_1ES18SH9DWV0,CON_3F6JD3M82YVG,7 Chapter 9 PRD_1ES18SH9DWV0 Chi Bui CON_3F6JD3M82YVG 7  
PRD_1H3NEK029KJ0,CON_3F6JD3M82YVG,7 Chapter 8 PRD_1H3NEK029KJ0 Chi Bui CON_3F6JD3M82YVG 7  
PRD_1JJT306RDMK0,CON_3F6JD3M82YVG,7 Chapter 3 PRD_1JJT306RDMK0 Chi Bui CON_3F6JD3M82YVG 7  
PRD_2274H2PHRYXG,CON_3F6JD3M82YVG,7 Volume 3 PRD_2274H2PHRYXG Chi Bui CON_3F6JD3M82YVG 7  
PRD_26G02YY4VQYG,CON_3F6JD3M82YVG,7 Chapter 10 PRD_26G02YY4VQYG Chi Bui CON_3F6JD3M82YVG 7  
PRD_29Q3Z4NH3NWG,CON_3F6JD3M82YVG,7 Chapter 6 PRD_29Q3Z4NH3NWG Chi Bui CON_3F6JD3M82YVG 7  
PRD_2C5JAQQVFM3G,CON_3F6JD3M82YVG,7 Chapter 4 PRD_2C5JAQQVFM3G Chi Bui CON_3F6JD3M82YVG 7  
PRD_2GNK9XAJP7P0,CON_3F6JD3M82YVG,7 One More Step, Come Stand by My Side PRD_2GNK9XAJP7P0 Chi Bui CON_3F6JD3M82YVG 7  
PRD_2VG8QA93AQDG,CON_3F6JD3M82YVG,7 Volume 2 PRD_2VG8QA93AQDG Chi Bui CON_3F6JD3M82YVG 7  
PRD_3GT2MAHXBK2G,CON_3F6JD3M82YVG,7 Chapter 2 PRD_3GT2MAHXBK2G Chi Bui CON_3F6JD3M82YVG 7  

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);