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,601–2,625 of 4,762

card_payment, page 105 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
30462Paris La DéfenseFranceArthur Simon5218616832021NULL
304714Torino CentroItalyFrancesco Colombo46982222102019NULL
304829Utrecht CentrumNetherlandsTess Smit4720464762020NULL
30492Lille Grand PlaceFranceGabriel Petit5286396382021NULL
305016Madrid Gran VíaSpainSofía González4385192352020NULL
305117Barcelona EixampleSpainSofía González4733159012022NULL
30531Lyon BellecourFranceInès Simon4525280432022NULL
30542Lille Grand PlaceFranceLéa Laurent4968409352023NULL
305530Saint Petersburg NevskyRussiaAnastasia Kuznetsov5196943082023NULL
30562Paris La DéfenseFranceManon Bernard42019931112022Apple Pay
30576San Francisco Market StUnited StatesEthan Anderson5198965722021NULL
305831Warszawa ŚródmieściePolandMaja Kamiński5213692032019NULL
30591Paris OpéraFranceManon Lefebvre51342902102022NULL
30602Paris La DéfenseFranceChloé Bernard5299295662019NULL
306125Seoul GangnamSouth KoreaHa-eun Kang4900977982020NULL
306229Utrecht CentrumNetherlandsEmma de Vries4802628332019NULL
30631Nantes CommerceFranceGabriel Petit42988089102022Apple Pay
30642Marseille CanebièreFranceLucas Martin5559650622020NULL
30652Paris La DéfenseFranceZoé Thomas4544293422022NULL
30665Chicago LoopUnited StatesHarper Taylor4701276862022NULL
306710Chengdu JinjiangChinaLei Li62661940102019NULL
306818Frankfurt TaunusanlageGermanyLina Koch4172646812022NULL
306921Belo Horizonte SavassiBrazilMiguel Ferreira42346801102023NULL
307014Torino CentroItalyMatteo Greco4332255852021NULL
307129Utrecht CentrumNetherlandsDaan van den Berg4479237622020NULL
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;