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 4,001–4,025 of 4,762

card_payment, page 161 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
458213Bristol Corn StUnited KingdomLily Evans4102323182023Google Pay
458325Incheon SongdoSouth KoreaMin-jun Kang5545242372021NULL
458425Seoul GangnamSouth KoreaYe-jun Choi5194665722021NULL
458525Incheon SongdoSouth KoreaJi-woo Choi4399644842024NULL
458635Montréal Ville-MarieCanadaLiam Tremblay5438263832023NULL
458715Firenze Santa Maria NovellaItalySofia Esposito4954771382021Google Pay
458815Firenze Santa Maria NovellaItalySofia Esposito48877994122022NULL
458915Firenze Santa Maria NovellaItalySofia Esposito5290313352022Google Pay
459014Milano DuomoItalyLorenzo Russo53209032102023Google Pay
45913Bordeaux ChartronsFranceLucas Lefebvre45367103122021NULL
45924Paris LouvreFranceChloé Petit4940703052020NULL
459313Bristol Corn StUnited KingdomAlfie Jones5374507082021NULL
459427Sydney Martin PlaceAustraliaRuby Smith4023851952022NULL
459519Hamburg JungfernstiegGermanyFinn Fischer4413081492021NULL
45966Boston Back BayUnited StatesElla Miller5103435122021NULL
45975Chicago LoopUnited StatesMason Garcia4001408872022Apple Pay
45986San Francisco Market StUnited StatesEmma Jones4922233712023NULL
45993Toulouse CapitoleFranceLucas Martin5302650782021Apple Pay
460013Edinburgh Princes StUnited KingdomJack Jones4593976082023NULL
460132Stockholm Sergels TorgSwedenAlice Eriksson48820547122024Apple Pay
46023Toulouse CapitoleFranceGabriel Durand5443475652022NULL
46031Paris OpéraFranceZoé Durand54066873112023NULL
460430Saint Petersburg NevskyRussiaMikhail Kuznetsov4239769242021NULL
460535Toronto Bay StCanadaOlivia Martin4867433962022NULL
460630Moscow TverskayaRussiaMikhail Kuznetsov4459871962024Apple 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;