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,176–1,200 of 4,762

card_payment, page 48 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
141528Rotterdam CoolsingelNetherlandsLucas Meijer5336682682018NULL
141714Milano DuomoItalyAurora Ricci55804991112018NULL
141811London Canary WharfUnited KingdomJack Wright5170417752021NULL
14194Strasbourg KléberFranceGabriel Moreau55549450102018NULL
14201Paris OpéraFranceManon Moreau4631828382018NULL
14218Shanghai PudongChinaTao Wang62552810112018NULL
14229Shenzhen FutianChinaFang Sun4423848932020NULL
14232Paris La DéfenseFranceCamille Lefebvre4629067182021NULL
142427Sydney Martin PlaceAustraliaCharlotte Jones4458029282018NULL
142511Manchester Market StUnited KingdomOliver Williams4769135912018NULL
142635Montréal Ville-MarieCanadaWilliam Wilson5290257982020NULL
14283Rennes RépubliqueFranceLouis Lefebvre4661401732017NULL
14292Paris La DéfenseFranceManon Leroy4712411762020Google Pay
143028Amsterdam ZuidasNetherlandsDaan de Jong4751551322019Apple Pay
143117Bilbao AbandoSpainHugo Martín4120788092018NULL
143218Frankfurt TaunusanlageGermanyFinn Weber4342054472018NULL
143311Manchester Market StUnited KingdomOliver Wright4994917252017NULL
143420São Paulo PaulistaBrazilValentina Silva4533207032018NULL
143534Helsinki AleksanterinkatuFinlandSofia Mäkinen43619906122017NULL
143617Bilbao AbandoSpainHugo Martín5407339072020NULL
14376San Francisco Market StUnited StatesEmma Miller4271552512018NULL
143827Sydney Martin PlaceAustraliaNoah Wilson3780809542019NULL
14406Boston Back BayUnited StatesMia Jones4444012762020NULL
144128Amsterdam ZuidasNetherlandsSem Smit4030126932019NULL
144319München MarienplatzGermanyPaul Fischer4561729222018NULL
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;