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,626–2,650 of 4,762

card_payment, page 106 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
307228Rotterdam CoolsingelNetherlandsDaan van den Berg4034805592023NULL
30736Boston Back BayUnited StatesLiam Williams5268010492019NULL
307419Hamburg JungfernstiegGermanyElias Fischer4271826722020NULL
307519Hamburg JungfernstiegGermanyElias Fischer4047787562020NULL
30763Bordeaux ChartronsFranceLéa Moreau4686034152019Google Pay
30779Shenzhen FutianChinaYang Sun4860143832020NULL
307822Tokyo MarunouchiJapanYuto Takahashi3576683382019Apple Pay
30792Marseille CanebièreFranceGabriel Lefebvre4527583342023NULL
308013Edinburgh Princes StUnited KingdomAlfie Patel4197871032022Apple Pay
30814Paris LouvreFranceLéa Bernard4232202352022NULL
30822Lille Grand PlaceFranceLéa Bernard41191541112023NULL
308431Warszawa ŚródmieściePolandZuzanna Kowalczyk5354898822019NULL
30853Rennes RépubliqueFranceHugo Dubois4718565122020NULL
30867Denver Union StationUnited StatesOlivia Davis4170589212023NULL
30886Boston Back BayUnited StatesMia Williams44926109112023NULL
30891Paris OpéraFranceHugo Thomas4894558742021NULL
309030Moscow TverskayaRussiaDaria Petrov4285093142021NULL
30939Guangzhou TianheChinaXin Xu4233888512021Apple Pay
309418Berlin Unter den LindenGermanyEmma Becker4639572112022NULL
309524Seoul YeouidoSouth KoreaMin-jun Kim47772326112023NULL
30964Paris LouvreFranceLouis Laurent4755927862020NULL
309727Brisbane Queen StAustraliaRuby Brown5596501722020NULL
309824Busan SeomyeonSouth KoreaSeo-jun Jung5412946352022NULL
30999Shenzhen FutianChinaLin Wu6272555162022NULL
310024Seoul YeouidoSouth KoreaDo-yun Kim5232906512020NULL
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;