product_feature

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

1 row where product_id = "ce_nyon:titres"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ product_id feature_key feature_value note source_page
ce_nyon:titres:pf:obligations_caisse_no_custody Compte Titres ce_nyon:titres pricing_condition Obligations de Caisse CEN and cédules hypothécaires: NO custody fees, NO brokerage Verbatim: "Aucun courtage ni droits de garde ne sont appliqués pour la gestion des obligations de caisse CEN et/ou de vos cédules hypothécaires". CEN waives both courtage AND droits de garde on its own bonds and on customers' mortgage documents (cédules hypothécaires). Strong incentive to hold CEN bonds and to manage CEN-financed mortgages through CEN custody. Common Swiss small-Sparkasse practice but explicitly published here.  

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