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,026–2,050 of 4,762

card_payment, page 82 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
24031Lyon BellecourFranceHugo Martin44967499122020NULL
24041Lyon BellecourFranceGabriel Moreau5118392272018NULL
240510Chengdu JinjiangChinaJing Yang4806786782022NULL
240610Chengdu JinjiangChinaWei Zhang6243411792019Apple Pay
24076San Francisco Market StUnited StatesLogan Jones3790856722018NULL
240815Roma TerminiItalyGiulia Rossi4966387362018NULL
241014Milano DuomoItalyMatteo Rossi48206299102020NULL
24115Austin DowntownUnited StatesMason Williams4603623462020NULL
241232Stockholm Sergels TorgSwedenLucas Larsson5252396732022NULL
241324Seoul YeouidoSouth KoreaDo-yun Jung5316507372021NULL
241411London Canary WharfUnited KingdomAmelia Williams4316930432022NULL
241535Montréal Ville-MarieCanadaOlivia Gagnon5319578982021NULL
241611Manchester Market StUnited KingdomIsla Patel46534003112021NULL
24178Beijing XidanChinaWei Liu5462385532021Apple Pay
24184Strasbourg KléberFranceGabriel Durand4336832282022NULL
24193Toulouse CapitoleFranceLouis Robert5249540722022NULL
24217Seattle Pike PlaceUnited StatesLiam Wilson5267929512022NULL
24222Marseille CanebièreFranceZoé Laurent4452697972020NULL
242324Busan SeomyeonSouth KoreaMin-jun Cho42427191122022NULL
24242Marseille CanebièreFranceCamille Petit5142320912020NULL
24255Austin DowntownUnited StatesHarper Johnson46015131112021NULL
24267Denver Union StationUnited StatesAva Anderson3756371172018NULL
24274Paris LouvreFranceZoé Leroy52116230112019Apple Pay
242820Rio CentroBrazilMiguel Oliveira4459146122021NULL
242911London Canary WharfUnited KingdomOliver Walker4971951022022Apple 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;