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 1,501–1,525 of 4,762

card_payment, page 61 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
179113Edinburgh Princes StUnited KingdomAva Smith41453827122017NULL
179218Frankfurt TaunusanlageGermanyLea Becker4402298772021NULL
17931Nantes CommerceFranceCamille Laurent4758261382020NULL
17944Strasbourg KléberFranceLucas Martin4580312172019NULL
17952Lille Grand PlaceFranceManon Martin40269948112019NULL
179629Eindhoven StratumseindNetherlandsDaan de Jong4117542082020NULL
17971Paris OpéraFranceArthur Durand5206824562021NULL
17985Austin DowntownUnited StatesEthan Taylor5599469772020NULL
179927Brisbane Queen StAustraliaIsla Taylor5327669842020NULL
18009Guangzhou TianheChinaFang Liu4392570912018NULL
180127Sydney Martin PlaceAustraliaJack Smith4130992262017NULL
18058Shanghai PudongChinaJun Wu4578782762021NULL
18069Guangzhou TianheChinaYan Liu4909929282021NULL
180728Amsterdam ZuidasNetherlandsSophie Bakker5141344252020NULL
180828Rotterdam CoolsingelNetherlandsJulia Meijer5462953532017Google Pay
18096Boston Back BayUnited StatesEthan Wilson4048507552017NULL
18113Toulouse CapitoleFranceGabriel Thomas4864887542021Google Pay
18122Paris La DéfenseFranceZoé Moreau5453879672017NULL
181519München MarienplatzGermanyEmma Becker5475759422017NULL
18165Chicago LoopUnited StatesEthan Taylor4216329652020NULL
181810Hangzhou XihuChinaYan Wang62378952122020NULL
18197Seattle Pike PlaceUnited StatesEmma Smith3788975382021NULL
182113Edinburgh Princes StUnited KingdomJack Evans5177977212017NULL
18227Seattle Pike PlaceUnited StatesJames Williams46780348112019NULL
18232Lille Grand PlaceFranceZoé Bernard4426384572020NULL
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;