product_contributors

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

8 rows where contributor_id = "CON_3KCV7JVVH350"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_028F89ZGGFE0,CON_3KCV7JVVH350,1 Volume 1: Windchaser Alley PRD_028F89ZGGFE0 Yoimachi Meme CON_3KCV7JVVH350 1  
PRD_06YZVWSTWED0,CON_3KCV7JVVH350,1 Volume 3: The Final Eve PRD_06YZVWSTWED0 Yoimachi Meme CON_3KCV7JVVH350 1  
PRD_0CJ93NQ90CJ0,CON_3KCV7JVVH350,1 Volume 2: The Illusionary Wonderland PRD_0CJ93NQ90CJ0 Yoimachi Meme CON_3KCV7JVVH350 1  
PRD_0G62PW4R03A0,CON_3KCV7JVVH350,1 Volume 5: What Settles in the Night PRD_0G62PW4R03A0 Yoimachi Meme CON_3KCV7JVVH350 1  
PRD_0MMX0F62C290,CON_3KCV7JVVH350,1 Volume 3: The Nightmares of the Depths PRD_0MMX0F62C290 Yoimachi Meme CON_3KCV7JVVH350 1  
PRD_20HQ2JENYFXG,CON_3KCV7JVVH350,1 Volume 2: Night of the Lantern Fair PRD_20HQ2JENYFXG Yoimachi Meme CON_3KCV7JVVH350 1  
PRD_2766C58ZTEWG,CON_3KCV7JVVH350,1 Volume 4: Memory Rays PRD_2766C58ZTEWG Yoimachi Meme CON_3KCV7JVVH350 1  
PRD_2E519B442C2G,CON_3KCV7JVVH350,1 Volume 1: Splish-Splash City PRD_2E519B442C2G Yoimachi Meme CON_3KCV7JVVH350 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);