product_contributors

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

17 rows where contributor_id = "CON_04EP70K8WN7G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_054A2E772TC0,CON_04EP70K8WN7G,2 Volume 15 PRD_054A2E772TC0 Tomowo Maruyama CON_04EP70K8WN7G 2  
PRD_05EADH7ZT9GG,CON_04EP70K8WN7G,2 Volume 5 PRD_05EADH7ZT9GG Tomowo Maruyama CON_04EP70K8WN7G 2  
PRD_061BRPNX448G,CON_04EP70K8WN7G,2 Volume 8 PRD_061BRPNX448G Tomowo Maruyama CON_04EP70K8WN7G 2  
PRD_0A3GYYKRBTHG,CON_04EP70K8WN7G,2 Volume 9 PRD_0A3GYYKRBTHG Tomowo Maruyama CON_04EP70K8WN7G 2  
PRD_0QC257VXS2B0,CON_04EP70K8WN7G,2 Volume 2 PRD_0QC257VXS2B0 Tomowo Maruyama CON_04EP70K8WN7G 2  
PRD_0YFMMM1T0100,CON_04EP70K8WN7G,2 Volume 4 PRD_0YFMMM1T0100 Tomowo Maruyama CON_04EP70K8WN7G 2  
PRD_19W96YB8R640,CON_04EP70K8WN7G,2 Volume 16 PRD_19W96YB8R640 Tomowo Maruyama CON_04EP70K8WN7G 2  
PRD_1BHM7P8C5JSG,CON_04EP70K8WN7G,2 Volume 11 PRD_1BHM7P8C5JSG Tomowo Maruyama CON_04EP70K8WN7G 2  
PRD_1CS2SZ5YNRJ0,CON_04EP70K8WN7G,2 Volume 6 PRD_1CS2SZ5YNRJ0 Tomowo Maruyama CON_04EP70K8WN7G 2  
PRD_1KXKFNWXJ71G,CON_04EP70K8WN7G,2 Volume 3 PRD_1KXKFNWXJ71G Tomowo Maruyama CON_04EP70K8WN7G 2  
PRD_2BGGFNKQGYRG,CON_04EP70K8WN7G,2 Volume 1 PRD_2BGGFNKQGYRG Tomowo Maruyama CON_04EP70K8WN7G 2  
PRD_2GFH4TNFJKAG,CON_04EP70K8WN7G,2 Volume 12 PRD_2GFH4TNFJKAG Tomowo Maruyama CON_04EP70K8WN7G 2  
PRD_344AYEYQZ7M0,CON_04EP70K8WN7G,2 Volume 10 PRD_344AYEYQZ7M0 Tomowo Maruyama CON_04EP70K8WN7G 2  
PRD_34NKEQ0HSTP0,CON_04EP70K8WN7G,2 Volume 14 PRD_34NKEQ0HSTP0 Tomowo Maruyama CON_04EP70K8WN7G 2  
PRD_3K06Q9771KF0,CON_04EP70K8WN7G,2 Volume 7 PRD_3K06Q9771KF0 Tomowo Maruyama CON_04EP70K8WN7G 2  
PRD_3N8E33DVN520,CON_04EP70K8WN7G,2 Volume 13 PRD_3N8E33DVN520 Tomowo Maruyama CON_04EP70K8WN7G 2  
PRD_3YVXMTYZTG2G,CON_04EP70K8WN7G,2 Volume 17 PRD_3YVXMTYZTG2G Tomowo Maruyama CON_04EP70K8WN7G 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);