BookWalker

home / database

product_contributors

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

11 rows where contributor_id = "CON_05MVQ76XTS60"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_04RTESY01NKG,CON_05MVQ76XTS60,1 Chapter 2 PRD_04RTESY01NKG Takashi Aosada CON_05MVQ76XTS60 1  
PRD_0QX2JDXZ2J60,CON_05MVQ76XTS60,1 Chapter 2 PRD_0QX2JDXZ2J60 Takashi Aosada CON_05MVQ76XTS60 1  
PRD_1D0S6F94J6J0,CON_05MVQ76XTS60,1 Chapter 6 PRD_1D0S6F94J6J0 Takashi Aosada CON_05MVQ76XTS60 1  
PRD_1D7AFGGQRMQG,CON_05MVQ76XTS60,1 Chapter 5 PRD_1D7AFGGQRMQG Takashi Aosada CON_05MVQ76XTS60 1  
PRD_1WJ50X73Z0Q0,CON_05MVQ76XTS60,1 Chapter 3 PRD_1WJ50X73Z0Q0 Takashi Aosada CON_05MVQ76XTS60 1  
PRD_2HH9H2BEY5H0,CON_05MVQ76XTS60,1 Chapter 4 PRD_2HH9H2BEY5H0 Takashi Aosada CON_05MVQ76XTS60 1  
PRD_2HNTS3JT4KPG,CON_05MVQ76XTS60,1 Chapter 3 PRD_2HNTS3JT4KPG Takashi Aosada CON_05MVQ76XTS60 1  
PRD_2MAN4PCW0JNG,CON_05MVQ76XTS60,1 Chapter 1 PRD_2MAN4PCW0JNG Takashi Aosada CON_05MVQ76XTS60 1  
PRD_3153WS8ZJG00,CON_05MVQ76XTS60,1 Chapter 5 PRD_3153WS8ZJG00 Takashi Aosada CON_05MVQ76XTS60 1  
PRD_35VJECA1YZ70,CON_05MVQ76XTS60,1 Chapter 4 PRD_35VJECA1YZ70 Takashi Aosada CON_05MVQ76XTS60 1  
PRD_3882SZ4BTY60,CON_05MVQ76XTS60,1 Chapter 1 PRD_3882SZ4BTY60 Takashi Aosada CON_05MVQ76XTS60 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.016ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS