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,201–4,225 of 4,762

card_payment, page 169 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
480210Hangzhou XihuChinaMin Yang6253411682023NULL
48031Lyon BellecourFranceJules Petit5398809972020NULL
480432Göteborg AvenynSwedenAlice Andersson4515298732022Google Pay
48053Bordeaux ChartronsFranceInès Thomas4827037552023NULL
480612Birmingham New StUnited KingdomOliver Brown4544521132023Google Pay
48073Toulouse CapitoleFranceCamille Martin5192919232024Apple Pay
480813Edinburgh Princes StUnited KingdomJack Davies5537879272023NULL
481015Firenze Santa Maria NovellaItalyMatteo Ferrari4215273422020NULL
48114Strasbourg KléberFranceChloé Laurent4570385722023NULL
48129Shenzhen FutianChinaLin Zhao48538841112021NULL
48138Shanghai PudongChinaHao Xu6297230612021NULL
481415Roma TerminiItalyMatteo Esposito47406083112021NULL
481513Bristol Corn StUnited KingdomAva Williams5391459462023NULL
48162Lille Grand PlaceFranceLéa Bernard4637019142020NULL
48171Nantes CommerceFranceZoé Lefebvre5329255282022NULL
48188Shanghai PudongChinaHao Zhao6286132632021NULL
481926Adelaide Rundle MallAustraliaAmelia Taylor55160222122024NULL
482027Sydney Martin PlaceAustraliaIsla Wilson49210745122024NULL
482127Sydney Martin PlaceAustraliaIsla Wilson4626571922023NULL
482215Roma TerminiItalyMatteo Ferrari5140846592024NULL
48234Strasbourg KléberFranceLucas Thomas54583412112023NULL
48243Rennes RépubliqueFranceArthur Simon5321234492022NULL
48254Strasbourg KléberFranceArthur Simon4092639172022Google Pay
48266Atlanta MidtownUnited StatesMia Jones4544264272023NULL
48272Marseille CanebièreFranceChloé Laurent4410092292020NULL
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;