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,376–4,400 of 4,762

card_payment, page 176 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
499130Saint Petersburg NevskyRussiaAnna Petrov5422469982023NULL
49926Atlanta MidtownUnited StatesLiam Anderson3770240812020NULL
499312Leeds BriggateUnited KingdomHarry Smith51978862112020Google Pay
499430Moscow TverskayaRussiaMikhail Smirnov43421068102024Google Pay
499535Toronto Bay StCanadaCharlotte Martin5156151772020NULL
499721Brasília Asa SulBrazilMiguel Rodrigues4890565232022NULL
499815Roma TerminiItalyLorenzo Greco4091456692024NULL
500010Chengdu JinjiangChinaLei Zhao40717889112020NULL
50013Rennes RépubliqueFranceLucas Thomas43152401122024NULL
500214Milano DuomoItalyGiulia Romano5230598382022Google Pay
50039Shenzhen FutianChinaYan Wu5321932492023NULL
500418Berlin Unter den LindenGermanyMia Becker5235360672024NULL
500532Göteborg AvenynSwedenWilliam Persson4809444382024NULL
500625Incheon SongdoSouth KoreaSu-ah Kim4509494152022NULL
500714Milano DuomoItalyGiulia Romano5358595212020NULL
50088Beijing XidanChinaWei Zhou6285136472021NULL
500916Sevilla TrianaSpainMateo Gómez52918346102021NULL
501018Frankfurt TaunusanlageGermanyLea Meyer5109899162022Google Pay
501126WoolloomoolooAustraliaJack Smith37401749102022Apple Pay
501329Eindhoven StratumseindNetherlandsDaan Smit45699229122020NULL
501429Utrecht CentrumNetherlandsDaan Smit5218168232023NULL
501518Berlin Unter den LindenGermanyLea Koch5508943332020NULL
50166San Francisco Market StUnited StatesMason Miller5281460972021NULL
50173Toulouse CapitoleFranceInès Laurent4624578592024NULL
50184Strasbourg KléberFranceArthur Martin45045513102020NULL
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;