product_external_ids
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
5 rows where product_id = "PRD_39SAQ4CKBX6G"
This data as json, CSV (advanced)
Suggested facets: source
| id ▼ | product_id | source | type | external_id | external_id_original |
|---|---|---|---|---|---|
| CID_3Z572P2BFKAG | Chapter 4 PRD_39SAQ4CKBX6G | content | 1 | dad2a07c-1d55-4a6b-bd15-8abdadcfc9c0 | |
| PID_0B1ED8KQJP6G | Chapter 4 PRD_39SAQ4CKBX6G | product | 4 | 04000000C00001474620 | |
| PID_0Z5S8T434JDG | Chapter 4 PRD_39SAQ4CKBX6G | product | 6 | TID01068 | |
| PID_1X353G6DQVX0 | Chapter 4 PRD_39SAQ4CKBX6G | product | 2 | bwg_migration.1275657 | |
| PID_217QZ1RS9M00 | Chapter 4 PRD_39SAQ4CKBX6G | product | 7 | TID01068_EN_C1_004 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);