BookWalker

home / database

product_contributors

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

14 rows where contributor_id = "CON_08S91K49TFJG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_04CJFWETM820,CON_08S91K49TFJG,1 Story Chapter 2 PRD_04CJFWETM820 Svetlana Chmakova CON_08S91K49TFJG 1  
PRD_0FVVPS31KAZ0,CON_08S91K49TFJG,1 Brave PRD_0FVVPS31KAZ0 Svetlana Chmakova CON_08S91K49TFJG 1  
PRD_0HBAPF6MCPV0,CON_08S91K49TFJG,1 Enemies PRD_0HBAPF6MCPV0 Svetlana Chmakova CON_08S91K49TFJG 1  
PRD_0XRDQ8157NH0,CON_08S91K49TFJG,1 Crush PRD_0XRDQ8157NH0 Svetlana Chmakova CON_08S91K49TFJG 1  
PRD_0YG915XEVHCG,CON_08S91K49TFJG,1 Volume 1 PRD_0YG915XEVHCG Svetlana Chmakova CON_08S91K49TFJG 1  
PRD_11KZVCXKJ780,CON_08S91K49TFJG,3 Volume 3 PRD_11KZVCXKJ780 Svetlana Chmakova CON_08S91K49TFJG 3  
PRD_1D2W59YWRTNG,CON_08S91K49TFJG,2 Volume 2 PRD_1D2W59YWRTNG Svetlana Chmakova CON_08S91K49TFJG 2  
PRD_1SH6EN0CT1E0,CON_08S91K49TFJG,2 Volume 1 PRD_1SH6EN0CT1E0 Svetlana Chmakova CON_08S91K49TFJG 2  
PRD_1T6VFMXTGEQG,CON_08S91K49TFJG,1 Volume 2 PRD_1T6VFMXTGEQG Svetlana Chmakova CON_08S91K49TFJG 1  
PRD_267BPKZNP9JG,CON_08S91K49TFJG,1 Story Chapter 3 PRD_267BPKZNP9JG Svetlana Chmakova CON_08S91K49TFJG 1  
PRD_26D2ENPZP3V0,CON_08S91K49TFJG,1 Story Chapter 1 PRD_26D2ENPZP3V0 Svetlana Chmakova CON_08S91K49TFJG 1  
PRD_2RB18VJ9XJX0,CON_08S91K49TFJG,1 Volume 2 PRD_2RB18VJ9XJX0 Svetlana Chmakova CON_08S91K49TFJG 1  
PRD_3K1H0485CQ50,CON_08S91K49TFJG,1 Volume 1 PRD_3K1H0485CQ50 Svetlana Chmakova CON_08S91K49TFJG 1  
PRD_3X230YWX1VFG,CON_08S91K49TFJG,1 Awkward PRD_3X230YWX1VFG Svetlana Chmakova CON_08S91K49TFJG 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.1ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS