product_contributors

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

12 rows where contributor_id = "CON_08EJ7GZ8TFH0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0AR7VTXTDVA0,CON_08EJ7GZ8TFH0,2 Loving Rescue PRD_0AR7VTXTDVA0 Fusako Wazumi CON_08EJ7GZ8TFH0 2  
PRD_0FHXWQ48MW70,CON_08EJ7GZ8TFH0,2 The Big Bad Boss PRD_0FHXWQ48MW70 Fusako Wazumi CON_08EJ7GZ8TFH0 2  
PRD_14SSAXNJJ340,CON_08EJ7GZ8TFH0,2 Their Engagement Is Announced PRD_14SSAXNJJ340 Fusako Wazumi CON_08EJ7GZ8TFH0 2  
PRD_1BRJNKPA4BH0,CON_08EJ7GZ8TFH0,2 The Italian's Passionate Proposal PRD_1BRJNKPA4BH0 Fusako Wazumi CON_08EJ7GZ8TFH0 2  
PRD_1D4D2B4M9Z3G,CON_08EJ7GZ8TFH0,2 Invitation to the Boss's Ball PRD_1D4D2B4M9Z3G Fusako Wazumi CON_08EJ7GZ8TFH0 2  
PRD_1SPG27YHMED0,CON_08EJ7GZ8TFH0,2 The Italian Doctor's Wife PRD_1SPG27YHMED0 Fusako Wazumi CON_08EJ7GZ8TFH0 2  
PRD_2C86AR06F2DG,CON_08EJ7GZ8TFH0,2 The Greek Tycoon's Unexpected Wife PRD_2C86AR06F2DG Fusako Wazumi CON_08EJ7GZ8TFH0 2  
PRD_2Z0QXN5B61Z0,CON_08EJ7GZ8TFH0,2 Jungle Fever PRD_2Z0QXN5B61Z0 Fusako Wazumi CON_08EJ7GZ8TFH0 2  
PRD_3CE71YKPYS0G,CON_08EJ7GZ8TFH0,2 Dr Ferrero's Baby Secret PRD_3CE71YKPYS0G Fusako Wazumi CON_08EJ7GZ8TFH0 2  
PRD_3SNE92YEH8Z0,CON_08EJ7GZ8TFH0,2 The American Earl PRD_3SNE92YEH8Z0 Fusako Wazumi CON_08EJ7GZ8TFH0 2  
PRD_3VKCHFZ7D74G,CON_08EJ7GZ8TFH0,2 Wedding at White Sands PRD_3VKCHFZ7D74G Fusako Wazumi CON_08EJ7GZ8TFH0 2  
PRD_3ZZRMG9PJEWG,CON_08EJ7GZ8TFH0,2 The Carides Pregnancy PRD_3ZZRMG9PJEWG Fusako Wazumi CON_08EJ7GZ8TFH0 2  

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