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,026–3,050 of 4,762

card_payment, page 122 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
35253Bordeaux ChartronsFranceHugo Moreau5252427412021NULL
352610Hangzhou XihuChinaJing Sun4880487372022NULL
35277Denver Union StationUnited StatesAva Johnson4974779512020NULL
35285Austin DowntownUnited StatesAva Johnson5370546852023NULL
35299Shenzhen FutianChinaTao Zhang51030007112021NULL
353019Hamburg JungfernstiegGermanyLeon Koch4983922672020NULL
353118Frankfurt TaunusanlageGermanyLeon Koch4205745522021NULL
35327Seattle Pike PlaceUnited StatesMason Taylor5258095742023NULL
353327Brisbane Queen StAustraliaAmelia Smith4447082742021NULL
353431Warszawa ŚródmieściePolandJakub Wiśniewski5454338682019Apple Pay
35363Bordeaux ChartronsFranceManon Moreau42632471112023NULL
35372Marseille CanebièreFranceLucas Martin5363121372022NULL
353821Brasília Asa SulBrazilDavi Rodrigues51952561112022NULL
353930Saint Petersburg NevskyRussiaMaria Ivanov4980607112020Apple Pay
35404Strasbourg KléberFranceChloé Durand4205041272019NULL
35413Toulouse CapitoleFranceManon Lefebvre42223934112023NULL
35424Strasbourg KléberFranceJules Durand4634930752023NULL
354318Frankfurt TaunusanlageGermanyPaul Wagner4104672562023NULL
35444Paris LouvreFranceLucas Bernard4454413532020Google Pay
354515Roma TerminiItalyAurora Romano4713188682019NULL
354615Firenze Santa Maria NovellaItalyAurora Romano5201264992020NULL
354735Toronto Bay StCanadaLiam Martin46504505112022NULL
354835Montréal Ville-MarieCanadaOlivia Roy4487958492023Google Pay
354912Leeds BriggateUnited KingdomJack Smith4433520112023Apple Pay
35507Seattle Pike PlaceUnited StatesLogan Johnson47915205102020Google Pay
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;