product_contributors

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

6 rows where contributor_id = "CON_00987PTFQR2G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_1719XGRK0V5G,CON_00987PTFQR2G,1 Chapter 6: The Menu Of The Secretlove Room. PRD_1719XGRK0V5G Chike Kawakami CON_00987PTFQR2G 1  
PRD_1BQRF3TNCT4G,CON_00987PTFQR2G,1 Chapter 4: Wet with lies PRD_1BQRF3TNCT4G Chike Kawakami CON_00987PTFQR2G 1  
PRD_1E48TPMZ8SBG,CON_00987PTFQR2G,1 Chapter 2: Wet with lies PRD_1E48TPMZ8SBG Chike Kawakami CON_00987PTFQR2G 1  
PRD_35EHPSBGEVN0,CON_00987PTFQR2G,1 Chapter 5: Older Boyfriend~A Secret Wish PRD_35EHPSBGEVN0 Chike Kawakami CON_00987PTFQR2G 1  
PRD_39Z00C5TATM0,CON_00987PTFQR2G,1 Chapter 3: Wet with lies PRD_39Z00C5TATM0 Chike Kawakami CON_00987PTFQR2G 1  
PRD_3CDGKZ7WPSV0,CON_00987PTFQR2G,1 Chapter 1: Wet with lies PRD_3CDGKZ7WPSV0 Chike Kawakami CON_00987PTFQR2G 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);