product_feature

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

4 rows where product_id = "vz:visa_gold"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ product_id feature_key feature_value note source_page
vz:visa_gold:insurance VZ Kreditkarte Visa Gold vz:visa_gold insurance_bundle Travel + Cards + Medical: cancellation CHF 20k, interruption CHF 15k, medical assistance CHF 250k, transport CHF 500k, rescue CHF 60k, baggage delay CHF 1k, baggage CHF 5k, CDW CHF 10k, warranty ext CHF 5k (24mo), purchase CHF 2k, best-price CHF 2k, ticket CHF 1k, online account CHF 5k, online legal CHF 5k Erweiterte kostenlose Versicherungsleistungen vs Classic; inklusive Mietwagen-Selbstbehalt (CDW), Such-/Rettungskosten, Priority Pass Mitgliedschaft, 15% Hertz-Rabatt 1
vz:visa_gold:limit VZ Kreditkarte Visa Gold vz:visa_gold card_limit CHF 5000 - 20000 Mindestlimite CHF 5000, Hoechstlimite CHF 20000 1
vz:visa_gold:no_account_link VZ Kreditkarte Visa Gold vz:visa_gold pricing_condition Keine direkte Kontoanbindung erforderlich Im Unterschied zu Debit Mastercard: keine Kopplung an VZ-Konto noetig. 1
vz:visa_gold:surprize VZ Kreditkarte Visa Gold vz:visa_gold loyalty_program Surprize: 20000 Willkommen + 1.5 Punkte/CHF Bonusprogramm surprize: einmalig 20000 Punkte Welcome, dann 1.5 Surprize-Punkte pro CHF Einkaufswert 1

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