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,076–2,100 of 4,762

card_payment, page 84 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
24597Denver Union StationUnited StatesHarper Taylor5523476692019NULL
246111London Canary WharfUnited KingdomGeorge Smith4373408332020NULL
24644Strasbourg KléberFranceCamille Thomas4126408082018NULL
24654Paris LouvreFranceArthur Martin4625553532022NULL
246617Bilbao AbandoSpainPaula Rodríguez5501042012020NULL
24682Paris La DéfenseFranceManon Leroy41192716122022NULL
246913Bristol Corn StUnited KingdomGrace Brown5326917362018NULL
247022Osaka UmedaJapanYui Sato3574105192022NULL
24719Guangzhou TianheChinaHao Wang62771110102020NULL
247230Moscow TverskayaRussiaAnna Kuznetsov46432672112018NULL
247321Belo Horizonte SavassiBrazilValentina Pereira5218153162021NULL
24751Paris OpéraFranceManon Bernard4120250042018Google Pay
24762Lille Grand PlaceFranceZoé Robert4179836482019NULL
24779Guangzhou TianheChinaLei Chen4374749952021NULL
247816Sevilla TrianaSpainLucía González5270522462020NULL
24801Paris OpéraFranceGabriel Simon4131338862018NULL
24811Lyon BellecourFranceGabriel Simon5537999512022NULL
248218Frankfurt TaunusanlageGermanyLeon Hoffmann5362365482021NULL
248319Hamburg JungfernstiegGermanyHannah Becker41629103122018Apple Pay
24846San Francisco Market StUnited StatesNoah Garcia4930823932022Apple Pay
24857Denver Union StationUnited StatesNoah Garcia4913495812021NULL
248615Roma TerminiItalyGiulia Rossi5105317752019NULL
248710Chengdu JinjiangChinaYang Zhang5132426762018NULL
24889Shenzhen FutianChinaYang Zhang5490202922020NULL
248917Bilbao AbandoSpainPablo Fernández5590825212022NULL
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;