package_item

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

6 rows where package_id = "cler:paket_e_light"

✎ View and edit SQL

This data as json, CSV (advanced)

Link package_id included_product sort_order
cler:paket_e_light,1 Bank Cler Bankpaket E-Light cler:paket_e_light cler:privatkonto 1
cler:paket_e_light,2 Bank Cler Bankpaket E-Light cler:paket_e_light cler:sparkonto_exclusive 2
cler:paket_e_light,3 Bank Cler Bankpaket E-Light cler:paket_e_light cler:vorsorgekonto_3 3
cler:paket_e_light,4 Bank Cler Bankpaket E-Light cler:paket_e_light cler:visa_debit 4
cler:paket_e_light,5 Bank Cler Bankpaket E-Light cler:paket_e_light cler:prepaid_mc_visa 5
cler:paket_e_light,6 Bank Cler Bankpaket E-Light cler:paket_e_light cler:ebanking 6

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);