product_external_ids

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

5 rows where product_id = "PRD_27803A8H2PGG"

✎ 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_119QZG3RFSR0 My Darling is a Foreign Crybaby PRD_27803A8H2PGG content 1 dd75b983-cd3f-4d1c-9708-7ff90dee6540  
PID_00KY9XKTF30G My Darling is a Foreign Crybaby PRD_27803A8H2PGG product 3 9784801968950  
PID_0MP95F4P6ZQG My Darling is a Foreign Crybaby PRD_27803A8H2PGG product 7 9784801968950  
PID_2ADMW56GG570 My Darling is a Foreign Crybaby PRD_27803A8H2PGG product 2 bwg_migration.1888798  
PID_2YG7VPZCA1A0 My Darling is a Foreign Crybaby PRD_27803A8H2PGG product 4 88475000X02078800000  

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