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 2,576–2,600 of 4,762

card_payment, page 104 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
30208Shanghai PudongChinaTao Li4829526752020NULL
302131Warszawa ŚródmieściePolandZuzanna Kowalczyk40230044112022NULL
302234Tampere HämeenkatuFinlandAino Korhonen4595646862020Apple Pay
30234Strasbourg KléberFranceJules Dubois4479022252020NULL
302422Tokyo MarunouchiJapanYui Ito3581301532021NULL
30252Marseille CanebièreFranceLouis Durand5137151752020NULL
302618Frankfurt TaunusanlageGermanyLea Hoffmann4276874392022NULL
302723Kyoto ShijoJapanAoi Sato3599491052020NULL
30284Paris LouvreFranceLouis Dubois4820105012020Google Pay
30291Lyon BellecourFranceLouis Dubois49059316102022NULL
303013Edinburgh Princes StUnited KingdomAva Jones40922692122019NULL
303112Birmingham New StUnited KingdomLily Williams3712520332022NULL
303212Leeds BriggateUnited KingdomFreddie Taylor5281010632022NULL
303325Incheon SongdoSouth KoreaSu-ah Jung5524068392023NULL
303431Kraków RynekPolandAntoni Nowak4378625182019NULL
30361Nantes CommerceFranceChloé Martin48154775112023NULL
30371Lyon BellecourFranceZoé Moreau5565715672019NULL
303830Moscow TverskayaRussiaAnna Sokolov54896670112019NULL
303910Chengdu JinjiangChinaLei Liu54548534112019NULL
30407Seattle Pike PlaceUnited StatesEmma Williams3765133612023NULL
30412Lille Grand PlaceFranceJules Robert53040598112023NULL
304213Edinburgh Princes StUnited KingdomAva Davies5501962632020NULL
304323Kyoto ShijoJapanSakura Yamamoto4711242842021NULL
30442Lille Grand PlaceFranceArthur Simon4479893292021NULL
304523Kyoto ShijoJapanSakura Yamamoto35850320102019NULL
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;