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,901–2,925 of 4,762

card_payment, page 117 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
337521Belo Horizonte SavassiBrazilHelena Ferreira4070999022021NULL
337612Birmingham New StUnited KingdomAlfie Jones51805633122020NULL
337719Hamburg JungfernstiegGermanyEmma Weber4154658422020Apple Pay
337814Torino CentroItalyFrancesco Ferrari4936665432021NULL
338018Berlin Unter den LindenGermanyPaul Hoffmann4539269212020NULL
33813Bordeaux ChartronsFranceManon Thomas48944535112022Apple Pay
33822Marseille CanebièreFranceCamille Robert49682767102020NULL
33837Denver Union StationUnited StatesMason Williams4165818952023NULL
338419München MarienplatzGermanyLea Meyer5272044912021NULL
338531Kraków RynekPolandSzymon Kowalski5434317812022NULL
33863Rennes RépubliqueFranceHugo Moreau4297043922022NULL
33879Guangzhou TianheChinaLei Chen4980867622022Apple Pay
33889Shenzhen FutianChinaHao Sun4802517452020NULL
33891Lyon BellecourFranceManon Moreau5416152232023NULL
33904Strasbourg KléberFranceGabriel Petit4049426772021NULL
339110Hangzhou XihuChinaYang Wu4658706162023NULL
339213Bristol Corn StUnited KingdomFreddie Wilson43406415122021NULL
339324Seoul YeouidoSouth KoreaSeo-jun Choi4702941732020Google Pay
339422Osaka UmedaJapanYuto Watanabe5260578192023Apple Pay
339520São Paulo PaulistaBrazilAlice Pereira5549892462021NULL
33965Manhattan MidtownUnited StatesMason Williams4166711882022Apple Pay
339713Edinburgh Princes StUnited KingdomAva Wright37230916102023NULL
339826WoolloomoolooAustraliaCharlotte Williams5153956952019NULL
340011Manchester Market StUnited KingdomSophie Walker42774173102023NULL
340228Rotterdam CoolsingelNetherlandsJulia Smit5205015442019Apple Pay
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;