product_partner_link

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

5 rows where partner_id = "swisscard"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id partner_id role note valid_from
ubs:credit_classic,swisscard,issuer UBS Classic/Standard ubs:credit_classic Swisscard AECS GmbH swisscard issuer    
ubs:credit_gold,swisscard,issuer UBS Gold ubs:credit_gold Swisscard AECS GmbH swisscard issuer    
ubs:credit_platinum,swisscard,issuer UBS Platinum ubs:credit_platinum Swisscard AECS GmbH swisscard issuer    
ubs:key4_premium,swisscard,issuer UBS key4 premium ubs:key4_premium Swisscard AECS GmbH swisscard issuer    
ubs:key4_standard,swisscard,issuer UBS key4 standard ubs:key4_standard Swisscard AECS GmbH swisscard issuer    

Advanced export

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

CSV options: 

CREATE TABLE product_partner_link (
    product_id    TEXT NOT NULL REFERENCES product(id),
    partner_id    TEXT NOT NULL REFERENCES partner(id),
    role          TEXT NOT NULL,          -- issuer, co_brand, reward_program, white_label_advisor
    note          TEXT,
    valid_from    TEXT,                   -- YYYY-MM-DD when the relationship started; NULL = always
    PRIMARY KEY (product_id, partner_id, role)
);
CREATE INDEX idx_ppl_partner ON product_partner_link(partner_id);
CREATE INDEX idx_ppl_role    ON product_partner_link(role);