bank_profile

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

0 rows where bank_id = "dcbank"

✎ View and edit SQL

This data as json

0 records

CREATE TABLE bank_profile (
    bank_id                    TEXT PRIMARY KEY REFERENCES bank(id),
    -- continuity / identity
    operational_since          INTEGER,        -- year continuous operations began (NOT year_founded/Zefix)
    too_big_to_fail            INTEGER DEFAULT 0,  -- 1 if FINMA TBTF designation (category 1 or 2)
    staatsgarantie             TEXT,           -- 'full', 'limited', or NULL
    parent_group_relation      TEXT,           -- 'network_member', 'subsidiary', or NULL
    finma_category             INTEGER,        -- 1-5 (FINMA supervisory category)
    -- currency exposure
    offers_usd_accounts        INTEGER,
    offers_eur_accounts        INTEGER,
    offers_gbp_accounts        INTEGER,
    -- client access
    retail_clients             INTEGER,
    institutional_only         INTEGER
);
CREATE INDEX idx_bank_profile_finma ON bank_profile(finma_category);