product_contributors

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

9 rows where contributor_id = "CON_03TX75TP3D6G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_02Q25YVYG7EG,CON_03TX75TP3D6G,1 Chapter 1 PRD_02Q25YVYG7EG Kana Hoshida CON_03TX75TP3D6G 1  
PRD_0PH1FSF50XN0,CON_03TX75TP3D6G,1 Chapter 8 PRD_0PH1FSF50XN0 Kana Hoshida CON_03TX75TP3D6G 1  
PRD_0Y6KTBSMQRFG,CON_03TX75TP3D6G,1 Chapter 3 PRD_0Y6KTBSMQRFG Kana Hoshida CON_03TX75TP3D6G 1  
PRD_2MY903YAEW4G,CON_03TX75TP3D6G,1 Chapter 7 PRD_2MY903YAEW4G Kana Hoshida CON_03TX75TP3D6G 1  
PRD_2VW43SSDAHAG,CON_03TX75TP3D6G,1 Chapter 5 PRD_2VW43SSDAHAG Kana Hoshida CON_03TX75TP3D6G 1  
PRD_2X7G00W4SDE0,CON_03TX75TP3D6G,1 Chapter 6 PRD_2X7G00W4SDE0 Kana Hoshida CON_03TX75TP3D6G 1  
PRD_2YH1NC22XEF0,CON_03TX75TP3D6G,1 Chapter 4 PRD_2YH1NC22XEF0 Kana Hoshida CON_03TX75TP3D6G 1  
PRD_33TQEJFBQG7G,CON_03TX75TP3D6G,1 Chapter 2 PRD_33TQEJFBQG7G Kana Hoshida CON_03TX75TP3D6G 1  
PRD_3KAMDV8VF4CG,CON_03TX75TP3D6G,1 Chapter 9 PRD_3KAMDV8VF4CG Kana Hoshida CON_03TX75TP3D6G 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);