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,451–2,475 of 4,762

card_payment, page 99 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
288716Sevilla TrianaSpainPablo Rodríguez4942496572022NULL
288827Sydney Martin PlaceAustraliaNoah Ryan4750397762022NULL
288928Rotterdam CoolsingelNetherlandsEmma Smit4425283462023NULL
289022Tokyo MarunouchiJapanYuto Tanaka3569865182020NULL
289118Frankfurt TaunusanlageGermanyLeon Koch51270951122019NULL
289229Utrecht CentrumNetherlandsTess de Jong5288565582021Apple Pay
289329Utrecht CentrumNetherlandsDaan de Vries5158768162021NULL
289432Göteborg AvenynSwedenAlice Persson5308173892021NULL
28954Paris LouvreFranceLucas Simon4207691242021NULL
28964Paris LouvreFranceGabriel Durand5267252762023NULL
28973Toulouse CapitoleFranceArthur Durand5332880122023NULL
28985Austin DowntownUnited StatesMason Wilson4183875482020NULL
28993Bordeaux ChartronsFranceLéa Leroy5543115552021NULL
29003Rennes RépubliqueFranceHugo Robert5399847892021NULL
290130Moscow TverskayaRussiaAnastasia Morozov44267382112022NULL
29036Boston Back BayUnited StatesHarper Davis37280382102020NULL
290514Milano DuomoItalyLeonardo Ferrari5538159832019Apple Pay
29066Boston Back BayUnited StatesLogan Wilson5444168882023Google Pay
29076San Francisco Market StUnited StatesLogan Davis5480958672021NULL
290830Saint Petersburg NevskyRussiaDmitry Sokolov5127574272021NULL
29095Chicago LoopUnited StatesHarper Smith5157344122020NULL
29103Toulouse CapitoleFranceInès Moreau4914840052021NULL
29115Austin DowntownUnited StatesAva Brown43172927122022NULL
291229Eindhoven StratumseindNetherlandsSophie Visser4057375112021NULL
291322Osaka UmedaJapanSakura Takahashi51194442102021NULL
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;