product_feature

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

1 row where product_id = "vpbank:sensa"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ product_id feature_key feature_value note source_page
vpbank:sensa:fokusmaerkte VP Sensa vpbank:sensa focus_markets LI, CH, LU, SG, BVI, DE, DK, EE, LV, LT, NO, AT, PT, SE, ES, UA, CY, CN, HK, ID, MY, TW, TH, AE Domizil ausserhalb Fokusmaerkte loest Zusatzgebuehr CHF 150/Monat aus  

Advanced export

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

CSV options: 

CREATE TABLE product_feature (
    id          TEXT PRIMARY KEY,
    product_id  TEXT NOT NULL REFERENCES product(id),
    feature_key TEXT NOT NULL,          -- withdrawal_limit_free, notice_period, daily_limit, monthly_limit,
                                        -- interest_late_payment, max_balance, included_services, ...
    feature_value TEXT,
    note        TEXT,
    source_page INTEGER
);
CREATE INDEX idx_product_feature_product ON product_feature(product_id);
CREATE INDEX idx_product_feature_key ON product_feature(feature_key);