BookWalker

home / database

product_contributors

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

15 rows where contributor_id = "CON_38KZNCQT4760"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_02E0WNMRGZ2G,CON_38KZNCQT4760,10 Rascal Does Not Dream of His Student PRD_02E0WNMRGZ2G Andrew Grace CON_38KZNCQT4760 10  
PRD_04C7QZSSQ97G,CON_38KZNCQT4760,10 Rascal Does Not Dream of a Dear Friend PRD_04C7QZSSQ97G Andrew Grace CON_38KZNCQT4760 10  
PRD_05YX53YNHT2G,CON_38KZNCQT4760,10 Rascal Does Not Dream of Bunny Girl Senpai PRD_05YX53YNHT2G Andrew Grace CON_38KZNCQT4760 10  
PRD_0DBFSNFS488G,CON_38KZNCQT4760,10 Rascal Does Not Dream of a Sister Venturing Out PRD_0DBFSNFS488G Andrew Grace CON_38KZNCQT4760 10  
PRD_0G4699X00KYG,CON_38KZNCQT4760,10 Rascal Does Not Dream of His Girlfriend PRD_0G4699X00KYG Andrew Grace CON_38KZNCQT4760 10  
PRD_0MTPMWZACJXG,CON_38KZNCQT4760,10 Rascal Does Not Dream of Santa Claus PRD_0MTPMWZACJXG Andrew Grace CON_38KZNCQT4760 10  
PRD_0PP7BDN8XVSG,CON_38KZNCQT4760,10 Rascal Does Not Dream of a Dreaming Girl PRD_0PP7BDN8XVSG Andrew Grace CON_38KZNCQT4760 10  
PRD_0ZSHH2TPMG3G,CON_38KZNCQT4760,10 Rascal Does Not Dream of a Lost Singer PRD_0ZSHH2TPMG3G Andrew Grace CON_38KZNCQT4760 10  
PRD_26YPH4B93DWG,CON_38KZNCQT4760,10 Rascal Does Not Dream of a Sister Home Alone PRD_26YPH4B93DWG Andrew Grace CON_38KZNCQT4760 10  
PRD_27QZPA3TNP9G,CON_38KZNCQT4760,10 Rascal Does Not Dream of Logical Witch PRD_27QZPA3TNP9G Andrew Grace CON_38KZNCQT4760 10  
PRD_2PDE3JC5EJE0,CON_38KZNCQT4760,10 Rascal Does Not Dream of a Nightingale PRD_2PDE3JC5EJE0 Andrew Grace CON_38KZNCQT4760 10  
PRD_2PJ5G0TFDMW0,CON_38KZNCQT4760,10 Rascal Does Not Dream of Petite Devil Kohai PRD_2PJ5G0TFDMW0 Andrew Grace CON_38KZNCQT4760 10  
PRD_2W464E70GGYG,CON_38KZNCQT4760,10 your name. PRD_2W464E70GGYG Andrew Grace CON_38KZNCQT4760 10  
PRD_3W1VD8DYH22G,CON_38KZNCQT4760,10 Rascal Does Not Dream of His First Love PRD_3W1VD8DYH22G Andrew Grace CON_38KZNCQT4760 10  
PRD_3WEA2HY39JG0,CON_38KZNCQT4760,10 Rascal Does Not Dream of Siscon Idol PRD_3WEA2HY39JG0 Andrew Grace CON_38KZNCQT4760 10  

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 10.287ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS