BookWalker

home / database

product_contributors

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

10 rows where contributor_id = "CON_224ZABPG64N0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0HDEYN8D1YVG,CON_224ZABPG64N0,1 Chapter 10 PRD_0HDEYN8D1YVG UMI CON_224ZABPG64N0 1  
PRD_0JWZK2EB5ZMG,CON_224ZABPG64N0,1 Chapter 3 PRD_0JWZK2EB5ZMG UMI CON_224ZABPG64N0 1  
PRD_15GMXJ3SZH70,CON_224ZABPG64N0,1 Chapter 8 PRD_15GMXJ3SZH70 UMI CON_224ZABPG64N0 1  
PRD_1817F6X3VG60,CON_224ZABPG64N0,1 Chapter 6 PRD_1817F6X3VG60 UMI CON_224ZABPG64N0 1  
PRD_1CQQTSZ67Z50,CON_224ZABPG64N0,1 Chapter 4 PRD_1CQQTSZ67Z50 UMI CON_224ZABPG64N0 1  
PRD_2K464CS83Y40,CON_224ZABPG64N0,1 Chapter 2 PRD_2K464CS83Y40 UMI CON_224ZABPG64N0 1  
PRD_2QTPQZTJFXB0,CON_224ZABPG64N0,1 Chapter 1 PRD_2QTPQZTJFXB0 UMI CON_224ZABPG64N0 1  
PRD_37BCB9GMHJQG,CON_224ZABPG64N0,1 Chapter 9 PRD_37BCB9GMHJQG UMI CON_224ZABPG64N0 1  
PRD_3BSWPWJYXHPG,CON_224ZABPG64N0,1 Chapter 7 PRD_3BSWPWJYXHPG UMI CON_224ZABPG64N0 1  
PRD_3EEF0FC0SGNG,CON_224ZABPG64N0,1 Chapter 5 PRD_3EEF0FC0SGNG UMI CON_224ZABPG64N0 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 7.323ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS