product_external_ids

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

5 rows where product_id = "PRD_3SN35SNCSHCG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source

id ▼ product_id source type external_id external_id_original
CID_2G42GYF8858G Chapter 3 PRD_3SN35SNCSHCG content 1 f91776dc-f367-418d-9754-0a80e626c333  
PID_1CPGV1F5G130 Chapter 3 PRD_3SN35SNCSHCG product 4 04000000C00001174610  
PID_1GN3PJ1HBXP0 Chapter 3 PRD_3SN35SNCSHCG product 6 3315-614911-01  
PID_2PGF983KN2SG Chapter 3 PRD_3SN35SNCSHCG product 2 bwg_migration.933449  
PID_3TMT4SMFCZCG Chapter 3 PRD_3SN35SNCSHCG product 7 4000363  

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