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,301–4,325 of 4,762

card_payment, page 173 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
49124Paris LouvreFranceManon Simon4799796362021NULL
491411Manchester Market StUnited KingdomAva Patel4597312462024NULL
491515Roma TerminiItalyBeatrice Rossi5357476062024NULL
491614Torino CentroItalySofia Greco5118538392023Apple Pay
491724Busan SeomyeonSouth KoreaSeo-yeon Kim4103501972023NULL
491823Kyoto ShijoJapanYuto Ito51151768102023Google Pay
49192Paris La DéfenseFranceHugo Simon4831856612020NULL
492010Hangzhou XihuChinaTao Liu6279401612023NULL
492130Saint Petersburg NevskyRussiaAlexander Ivanov4612456372022NULL
492233Oslo BjørvikaNorwayNoah Hansen5431581812024NULL
492310Chengdu JinjiangChinaLin Zhou54404841102024NULL
49241Lyon BellecourFranceGabriel Robert4226896592021NULL
492516Madrid Gran VíaSpainMartina López5594275582023NULL
492628Amsterdam ZuidasNetherlandsTess Smit4495076952021NULL
49272Marseille CanebièreFranceChloé Durand54336007122020NULL
49281Nantes CommerceFranceInès Lefebvre5373575212020NULL
49291Lyon BellecourFranceGabriel Bernard5533190142021NULL
49302Paris La DéfenseFranceChloé Durand5396062132024NULL
493113Bristol Corn StUnited KingdomJack Smith55440633122023NULL
49322Paris La DéfenseFranceHugo Simon4860959322024Google Pay
49333Bordeaux ChartronsFranceArthur Martin5132116732022Google Pay
49341Lyon BellecourFranceHugo Simon4423222632020NULL
493523Kyoto ShijoJapanYui Suzuki4870613662022NULL
49362Marseille CanebièreFranceHugo Lefebvre40936185102024NULL
493713Bristol Corn StUnited KingdomAlfie Johnson4753312332024NULL
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;