Skip to content
Louvre Ops DB

Table

card_payment

Card and wallet details: first and last four digits, expiry month and year, issuing branch.

Replaces in 2020: EFTPOS

Download CSV Query in playground

Rows 3,651–3,675 of 4,762

card_payment, page 147 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
421410Hangzhou XihuChinaMin Sun4128939222021NULL
421511Manchester Market StUnited KingdomAva Walker3768221882020Apple Pay
421632Stockholm Sergels TorgSwedenElsa Larsson45833250102022NULL
42176Boston Back BayUnited StatesMason Miller41933757112023NULL
421832Göteborg AvenynSwedenOscar Eriksson4511879682020NULL
42191Paris OpéraFranceManon Leroy5546869982020NULL
422030Moscow TverskayaRussiaAnna Vasiliev4535324362020NULL
42211Nantes CommerceFranceArthur Petit4533199492021NULL
42224Paris LouvreFranceInès Thomas5224227482023NULL
42231Nantes CommerceFranceChloé Laurent5519971482020NULL
42243Rennes RépubliqueFranceJules Martin4427176782022NULL
422519München MarienplatzGermanyFinn Fischer5189314322021NULL
42262Marseille CanebièreFranceZoé Simon4045013792023Apple Pay
422734Tampere HämeenkatuFinlandOliver Nieminen4535468162022NULL
422834Tampere HämeenkatuFinlandOliver Nieminen5113570872021Apple Pay
423016Sevilla TrianaSpainPablo Martín4304399842024NULL
423122Tokyo MarunouchiJapanRen Watanabe35329042112024NULL
42327Seattle Pike PlaceUnited StatesLiam Johnson4363188922020Google Pay
42335Manhattan MidtownUnited StatesLiam Johnson37775040122024NULL
42345Chicago LoopUnited StatesLiam Miller4309873322021Google Pay
42357Denver Union StationUnited StatesAva Miller3756891772020NULL
423620Rio CentroBrazilValentina Ferreira5100956322024NULL
42373Rennes RépubliqueFranceCamille Robert4732611012024NULL
423828Amsterdam ZuidasNetherlandsTess Meijer46742355122024NULL
42392Lille Grand PlaceFranceGabriel Laurent4749577272020Google Pay
Table definition
CREATE TABLE card_payment (
  payment_id     INTEGER PRIMARY KEY REFERENCES payment (payment_id),
  institution_id INTEGER NOT NULL REFERENCES financial_institution (institution_id),
  issuing_branch TEXT NOT NULL,
  issued_country TEXT NOT NULL,
  account_name   TEXT NOT NULL,
  card_first4    TEXT NOT NULL CHECK (length(card_first4) = 4 AND card_first4 NOT GLOB '*[^0-9]*'),
  card_last4     TEXT NOT NULL CHECK (length(card_last4) = 4 AND card_last4 NOT GLOB '*[^0-9]*'),
  expiry_month   INTEGER NOT NULL CHECK (expiry_month BETWEEN 1 AND 12),
  expiry_year    INTEGER NOT NULL CHECK (expiry_year BETWEEN 2000 AND 2099),
  wallet         TEXT CHECK (wallet IN ('Apple Pay', 'Google Pay'))
) STRICT;