product_feature

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

16 rows where product_id = "frankly:3a_invest"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: feature_key

id ▼ product_id feature_key feature_value note source_page
frankly:3a_invest:licensed_under frankly 3a — Wertschriftenloesung frankly:3a_invest licensed_under_bank_id zkb Traegerstiftung: Vorsorgestiftung Sparen 3 der Zuercher Kantonalbank (UID CHE-109.546.978), Bahnhofstrasse 9, 8010 Zuerich.  
frankly:3a_invest:strategy_extreme_95_index frankly 3a — Wertschriftenloesung frankly:3a_invest strategy extreme_95_index Aktienanteil ~95%, passiv.  
frankly:3a_invest:strategy_extreme_95_responsible frankly 3a — Wertschriftenloesung frankly:3a_invest strategy extreme_95_responsible Aktienanteil ~95%, ESG-Standard. Aktiv.  
frankly:3a_invest:strategy_extreme_95_sustainable frankly 3a — Wertschriftenloesung frankly:3a_invest strategy extreme_95_sustainable Aktienanteil ~95%, ESG-strikt. Aktiv.  
frankly:3a_invest:strategy_gentle_25_index frankly 3a — Wertschriftenloesung frankly:3a_invest strategy gentle_25_index Aktienanteil ~25%, passiv indexbasiert.  
frankly:3a_invest:strategy_gentle_25_responsible frankly 3a — Wertschriftenloesung frankly:3a_invest strategy gentle_25_responsible Aktienanteil ~25%, ESG-Standard. Aktiv.  
frankly:3a_invest:strategy_gentle_25_sustainable frankly 3a — Wertschriftenloesung frankly:3a_invest strategy gentle_25_sustainable Aktienanteil ~25%, ESG-strikt. Aktiv.  
frankly:3a_invest:strategy_light_15_index frankly 3a — Wertschriftenloesung frankly:3a_invest strategy light_15_index Aktienanteil ~15%, indexbasiert. Passiv.  
frankly:3a_invest:strategy_light_15_responsible frankly 3a — Wertschriftenloesung frankly:3a_invest strategy light_15_responsible Aktienanteil ~15%, ESG-Standard (Responsible). Aktiv verwaltet.  
frankly:3a_invest:strategy_light_15_sustainable frankly 3a — Wertschriftenloesung frankly:3a_invest strategy light_15_sustainable Aktienanteil ~15%, ESG-strikt (Sustainable-Standard). Aktiv verwaltet.  
frankly:3a_invest:strategy_moderate_45_index frankly 3a — Wertschriftenloesung frankly:3a_invest strategy moderate_45_index Aktienanteil ~45%, passiv.  
frankly:3a_invest:strategy_moderate_45_responsible frankly 3a — Wertschriftenloesung frankly:3a_invest strategy moderate_45_responsible Aktienanteil ~45%, ESG-Standard. Aktiv.  
frankly:3a_invest:strategy_moderate_45_sustainable frankly 3a — Wertschriftenloesung frankly:3a_invest strategy moderate_45_sustainable Aktienanteil ~45%, ESG-strikt. Aktiv.  
frankly:3a_invest:strategy_strong_75_index frankly 3a — Wertschriftenloesung frankly:3a_invest strategy strong_75_index Aktienanteil ~75%, passiv.  
frankly:3a_invest:strategy_strong_75_responsible frankly 3a — Wertschriftenloesung frankly:3a_invest strategy strong_75_responsible Aktienanteil ~75%, ESG-Standard. Aktiv.  
frankly:3a_invest:strategy_strong_75_sustainable frankly 3a — Wertschriftenloesung frankly:3a_invest strategy strong_75_sustainable Aktienanteil ~75%, ESG-strikt. Aktiv.  

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