bpg_alias

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

3,995 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: valid_from, valid_from (date), created_at (date)

Next page

CREATE TABLE bpg_alias (
    id          INTEGER PRIMARY KEY,
    bpg         CHAR(12) NOT NULL,
    slug        TEXT NOT NULL,         -- e.g. ch/zkb, ch/zkb/privatkonto
    valid_from  DATE NOT NULL DEFAULT CURRENT_DATE,
    valid_to    DATE,                  -- NULL = currently active
    created_at  TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    UNIQUE (slug, valid_from),
    CHECK (valid_to IS NULL OR valid_to >= valid_from)
);
CREATE INDEX idx_bpg_alias_bpg ON bpg_alias(bpg);
CREATE INDEX idx_bpg_alias_slug_active ON bpg_alias(slug) WHERE valid_to IS NULL;