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 1,826–1,850 of 4,762

card_payment, page 74 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
216316Madrid Gran VíaSpainMateo Rodríguez4070599972018Google Pay
216421Belo Horizonte SavassiBrazilHeitor Rodrigues4074799242020NULL
21654Strasbourg KléberFranceLucas Dubois4686840052021NULL
21662Paris La DéfenseFranceManon Dubois4730623522021NULL
21676Atlanta MidtownUnited StatesLogan Moore54176411112022NULL
216811Manchester Market StUnited KingdomAva Taylor3736761092018NULL
21694Strasbourg KléberFranceJules Laurent4514419942022NULL
217014Milano DuomoItalyMatteo Greco4968012332022NULL
21719Guangzhou TianheChinaXin Yang5321383112020NULL
21724Strasbourg KléberFranceLéa Durand5284678992020NULL
217317Bilbao AbandoSpainPaula Martín5454739742022NULL
21748Shanghai PudongChinaHao Wang4637338522020NULL
217530Saint Petersburg NevskyRussiaMaria Vasiliev4959185732018NULL
21761Nantes CommerceFranceLéa Laurent4247253752019NULL
217825Seoul GangnamSouth KoreaYe-jun Jung41990299122019NULL
21792Marseille CanebièreFranceLéa Leroy4008464722021Apple Pay
218028Rotterdam CoolsingelNetherlandsNoah Visser4848326072019NULL
218134Helsinki AleksanterinkatuFinlandEino Korhonen5400586872021NULL
21823Bordeaux ChartronsFranceZoé Leroy5147047152021NULL
21837Denver Union StationUnited StatesNoah Wilson54633336112022NULL
218411Manchester Market StUnited KingdomSophie Jones4863541332018NULL
218518Frankfurt TaunusanlageGermanyFinn Meyer4164194222022NULL
21867Seattle Pike PlaceUnited StatesEthan Jones4438022992019NULL
218728Rotterdam CoolsingelNetherlandsNoah Visser4048618222019NULL
218829Utrecht CentrumNetherlandsNoah Jansen4996344392022NULL
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;