product_alias

Data license: CC-BY-4.0 · Data source: bankproducts.info

2 rows where product_id = "zkb:firmenkonto"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id alias alias_source
zkb:firmenkonto,Firmenkonto ZKB Firmenkonto zkb:firmenkonto Firmenkonto blink_ais
zkb:firmenkonto,Firmenkonto CHF ZKB Firmenkonto zkb:firmenkonto Firmenkonto CHF blink_ais

Advanced export

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

CSV options: 

CREATE TABLE product_alias (
    product_id   TEXT NOT NULL REFERENCES product(id),
    alias        TEXT NOT NULL,
    alias_source TEXT,                  -- 'blink_ais', 'ebanking', 'pdf'
    PRIMARY KEY (product_id, alias)
);
CREATE INDEX idx_product_alias_alias ON product_alias(alias);