product_contributors

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

8 rows where contributor_id = "CON_0M41Q4KVT14G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_06RR09ZHMJXG,CON_0M41Q4KVT14G,1 Vols. 9-10 PRD_06RR09ZHMJXG Rui Takato CON_0M41Q4KVT14G 1  
PRD_0ES540Y0TNMG,CON_0M41Q4KVT14G,1 Vols. 13-14 PRD_0ES540Y0TNMG Rui Takato CON_0M41Q4KVT14G 1  
PRD_207ZMH6239XG,CON_0M41Q4KVT14G,1 Vols. 15-16 PRD_207ZMH6239XG Rui Takato CON_0M41Q4KVT14G 1  
PRD_2CM1555GSCHG,CON_0M41Q4KVT14G,1 Vols. 7-8 PRD_2CM1555GSCHG Rui Takato CON_0M41Q4KVT14G 1  
PRD_2EYAN7CPDT10,CON_0M41Q4KVT14G,1 Vols. 1-2 PRD_2EYAN7CPDT10 Rui Takato CON_0M41Q4KVT14G 1  
PRD_3RNGHS703VS0,CON_0M41Q4KVT14G,1 Vols. 3-4 PRD_3RNGHS703VS0 Rui Takato CON_0M41Q4KVT14G 1  
PRD_3VYW2BPFYNYG,CON_0M41Q4KVT14G,1 Vols. 11-12 PRD_3VYW2BPFYNYG Rui Takato CON_0M41Q4KVT14G 1  
PRD_3WJT4F6EFP60,CON_0M41Q4KVT14G,1 Vols. 5-6 PRD_3WJT4F6EFP60 Rui Takato CON_0M41Q4KVT14G 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);