BookWalker

home / database

product_contributors

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

15 rows where contributor_id = "CON_2PMY3XBBGW60"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0BS6RMM5EPVG,CON_2PMY3XBBGW60,1 Chapter 2 PRD_0BS6RMM5EPVG Kumanokotaro CON_2PMY3XBBGW60 1  
PRD_0M7JVAW12JE0,CON_2PMY3XBBGW60,1 Chapter 7 PRD_0M7JVAW12JE0 Kumanokotaro CON_2PMY3XBBGW60 1  
PRD_1HTDZ2GMY49G,CON_2PMY3XBBGW60,1 Chapter 9 PRD_1HTDZ2GMY49G Kumanokotaro CON_2PMY3XBBGW60 1  
PRD_1PGFMTQ9CJBG,CON_2PMY3XBBGW60,1 Chapter 3 PRD_1PGFMTQ9CJBG Kumanokotaro CON_2PMY3XBBGW60 1  
PRD_21J63ESNX5S0,CON_2PMY3XBBGW60,1 Chapter 8 PRD_21J63ESNX5S0 Kumanokotaro CON_2PMY3XBBGW60 1  
PRD_22E21368NT0G,CON_2PMY3XBBGW60,1 Chapter 3 PRD_22E21368NT0G Kumanokotaro CON_2PMY3XBBGW60 1  
PRD_2JWA1J1TCVKG,CON_2PMY3XBBGW60,1 Chapter 1 PRD_2JWA1J1TCVKG Kumanokotaro CON_2PMY3XBBGW60 1  
PRD_32D1NXZWYZR0,CON_2PMY3XBBGW60,1 Chapter 5 PRD_32D1NXZWYZR0 Kumanokotaro CON_2PMY3XBBGW60 1  
PRD_348729H7SGS0,CON_2PMY3XBBGW60,1 Chapter 5 PRD_348729H7SGS0 Kumanokotaro CON_2PMY3XBBGW60 1  
PRD_3CC4Z77YNZS0,CON_2PMY3XBBGW60,1 Chapter 6 PRD_3CC4Z77YNZS0 Kumanokotaro CON_2PMY3XBBGW60 1  
PRD_3CQ2F9PNEVW0,CON_2PMY3XBBGW60,1 Chapter 2 PRD_3CQ2F9PNEVW0 Kumanokotaro CON_2PMY3XBBGW60 1  
PRD_3H8YYPNJJPY0,CON_2PMY3XBBGW60,1 Chapter 4 PRD_3H8YYPNJJPY0 Kumanokotaro CON_2PMY3XBBGW60 1  
PRD_3K58E32PMK90,CON_2PMY3XBBGW60,1 Chapter 1 PRD_3K58E32PMK90 Kumanokotaro CON_2PMY3XBBGW60 1  
PRD_3SSYC01SQCD0,CON_2PMY3XBBGW60,1 Chapter 6 PRD_3SSYC01SQCD0 Kumanokotaro CON_2PMY3XBBGW60 1  
PRD_3VE6RP3GPHT0,CON_2PMY3XBBGW60,1 Chapter 4 PRD_3VE6RP3GPHT0 Kumanokotaro CON_2PMY3XBBGW60 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 11.049ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS