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 3,451–3,475 of 4,762

card_payment, page 139 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
399910Chengdu JinjiangChinaTao Zhang4028653622023NULL
40005Austin DowntownUnited StatesMia Brown4873457842019NULL
400124Busan SeomyeonSouth KoreaSeo-yeon Jung5119491932022NULL
40033Toulouse CapitoleFranceJules Robert5468960782020NULL
40047Denver Union StationUnited StatesHarper Williams5556136272022Apple Pay
400526Melbourne Collins StAustraliaNoah Ryan4379917872022NULL
400721Brasília Asa SulBrazilHelena Souza5219970492022NULL
400812Leeds BriggateUnited KingdomIsla Evans5329146192021NULL
40091Nantes CommerceFranceGabriel Martin4075910492023Apple Pay
401021Brasília Asa SulBrazilValentina Silva51808662112021NULL
40122Paris La DéfenseFranceJules Lefebvre44414534102022NULL
40137Seattle Pike PlaceUnited StatesElla Garcia3754184572020Google Pay
40144Paris LouvreFranceJules Lefebvre4622002982021Google Pay
40152Lille Grand PlaceFranceHugo Simon4611871372022NULL
401721Brasília Asa SulBrazilArthur Ferreira4836255332020NULL
401820Rio CentroBrazilArthur Ferreira4453739532021NULL
401929Eindhoven StratumseindNetherlandsTess Jansen5431210792021NULL
402013Bristol Corn StUnited KingdomFreddie Johnson5292326252019NULL
40215Manhattan MidtownUnited StatesEthan Davis4688411392024NULL
402229Eindhoven StratumseindNetherlandsJulia de Jong4366735642021NULL
402331Kraków RynekPolandJakub Wiśniewski4042480452022NULL
40247Seattle Pike PlaceUnited StatesEthan Miller45879199102022NULL
40253Toulouse CapitoleFranceLucas Martin4086959552023Apple Pay
402627Sydney Martin PlaceAustraliaIsla Smith3764240662023NULL
402724Seoul YeouidoSouth KoreaSeo-yeon Park5513924572023NULL
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;