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

card_payment, page 152 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
43461Lyon BellecourFranceManon Lefebvre46738538122023Google Pay
434717Bilbao AbandoSpainSofía Martín43151283102023NULL
43483Rennes RépubliqueFranceZoé Laurent4280622592023NULL
434919Hamburg JungfernstiegGermanyLea Fischer4831902712024Google Pay
435014Torino CentroItalyAurora Ferrari4233026962024NULL
43513Toulouse CapitoleFranceZoé Laurent5542900092020NULL
435222Osaka UmedaJapanSakura Yamamoto3591695612020NULL
435330Saint Petersburg NevskyRussiaMaria Sokolov5320789762024NULL
43548Beijing XidanChinaFang Li5204947442024NULL
435529Utrecht CentrumNetherlandsDaan Meijer45573181122021Apple Pay
435630Moscow TverskayaRussiaMaria Popov4307894752023NULL
43576Atlanta MidtownUnited StatesEthan Anderson4364811232022NULL
435816Madrid Gran VíaSpainLucía Rodríguez48551191102020NULL
43593Rennes RépubliqueFranceGabriel Thomas4344113052024NULL
436015Firenze Santa Maria NovellaItalyMatteo Russo53271215122022NULL
436117Barcelona EixampleSpainLucía Fernández5599457192024NULL
436213Bristol Corn StUnited KingdomGeorge Johnson4626989112021NULL
436311London Canary WharfUnited KingdomGeorge Johnson4584409342021Apple Pay
43641Nantes CommerceFranceHugo Martin4533341582022Google Pay
43652Paris La DéfenseFranceHugo Thomas5271941672021Google Pay
43662Paris La DéfenseFranceArthur Leroy4633768232020NULL
43675Austin DowntownUnited StatesNoah Johnson5589201722021Apple Pay
436823Yokohama MinatomiraiJapanSakura Suzuki4014846352024NULL
436918Frankfurt TaunusanlageGermanyHannah Schmidt4222715032022NULL
43706Boston Back BayUnited StatesEthan Garcia4021166812021NULL
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;