package_item

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

5 rows where package_id = "vskb:conto_jeunes"

✎ View and edit SQL

This data as json, CSV (advanced)

Link package_id included_product sort_order
vskb:conto_jeunes,1 BCVS Conto Pack Jeunes vskb:conto_jeunes 1 compte prive inclus 1
vskb:conto_jeunes,2 BCVS Conto Pack Jeunes vskb:conto_jeunes 1 carte incluse 2
vskb:conto_jeunes,3 BCVS Conto Pack Jeunes vskb:conto_jeunes 50% rabais carte de credit argent 3
vskb:conto_jeunes,4 BCVS Conto Pack Jeunes vskb:conto_jeunes 1 carte Prepaid incluse 4
vskb:conto_jeunes,5 BCVS Conto Pack Jeunes vskb:conto_jeunes Online & Mobile banking inclus 5

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