product_external_ids

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

5 rows where product_id = "PRD_24FN5VR6KF40"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, external_id

id ▼ product_id source type external_id external_id_original
CID_3T991EQPFFT0 Between Duty and Desire PRD_24FN5VR6KF40 content 1 a760e1e4-e538-499c-91b1-06ff70c3c5c2  
PID_1BVB5MY3AY70 Between Duty and Desire PRD_24FN5VR6KF40 product 3 9784596260895  
PID_1ZZP15GWWTA0 Between Duty and Desire PRD_24FN5VR6KF40 product 7 9784596260895  
PID_2XN1VVJSE3XG Between Duty and Desire PRD_24FN5VR6KF40 product 2 bwg_migration.2961632  
PID_31SCQDBN1W0G Between Duty and Desire PRD_24FN5VR6KF40 product 4 59626089C00002942291  

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