product_contributors

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

7 rows where contributor_id = "CON_3Y9D28G6PSE0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0GN83F221WWG,CON_3Y9D28G6PSE0,2 His Brother's Child PRD_0GN83F221WWG SATORU ASAMI CON_3Y9D28G6PSE0 2  
PRD_31VHNRQYAA9G,CON_3Y9D28G6PSE0,2 Sup With The Devil PRD_31VHNRQYAA9G SATORU ASAMI CON_3Y9D28G6PSE0 2  
PRD_386QTSSKCPS0,CON_3Y9D28G6PSE0,2 Ruthless Contract PRD_386QTSSKCPS0 SATORU ASAMI CON_3Y9D28G6PSE0 2  
PRD_3B25FK5SF5Y0,CON_3Y9D28G6PSE0,2 The Inward Storm PRD_3B25FK5SF5Y0 SATORU ASAMI CON_3Y9D28G6PSE0 2  
PRD_3KJ15GFMAPXG,CON_3Y9D28G6PSE0,2 The Texan's Tiny Secret PRD_3KJ15GFMAPXG SATORU ASAMI CON_3Y9D28G6PSE0 2  
PRD_3PT5VMKJP920,CON_3Y9D28G6PSE0,2 The Millionaire'S Christmas Wife PRD_3PT5VMKJP920 SATORU ASAMI CON_3Y9D28G6PSE0 2  
PRD_3WRWWSXHPD9G,CON_3Y9D28G6PSE0,2 Iron Cowboy PRD_3WRWWSXHPD9G SATORU ASAMI CON_3Y9D28G6PSE0 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);