BookWalker

home / database

product_contributors

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

13 rows where contributor_id = "CON_20YN94BHCPD0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0A0C8N73VJYG,CON_20YN94BHCPD0,1 Volume 5 PRD_0A0C8N73VJYG Mizuho Itsuki CON_20YN94BHCPD0 1  
PRD_0HEJGS52NK1G,CON_20YN94BHCPD0,1 Volume 10 PRD_0HEJGS52NK1G Mizuho Itsuki CON_20YN94BHCPD0 1  
PRD_14XRZ2CX8CYG,CON_20YN94BHCPD0,1 Volume 12 PRD_14XRZ2CX8CYG Mizuho Itsuki CON_20YN94BHCPD0 1  
PRD_1B45RAR2J1C0,CON_20YN94BHCPD0,1 Volume 9 PRD_1B45RAR2J1C0 Mizuho Itsuki CON_20YN94BHCPD0 1  
PRD_1M0W0XGWAF50,CON_20YN94BHCPD0,1 Volume 11 PRD_1M0W0XGWAF50 Mizuho Itsuki CON_20YN94BHCPD0 1  
PRD_1RHCKGJ6PE40,CON_20YN94BHCPD0,1 Volume 6 PRD_1RHCKGJ6PE40 Mizuho Itsuki CON_20YN94BHCPD0 1  
PRD_1VR3G7GMTB30,CON_20YN94BHCPD0,1 Volume 8 PRD_1VR3G7GMTB30 Mizuho Itsuki CON_20YN94BHCPD0 1  
PRD_28TV4EAJJWQG,CON_20YN94BHCPD0,1 Volume 13 PRD_28TV4EAJJWQG Mizuho Itsuki CON_20YN94BHCPD0 1  
PRD_29KWXC326FYG,CON_20YN94BHCPD0,1 Volume 1 PRD_29KWXC326FYG Mizuho Itsuki CON_20YN94BHCPD0 1  
PRD_2B10AZCYA8TG,CON_20YN94BHCPD0,1 Volume 3 PRD_2B10AZCYA8TG Mizuho Itsuki CON_20YN94BHCPD0 1  
PRD_3CSX8RQ92J5G,CON_20YN94BHCPD0,1 Volume 2 PRD_3CSX8RQ92J5G Mizuho Itsuki CON_20YN94BHCPD0 1  
PRD_3QMBQD2J4NE0,CON_20YN94BHCPD0,1 Volume 4 PRD_3QMBQD2J4NE0 Mizuho Itsuki CON_20YN94BHCPD0 1  
PRD_3ZZ87GQNBN60,CON_20YN94BHCPD0,1 Volume 7 PRD_3ZZ87GQNBN60 Mizuho Itsuki CON_20YN94BHCPD0 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);
Powered by Datasette · Queries took 9.105ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS