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,426–2,450 of 4,762

card_payment, page 98 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
285931Kraków RynekPolandZuzanna Nowak5463099192019NULL
286033Bergen BryggenNorwayElla Hansen4816487092022NULL
28614Paris LouvreFranceChloé Dubois46096669102019NULL
286230Saint Petersburg NevskyRussiaAnastasia Ivanov4794339362023Google Pay
28646San Francisco Market StUnited StatesHarper Davis5212383272020NULL
28656Boston Back BayUnited StatesLiam Smith5314235212021NULL
286612Leeds BriggateUnited KingdomIsla Taylor4136473782021NULL
28686Atlanta MidtownUnited StatesHarper Williams3791979162023NULL
286928Amsterdam ZuidasNetherlandsSophie Smit41161925122020NULL
28705Chicago LoopUnited StatesJames Moore5334404662021Google Pay
287119Hamburg JungfernstiegGermanyBen Weber49285503122019NULL
287227Sydney Martin PlaceAustraliaMia Williams4181566522020NULL
287318Frankfurt TaunusanlageGermanyBen Fischer4864305932021NULL
287415Firenze Santa Maria NovellaItalyLeonardo Rossi4730149292022NULL
287531Warszawa ŚródmieściePolandMaja Kowalczyk4072450012019NULL
287622Osaka UmedaJapanAoi Takahashi5565106452019NULL
287711London Canary WharfUnited KingdomAva Evans5176840752019NULL
287816Madrid Gran VíaSpainLucía Sánchez4704884522021NULL
287934Tampere HämeenkatuFinlandOliver Hämäläinen4973427652019NULL
288035Toronto Bay StCanadaWilliam Tremblay4246209152023NULL
288218Frankfurt TaunusanlageGermanyElias Becker4086348392020NULL
288310Hangzhou XihuChinaYang Yang6283680122020NULL
288412Leeds BriggateUnited KingdomHarry Davies44211965112022NULL
28853Rennes RépubliqueFranceManon Laurent4931094382020NULL
288618Frankfurt TaunusanlageGermanyLeon Schmidt4233584392021NULL
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;