partner

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

11 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: partner_type

id ▼ name sponsor partner_type website note bpg
cornercard Cornèrcard Cornèr Bank AG card_issuer https://www.cornercard.ch Card brand of Cornèr Bank AG. First Swiss Visa issuer (1975). Issues Classic/Gold/Prepaid cards both for own brand and as white-label issuer for other Swiss banks. BPG0062VZ840
cumulus Cumulus Migros Genossenschaftsbund loyalty_program https://www.migros.ch/cumulus Migros retail loyalty program. Cumulus-Mastercard co-branded with Cembra Money Bank. BPG006ZZN3NV
fnac Fnac Schweiz Fnac Darty loyalty_program https://www.fnac.ch Fnac entertainment/media retailer. Fnac Mastercard co-branded with Cembra Money Bank. BPG0069DYBSC
ikea IKEA Schweiz IKEA loyalty_program https://www.ikea.com/ch/de/ IKEA Family loyalty program — IKEA Mastercard co-branded with Cembra Money Bank. BPG006XV29ZK
lipo Lipo   loyalty_program https://www.lipo.ch Swiss home furnishings retailer. Lipo Mastercard co-branded with Cembra Money Bank. BPG006FNNY32
miles_more Miles & More Lufthansa Group loyalty_program https://www.miles-and-more.com Lufthansa frequent-flyer program. Co-branded with Cornèr Bank Cornèrcard Miles & More Classic and Gold cards. BPG006M1VZAB
swiss_bankers Swiss Bankers AG   card_issuer https://www.swissbankers.ch Swiss prepaid card and travel-money specialist. Issues Life Prepaid MasterCard and Travel Cards for many Swiss banks. BPG0065CGB95
swisscard Swisscard AECS GmbH UBS Group AG + American Express card_issuer https://www.swisscard.ch Joint venture between UBS Group AG and American Express. Issues UBS-branded credit cards and the key4 line. BPG006T4ZPC2
tcs Touring Club Schweiz   mobility_program https://www.tcs.ch Swiss automobile and mobility association. TCS Mastercard co-branded with Cembra Money Bank. BPG006JFE9KT
viseca Viseca Card Services AG   card_issuer https://www.viseca.ch Swiss card processor. Issues credit cards for many Swiss banks; runs the Surprize Bonusprogramm. Spun out of Aduno Group; now a Cembra subsidiary (2024). BPG006FF14HS
zaehringer Zaehringer Privatbank   wealth_manager https://www.zaehringer.ch Swiss private bank providing white-label wealth-management mandates (Zaehringer-Methode) to smaller regional banks. Bernerland Bank packages Anlageberatung + Vermoegensverwaltung through this partnership. BPG006KHA40K

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE partner (
    id           TEXT PRIMARY KEY,        -- short lowercase slug: viseca, cornercard, cumulus, miles_more
    name         TEXT NOT NULL,           -- "Viseca Card Services AG", "Lufthansa Miles & More"
    sponsor      TEXT,                    -- parent/sponsoring org if distinct: "Migros Genossenschaftsbund"
    partner_type TEXT NOT NULL,           -- card_issuer, loyalty_program, wealth_manager, mobility_program
    website      TEXT,
    note         TEXT,
    bpg          CHAR(12)                 -- opaque global id, BPG006xxxxxx; populated post-load by bpg_assignments.sql
        CHECK (bpg IS NULL OR bpg GLOB 'BPG006[0-9A-HJKMNP-TV-Z][0-9A-HJKMNP-TV-Z][0-9A-HJKMNP-TV-Z][0-9A-HJKMNP-TV-Z][0-9A-HJKMNP-TV-Z][0-9A-HJKMNP-TV-Z]')
);
CREATE INDEX idx_partner_type ON partner(partner_type);
CREATE UNIQUE INDEX idx_partner_bpg ON partner(bpg) WHERE bpg IS NOT NULL;