product_contributors

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

8 rows where contributor_id = "CON_3JM0KTB4PYKG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_09RV6GSHW3Q0,CON_3JM0KTB4PYKG,2 Shades of a Desperado PRD_09RV6GSHW3Q0 Reiko Morisaki CON_3JM0KTB4PYKG 2  
PRD_1GEF22K11Y5G,CON_3JM0KTB4PYKG,2 Claimed: Secret Royal Son PRD_1GEF22K11Y5G Reiko Morisaki CON_3JM0KTB4PYKG 2  
PRD_1SH9VQZDHVH0,CON_3JM0KTB4PYKG,2 Accidentally the Sheikh's Wife PRD_1SH9VQZDHVH0 Reiko Morisaki CON_3JM0KTB4PYKG 2  
PRD_1Y3J13PG9SJ0,CON_3JM0KTB4PYKG,2 Scarlet Woman PRD_1Y3J13PG9SJ0 Reiko Morisaki CON_3JM0KTB4PYKG 2  
PRD_20QZ712Z314G,CON_3JM0KTB4PYKG,2 The Desert Prince PRD_20QZ712Z314G Reiko Morisaki CON_3JM0KTB4PYKG 2  
PRD_26B7Z9D56Y40,CON_3JM0KTB4PYKG,2 Mistress Against Her Will PRD_26B7Z9D56Y40 Reiko Morisaki CON_3JM0KTB4PYKG 2  
PRD_38HGFGBBRXG0,CON_3JM0KTB4PYKG,2 Emergency Groom PRD_38HGFGBBRXG0 Reiko Morisaki CON_3JM0KTB4PYKG 2  
PRD_3EYCE4DYKV80,CON_3JM0KTB4PYKG,2 Sudden Danger PRD_3EYCE4DYKV80 Reiko Morisaki CON_3JM0KTB4PYKG 2  

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