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 2,701–2,725 of 4,762

card_payment, page 109 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
315710Hangzhou XihuChinaLei Xu4580898172023NULL
315816Sevilla TrianaSpainMartina López5237118532021Google Pay
315925Incheon SongdoSouth KoreaSu-ah Park42455850112021NULL
316030Saint Petersburg NevskyRussiaAlexander Sokolov40934058122022Apple Pay
316130Moscow TverskayaRussiaDmitry Kuznetsov41887806112023NULL
316225Incheon SongdoSouth KoreaHa-eun Yoon5207142762019NULL
316326WoolloomoolooAustraliaCharlotte Kelly4226255392023NULL
31642Lille Grand PlaceFranceLéa Bernard4721579482022NULL
31652Marseille CanebièreFranceChloé Robert5540443522023Apple Pay
316612Leeds BriggateUnited KingdomAmelia Evans4564142892019Apple Pay
316722Tokyo MarunouchiJapanRen Tanaka3511542962023Apple Pay
31681Paris OpéraFranceJules Petit44130433112019NULL
316920Rio CentroBrazilDavi Oliveira4901824252022Google Pay
317015Firenze Santa Maria NovellaItalyAurora Rossi4083426182019NULL
31716San Francisco Market StUnited StatesHarper Wilson4958969942021NULL
31727Denver Union StationUnited StatesMason Brown4151957082023NULL
317313Edinburgh Princes StUnited KingdomGeorge Smith4986502272019NULL
317414Torino CentroItalyBeatrice Romano4783802782021NULL
317535Montréal Ville-MarieCanadaBenjamin Brown4126044382020NULL
317620Rio CentroBrazilMiguel Souza4724480772020NULL
317715Firenze Santa Maria NovellaItalyGinevra Russo51440547122019Google Pay
317814Milano DuomoItalyGinevra Russo5435517092020NULL
31798Beijing XidanChinaJun Huang4573085822023Apple Pay
318010Chengdu JinjiangChinaJun Huang6250135962020NULL
318127Sydney Martin PlaceAustraliaAmelia Nguyen49663413122021NULL
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;