home / bankproducts

package_item

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

9 rows where package_id = "jukb:epack_vip"

✎ View and edit SQL

This data as json, CSV (advanced)

Link package_id included_product sort_order
jukb:epack_vip,10 e-PACK VIP jukb:epack_vip jukb:compte_revenu 10
jukb:epack_vip,11 e-PACK VIP jukb:epack_vip jukb:compte_revenu_start 11
jukb:epack_vip,20 e-PACK VIP jukb:epack_vip jukb:compte_epargne 20
jukb:epack_vip,21 e-PACK VIP jukb:epack_vip jukb:compte_epargne_start 21
jukb:epack_vip,22 e-PACK VIP jukb:epack_vip jukb:compte_epargne_bonus 22
jukb:epack_vip,30 e-PACK VIP jukb:epack_vip jukb:debit_mastercard_chf 30
jukb:epack_vip,40 e-PACK VIP jukb:epack_vip jukb:visa_platinum 40
jukb:epack_vip,41 e-PACK VIP jukb:epack_vip jukb:world_mastercard_or 41
jukb:epack_vip,50 e-PACK VIP jukb:epack_vip jukb:ebanking 50

Advanced export

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

CSV options:

CREATE TABLE package_item (
    package_id       TEXT NOT NULL REFERENCES product(id),
    included_product TEXT NOT NULL,
    sort_order       INTEGER DEFAULT 0,
    PRIMARY KEY (package_id, sort_order)
);
CREATE INDEX idx_package_item_package ON package_item(package_id);
Powered by Datasette · Queries took 6.956ms · Data license: CC-BY-4.0 · Data source: bankproducts.info