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 4,226–4,250 of 4,762

card_payment, page 170 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
48281Nantes CommerceFranceLéa Lefebvre5439760352020NULL
482918Berlin Unter den LindenGermanyFinn Schneider43255789112022NULL
48305Austin DowntownUnited StatesHarper Garcia5511429412020NULL
483121Brasília Asa SulBrazilLaura Santos4502282082021NULL
483220São Paulo PaulistaBrazilValentina Oliveira4688365792020NULL
483320Rio CentroBrazilValentina Oliveira4889675372023NULL
483435Toronto Bay StCanadaOlivia Martin45862280122021NULL
48354Paris LouvreFranceLouis Moreau5201941792023NULL
48371Paris OpéraFranceHugo Moreau4231300722022NULL
48388Shanghai PudongChinaLei Wu62250178102020NULL
48392Paris La DéfenseFranceInès Thomas4480274382024Apple Pay
48404Paris LouvreFranceArthur Simon5307264652024Apple Pay
48411Lyon BellecourFranceInès Bernard5180117352024NULL
48421Nantes CommerceFranceHugo Bernard54488037112024NULL
48442Marseille CanebièreFranceChloé Bernard49524210102024Apple Pay
484534Tampere HämeenkatuFinlandLeo Hämäläinen5523465432023NULL
484634Helsinki AleksanterinkatuFinlandHelmi Hämäläinen4645900022020NULL
484728Rotterdam CoolsingelNetherlandsDaan de Jong40952162102023NULL
484819Hamburg JungfernstiegGermanyBen Fischer40035470122020NULL
485028Rotterdam CoolsingelNetherlandsJulia de Vries5353073162020NULL
485115Firenze Santa Maria NovellaItalyLeonardo Marino43356106102021Google Pay
48526Boston Back BayUnited StatesJames Davis45937172102023NULL
48532Paris La DéfenseFranceCamille Petit52434803112021NULL
48543Toulouse CapitoleFranceHugo Durand42914020112023NULL
485526Melbourne Collins StAustraliaRuby Brown5405666952022Google 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;