home / bankproducts

package_item

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

7 rows where package_id = "wir:wir_kmu_paket"

✎ View and edit SQL

This data as json, CSV (advanced)

Link package_id included_product sort_order
wir:wir_kmu_paket,1 WIR-KMU-Paket wir:wir_kmu_paket wir:wir_konto 1
wir:wir_kmu_paket,2 WIR-KMU-Paket wir:wir_kmu_paket wir:chf_konto_kmu 2
wir:wir_kmu_paket,3 WIR-KMU-Paket wir:wir_kmu_paket wir:wir_chf_privat 3
wir:wir_kmu_paket,4 WIR-KMU-Paket wir:wir_kmu_paket wir:wircard 4
wir:wir_kmu_paket,5 WIR-KMU-Paket wir:wir_kmu_paket wir:debit_mc_wircard_plus 5
wir:wir_kmu_paket,6 WIR-KMU-Paket wir:wir_kmu_paket wir:ebanking 6
wir:wir_kmu_paket,7 WIR-KMU-Paket wir:wir_kmu_paket wir:sofortkredit_wir 7

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 9.797ms · Data license: CC-BY-4.0 · Data source: bankproducts.info