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,676–2,700 of 4,762

card_payment, page 108 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
31286Boston Back BayUnited StatesJames Garcia4436455692019Google Pay
312917Bilbao AbandoSpainValeria Fernández5413918272019NULL
313024Seoul YeouidoSouth KoreaDo-yun Cho5334427862020NULL
313114Milano DuomoItalyLeonardo Ricci4368260962022NULL
31321Nantes CommerceFranceArthur Moreau4771871132023NULL
31358Shanghai PudongChinaJun Yang4369254982023NULL
313617Bilbao AbandoSpainLucía López54374823122020NULL
31372Marseille CanebièreFranceManon Martin5123335082019NULL
313835Toronto Bay StCanadaChloé Roy5404445582019NULL
313928Amsterdam ZuidasNetherlandsDaan Jansen5204193652019Apple Pay
314030Saint Petersburg NevskyRussiaIvan Petrov4274209362022NULL
314116Madrid Gran VíaSpainLucía López4440112522020NULL
314220Rio CentroBrazilHelena Rodrigues49253157122020NULL
314316Madrid Gran VíaSpainMateo López5181375592022Apple Pay
314620Rio CentroBrazilMiguel Santos4649405792022NULL
314735Montréal Ville-MarieCanadaLiam Martin5166946342021NULL
314813Edinburgh Princes StUnited KingdomGeorge Smith49530929112020NULL
314912Birmingham New StUnited KingdomJack Walker51155282102023NULL
315024Busan SeomyeonSouth KoreaHa-eun Yoon4467344522020Apple Pay
315117Barcelona EixampleSpainHugo García4786452072020NULL
315229Utrecht CentrumNetherlandsNoah de Jong4216112792022Google Pay
315328Rotterdam CoolsingelNetherlandsNoah de Jong4566511692022Google Pay
31544Paris LouvreFranceZoé Laurent4733257962019NULL
31556San Francisco Market StUnited StatesJames Miller40043291122019NULL
31562Marseille CanebièreFranceZoé Petit4516868012020NULL
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;