product_contributors

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

13 rows where contributor_id = "CON_3MBWQ3XHZMTG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_02FSMFMZ2JC0,CON_3MBWQ3XHZMTG,7 Chapter 30 PRD_02FSMFMZ2JC0 Ali Zaghlul CON_3MBWQ3XHZMTG 7  
PRD_06W872P1EJK0,CON_3MBWQ3XHZMTG,7 Chapter 36 PRD_06W872P1EJK0 Ali Zaghlul CON_3MBWQ3XHZMTG 7  
PRD_0MTEDPZ8YNF0,CON_3MBWQ3XHZMTG,7 Chapter 28 PRD_0MTEDPZ8YNF0 Ali Zaghlul CON_3MBWQ3XHZMTG 7  
PRD_0V8YZ9RJTME0,CON_3MBWQ3XHZMTG,7 Chapter 34 PRD_0V8YZ9RJTME0 Ali Zaghlul CON_3MBWQ3XHZMTG 7  
PRD_0ZS9AWTN6KD0,CON_3MBWQ3XHZMTG,7 Chapter 37 PRD_0ZS9AWTN6KD0 Ali Zaghlul CON_3MBWQ3XHZMTG 7  
PRD_11TAPDV94BMG,CON_3MBWQ3XHZMTG,7 Chapter 38 PRD_11TAPDV94BMG Ali Zaghlul CON_3MBWQ3XHZMTG 7  
PRD_18SMCKPNC9TG,CON_3MBWQ3XHZMTG,7 Chapter 29 PRD_18SMCKPNC9TG Ali Zaghlul CON_3MBWQ3XHZMTG 7  
PRD_1FE4Y6GZ88SG,CON_3MBWQ3XHZMTG,7 Chapter 39 PRD_1FE4Y6GZ88SG Ali Zaghlul CON_3MBWQ3XHZMTG 7  
PRD_1Y56S4XFP48G,CON_3MBWQ3XHZMTG,7 Chapter 32 PRD_1Y56S4XFP48G Ali Zaghlul CON_3MBWQ3XHZMTG 7  
PRD_20Q0ER7W0J3G,CON_3MBWQ3XHZMTG,7 Chapter 31 PRD_20Q0ER7W0J3G Ali Zaghlul CON_3MBWQ3XHZMTG 7  
PRD_33D2X3846B50,CON_3MBWQ3XHZMTG,7 Chapter 40 PRD_33D2X3846B50 Ali Zaghlul CON_3MBWQ3XHZMTG 7  
PRD_396W5W1TA8A0,CON_3MBWQ3XHZMTG,7 Chapter 33 PRD_396W5W1TA8A0 Ali Zaghlul CON_3MBWQ3XHZMTG 7  
PRD_3AGDT97GE9B0,CON_3MBWQ3XHZMTG,7 Chapter 35 PRD_3AGDT97GE9B0 Ali Zaghlul CON_3MBWQ3XHZMTG 7  

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);