product_external_ids

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

5 rows where product_id = "PRD_1HZDDA68NQEG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source

id ▼ product_id source type external_id external_id_original
CID_3PT6YA2SZRR0 Volume 4 PRD_1HZDDA68NQEG content 1 e40b87a0-6ccf-45bd-85a0-dade2cd2ff5d  
PID_0ESYY8P1NCV0 Volume 4 PRD_1HZDDA68NQEG product 4 04000000B12507800000  
PID_0JW9NT8XF9E0 Volume 4 PRD_1HZDDA68NQEG product 6 KADOKAWA  
PID_1GVNCGAZYEHG Volume 4 PRD_1HZDDA68NQEG product 2 bwg_migration.160785  
PID_24Y0813BGB4G Volume 4 PRD_1HZDDA68NQEG product 7 9781421580548  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE product_external_ids (
      id TEXT PRIMARY KEY,
      product_id TEXT NOT NULL,
      source TEXT NOT NULL,
      type INTEGER NOT NULL,
      external_id TEXT NOT NULL,
      external_id_original TEXT NOT NULL,
      FOREIGN KEY (product_id) REFERENCES products(id)
    );
CREATE INDEX idx_product_external_ids_product ON product_external_ids(product_id);