product_alias

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

2 rows where product_id = "swissbankers:life"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id alias alias_source
swissbankers:life,life-cash-card Swiss Bankers Life swissbankers:life life-cash-card  
swissbankers:life,swiss-bankers-life Swiss Bankers Life swissbankers:life swiss-bankers-life  

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