product_contributors
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
7 rows where contributor_id = "CON_3BCCB2448WTG"
This data as json, CSV (advanced)
| Link | product_id | contributor_id | role | name_override |
|---|---|---|---|---|
| PRD_1BJHJM57VBH0,CON_3BCCB2448WTG,1 | Volume 2 PRD_1BJHJM57VBH0 | Kiyoko Iwami CON_3BCCB2448WTG | 1 | |
| PRD_1HJTCE8MPC3G,CON_3BCCB2448WTG,1 | Volume 1 PRD_1HJTCE8MPC3G | Kiyoko Iwami CON_3BCCB2448WTG | 1 | |
| PRD_1QR86SXK43M0,CON_3BCCB2448WTG,1 | Volume 3 PRD_1QR86SXK43M0 | Kiyoko Iwami CON_3BCCB2448WTG | 1 | |
| PRD_1VFZJ9V0EP0G,CON_3BCCB2448WTG,1 | Volume 6 PRD_1VFZJ9V0EP0G | Kiyoko Iwami CON_3BCCB2448WTG | 1 | |
| PRD_2TC6KBNAV310,CON_3BCCB2448WTG,1 | Volume 5 PRD_2TC6KBNAV310 | Kiyoko Iwami CON_3BCCB2448WTG | 1 | |
| PRD_3BWBX4ZBBCQ0,CON_3BCCB2448WTG,1 | Volume 4 PRD_3BWBX4ZBBCQ0 | Kiyoko Iwami CON_3BCCB2448WTG | 1 | |
| PRD_3FQEF11EAEAG,CON_3BCCB2448WTG,1 | Transparent Light Blue PRD_3FQEF11EAEAG | Kiyoko Iwami CON_3BCCB2448WTG | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);