product_contributors

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

9 rows where contributor_id = "CON_05F8AD673CCG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0CJMBD98CEAG,CON_05F8AD673CCG,17 Volume 8 PRD_0CJMBD98CEAG JinJun Park CON_05F8AD673CCG 17  
PRD_1K34P0AJ8D9G,CON_05F8AD673CCG,17 Volume 6 PRD_1K34P0AJ8D9G JinJun Park CON_05F8AD673CCG 17  
PRD_1QHQ1K4MMC8G,CON_05F8AD673CCG,17 Volume 4 PRD_1QHQ1K4MMC8G JinJun Park CON_05F8AD673CCG 17  
PRD_1T67K66YGBFG,CON_05F8AD673CCG,17 Volume 2 PRD_1T67K66YGBFG JinJun Park CON_05F8AD673CCG 17  
PRD_2E5DJ4YBEFV0,CON_05F8AD673CCG,17 Volume 9 PRD_2E5DJ4YBEFV0 JinJun Park CON_05F8AD673CCG 17  
PRD_3H8FFANQPDS0,CON_05F8AD673CCG,17 Volume 5 PRD_3H8FFANQPDS0 JinJun Park CON_05F8AD673CCG 17  
PRD_3JVWXQRDAET0,CON_05F8AD673CCG,17 Volume 7 PRD_3JVWXQRDAET0 JinJun Park CON_05F8AD673CCG 17  
PRD_3NYZTXQSJCR0,CON_05F8AD673CCG,17 Volume 3 PRD_3NYZTXQSJCR0 JinJun Park CON_05F8AD673CCG 17  
PRD_3RFE5GH3YBZ0,CON_05F8AD673CCG,17 Volume 1 PRD_3RFE5GH3YBZ0 JinJun Park CON_05F8AD673CCG 17  

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