BookWalker

home / database

product_contributors

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

18 rows where contributor_id = "CON_17FC70QDVZ30"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_03RP4Y3NEMNG,CON_17FC70QDVZ30,1 Chapter 9 PRD_03RP4Y3NEMNG Sunin CON_17FC70QDVZ30 1  
PRD_0696QJXZAKMG,CON_17FC70QDVZ30,1 Chapter 7 PRD_0696QJXZAKMG Sunin CON_17FC70QDVZ30 1  
PRD_09C0CRSBJHTG,CON_17FC70QDVZ30,1 Chapter 3 PRD_09C0CRSBJHTG Sunin CON_17FC70QDVZ30 1  
PRD_0AZH15Z1PJVG,CON_17FC70QDVZ30,1 Chapter 5 PRD_0AZH15Z1PJVG Sunin CON_17FC70QDVZ30 1  
PRD_0C2GYBVDYGSG,CON_17FC70QDVZ30,1 Chapter 1 PRD_0C2GYBVDYGSG Sunin CON_17FC70QDVZ30 1  
PRD_0HPNJJ8WY8HG,CON_17FC70QDVZ30,1 Chapter 17 PRD_0HPNJJ8WY8HG Sunin CON_17FC70QDVZ30 1  
PRD_0M74W5A6TQGG,CON_17FC70QDVZ30,1 Chapter 15 PRD_0M74W5A6TQGG Sunin CON_17FC70QDVZ30 1  
PRD_0RNQFR496PQG,CON_17FC70QDVZ30,1 Chapter 13 PRD_0RNQFR496PQG Sunin CON_17FC70QDVZ30 1  
PRD_0ZA7SB1K2NPG,CON_17FC70QDVZ30,1 Chapter 11 PRD_0ZA7SB1K2NPG Sunin CON_17FC70QDVZ30 1  
PRD_201YX8JTCK50,CON_17FC70QDVZ30,1 Chapter 8 PRD_201YX8JTCK50 Sunin CON_17FC70QDVZ30 1  
PRD_24P98VCW8J40,CON_17FC70QDVZ30,1 Chapter 6 PRD_24P98VCW8J40 Sunin CON_17FC70QDVZ30 1  
PRD_2B4STEE6MHB0,CON_17FC70QDVZ30,1 Chapter 4 PRD_2B4STEE6MHB0 Sunin CON_17FC70QDVZ30 1  
PRD_2FN85188GGA0,CON_17FC70QDVZ30,1 Chapter 2 PRD_2FN85188GGA0 Sunin CON_17FC70QDVZ30 1  
PRD_2K9DR9SZG820,CON_17FC70QDVZ30,1 Chapter 18 PRD_2K9DR9SZG820 Sunin CON_17FC70QDVZ30 1  
PRD_2QZWBWV1WQ10,CON_17FC70QDVZ30,1 Chapter 16 PRD_2QZWBWV1WQ10 Sunin CON_17FC70QDVZ30 1  
PRD_2S2Z02QE4N70,CON_17FC70QDVZ30,1 Chapter 12 PRD_2S2Z02QE4N70 Sunin CON_17FC70QDVZ30 1  
PRD_2TCCNFNBRP00,CON_17FC70QDVZ30,1 Chapter 14 PRD_2TCCNFNBRP00 Sunin CON_17FC70QDVZ30 1  
PRD_2XKFKNGG0M60,CON_17FC70QDVZ30,1 Chapter 10 PRD_2XKFKNGG0M60 Sunin CON_17FC70QDVZ30 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 8.985ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS