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,326–4,350 of 4,762

card_payment, page 174 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
493821Belo Horizonte SavassiBrazilValentina Silva5237280972021NULL
49391Nantes CommerceFranceZoé Laurent4636589932023NULL
494029Utrecht CentrumNetherlandsLucas de Vries4474613312024NULL
49412Paris La DéfenseFranceLouis Martin5393804142020NULL
494227Brisbane Queen StAustraliaJack Smith4680693572020Apple Pay
49436Boston Back BayUnited StatesMia Smith37527898122020Apple Pay
49446Atlanta MidtownUnited StatesAva Smith45833596112022NULL
49455Manhattan MidtownUnited StatesMia Smith4832900962021NULL
49463Toulouse CapitoleFranceCamille Leroy5414606982021NULL
49475Austin DowntownUnited StatesLogan Smith4485398322023NULL
494824Seoul YeouidoSouth KoreaSu-ah Park4839477362022Apple Pay
49494Paris LouvreFranceCamille Bernard47078051102024NULL
495035Toronto Bay StCanadaChloé Gagnon5188409642023NULL
495118Berlin Unter den LindenGermanyElias Becker5534499472024NULL
495214Milano DuomoItalyMatteo Rossi4756585372021NULL
495333Oslo BjørvikaNorwayFilip Andersen49766000102021NULL
49548Shanghai PudongChinaTao Li51829452102020NULL
495523Kyoto ShijoJapanSota Nakamura5592655132024NULL
49568Shanghai PudongChinaLei Xu6276843492021NULL
49579Shenzhen FutianChinaJing Wang6228675892024Apple Pay
49584Strasbourg KléberFranceManon Laurent5255427212022NULL
49592Marseille CanebièreFranceChloé Martin5569031382023NULL
49609Guangzhou TianheChinaYang Zhao4213050962022NULL
49615Manhattan MidtownUnited StatesAva Davis3781173952024NULL
496211Manchester Market StUnited KingdomSophie Johnson5411896062022NULL
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;