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,626–4,650 of 4,762

card_payment, page 186 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
526228Amsterdam ZuidasNetherlandsDaan Smit5137216132021Apple Pay
526314Milano DuomoItalyGiulia Greco4214224752023Apple Pay
52642Paris La DéfenseFranceArthur Martin46198192102022NULL
52662Paris La DéfenseFranceManon Dubois42234418102024Google Pay
526735Montréal Ville-MarieCanadaEmma Tremblay5160116572024NULL
52693Toulouse CapitoleFranceHugo Simon5502292832023NULL
527014Milano DuomoItalyGiulia Greco4256090052023Google Pay
527115Roma TerminiItalyGiulia Greco46969723112024NULL
527226WoolloomoolooAustraliaWilliam Brown43817966122021NULL
527332Stockholm Sergels TorgSwedenMaja Andersson4262498842025NULL
52748Shanghai PudongChinaXin Zhou6273805322025NULL
52757Seattle Pike PlaceUnited StatesHarper Johnson52580841122021Google Pay
52762Lille Grand PlaceFranceHugo Petit5191535912025Apple Pay
52773Rennes RépubliqueFranceArthur Martin4959379972022NULL
52781Nantes CommerceFranceLéa Leroy5315428932021NULL
527917Bilbao AbandoSpainSofía González4976116352025Apple Pay
528035Toronto Bay StCanadaNoah Gagnon4420275052023NULL
528212Leeds BriggateUnited KingdomIsla Patel4100871312021NULL
528335Montréal Ville-MarieCanadaEmma Roy47785259112023NULL
52844Strasbourg KléberFranceGabriel Robert51767358112022NULL
528533Bergen BryggenNorwayJakob Nilsen4862089922021NULL
528610Chengdu JinjiangChinaMin Wu52127471112021NULL
52877Seattle Pike PlaceUnited StatesElla Jones49117055122024NULL
52881Nantes CommerceFranceLéa Bernard5296825452025NULL
528911London Canary WharfUnited KingdomHarry Smith5322204982022NULL
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;