product_feature

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

3 rows where product_id = "hbl:privatkonto"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ product_id feature_key feature_value note source_page
hbl:privatkonto:pf:cancellation_30day Privatkonto hbl:privatkonto pricing_condition Cancellation lapses if amount not withdrawn within 30 days of notice expiry Wird ein gekuendigter Betrag nicht innerhalb von 30 Tagen seit Ablauf der Kuendigungsfrist bezogen, faellt die Kuendigung dahin 3
hbl:privatkonto:pf:foreign_fees_passed Privatkonto hbl:privatkonto pricing_condition All foreign bank fees passed through Alle fremden Bankspesen werden vollumfaenglich weiterbelastet; exotische Waehrungen auf Anfrage 13
hbl:privatkonto:pf:savings_payment_surcharge Privatkonto hbl:privatkonto pricing_condition CHF 5 surcharge per payment from Sparkonto / Beratungsmandatskonto Zahlungen ab Sparkonto und Beratungsmandatskonto: CHF 5 Zuschlag 12

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