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 851–875 of 4,762

card_payment, page 35 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
103527Sydney Martin PlaceAustraliaWilliam Ryan5456525392018NULL
103610Chengdu JinjiangChinaTao Zhang6293981722020NULL
10373Toulouse CapitoleFranceZoé Petit5168290912017Apple Pay
10381Paris OpéraFranceInès Moreau4194886512017NULL
103914Milano DuomoItalyFrancesco Colombo5511804072020NULL
104017Bilbao AbandoSpainLucía Martínez5290649562021NULL
10415Chicago LoopUnited StatesOlivia Miller5201164122021NULL
10423Rennes RépubliqueFranceLucas Bernard54569529122017NULL
104312Birmingham New StUnited KingdomIsla Brown4717057162017NULL
104425Incheon SongdoSouth KoreaMin-jun Park5121888672020NULL
104513Bristol Corn StUnited KingdomGrace Wright5431811142020Apple Pay
104624Seoul YeouidoSouth KoreaSeo-jun Kang5277244842021NULL
10474Paris LouvreFranceManon Simon5418223972021NULL
104813Bristol Corn StUnited KingdomHarry Williams4529292992021Apple Pay
10495Austin DowntownUnited StatesElla Johnson3769403542021NULL
105012Leeds BriggateUnited KingdomIsla Brown4790619782017NULL
10515Chicago LoopUnited StatesNoah Moore52262529122018NULL
105221Belo Horizonte SavassiBrazilHelena Pereira4830048752021NULL
10555Manhattan MidtownUnited StatesJames Johnson5157772842019NULL
10566Atlanta MidtownUnited StatesNoah Taylor5533431652018NULL
105719Hamburg JungfernstiegGermanyPaul Meyer5423531272017NULL
10582Lille Grand PlaceFranceCamille Simon5458296442018NULL
105911Manchester Market StUnited KingdomIsla Patel4460866892019NULL
10607Denver Union StationUnited StatesElla Johnson5360213692021NULL
10616Boston Back BayUnited StatesNoah Moore4263792582019NULL
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;