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,776–2,800 of 4,762

card_payment, page 112 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
324212Leeds BriggateUnited KingdomAlfie Wilson4686578262020NULL
324321Brasília Asa SulBrazilDavi Oliveira4442550132020NULL
324415Roma TerminiItalyLorenzo Ricci5374101762019Apple Pay
32459Guangzhou TianheChinaWei Wang5495441752019NULL
32466San Francisco Market StUnited StatesMia Smith4771612052020NULL
32474Paris LouvreFranceGabriel Leroy4967975062021NULL
324814Milano DuomoItalyGiulia Bianchi5221684982021NULL
324931Kraków RynekPolandJulia Wójcik4605224552022NULL
325019Hamburg JungfernstiegGermanyFinn Schneider5389619642022Apple Pay
32517Denver Union StationUnited StatesMia Davis4400012382022Apple Pay
325229Utrecht CentrumNetherlandsDaan Smit5360376642021NULL
32539Guangzhou TianheChinaWei Zhang62102864122022NULL
325514Torino CentroItalyLorenzo Ricci43307145102023NULL
325616Madrid Gran VíaSpainSofía Martínez4005474832020NULL
325718Frankfurt TaunusanlageGermanyLeon Becker4710134322023Google Pay
325810Chengdu JinjiangChinaJun Xu4428951152020NULL
32596Atlanta MidtownUnited StatesAva Johnson4764963212023NULL
32609Guangzhou TianheChinaFang Sun6298688892019NULL
326110Chengdu JinjiangChinaYan Li5371624522022NULL
32626San Francisco Market StUnited StatesMia Johnson48546579102023NULL
326315Firenze Santa Maria NovellaItalyMatteo Romano40703586102021NULL
326429Utrecht CentrumNetherlandsSem de Jong4842058572021Google Pay
326529Eindhoven StratumseindNetherlandsSem de Jong4972326942020Google Pay
32661Paris OpéraFranceGabriel Durand4057449482023NULL
326715Roma TerminiItalyGiulia Marino52114093122020NULL
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;