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 3,201–3,225 of 4,762

card_payment, page 129 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
371812Leeds BriggateUnited KingdomJack Walker51289262102023NULL
371923Kyoto ShijoJapanSota Tanaka5295458182022NULL
372034Helsinki AleksanterinkatuFinlandAada Virtanen4960960842020NULL
37216Atlanta MidtownUnited StatesAva Anderson4905266092019NULL
37226Boston Back BayUnited StatesEmma Johnson4837989232023NULL
372310Hangzhou XihuChinaFang Chen6216319792021NULL
372415Roma TerminiItalyAlessandro Ricci54136671112023NULL
372526Melbourne Collins StAustraliaRuby Ryan5382371012020NULL
372622Tokyo MarunouchiJapanAoi Suzuki3534352412020NULL
372714Torino CentroItalyAlessandro Ricci4142605992023NULL
372822Osaka UmedaJapanRen Takahashi53148987122019Apple Pay
372916Sevilla TrianaSpainPablo Gómez4505472722019NULL
37302Lille Grand PlaceFranceArthur Bernard54966911102019NULL
37311Lyon BellecourFranceChloé Simon4806533922020NULL
37321Lyon BellecourFranceCamille Dubois5421354772019Apple Pay
37344Paris LouvreFranceInès Thomas52698347102023NULL
37351Lyon BellecourFranceChloé Moreau4495443752021NULL
37361Paris OpéraFranceCamille Bernard55544762102021Apple Pay
37375Austin DowntownUnited StatesElla Moore3728731432020NULL
373815Roma TerminiItalyLeonardo Esposito4691623452020Apple Pay
373918Frankfurt TaunusanlageGermanyPaul Becker4764679942023NULL
37402Lille Grand PlaceFranceChloé Bernard49096274112023NULL
37418Shanghai PudongChinaJun Zhou4389051392022NULL
374227Brisbane Queen StAustraliaJack Jones53974070102023NULL
37435Chicago LoopUnited StatesJames Johnson5547515812019NULL
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;