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,401–4,425 of 4,762

card_payment, page 177 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
501918Berlin Unter den LindenGermanyLea Hoffmann5331705372020NULL
50203Rennes RépubliqueFranceJules Lefebvre5539467362022NULL
50217Denver Union StationUnited StatesEthan Miller52620063112021NULL
502211London Canary WharfUnited KingdomSophie Evans5576984462020NULL
502326WoolloomoolooAustraliaOliver Brown4436814462024Google Pay
502411London Canary WharfUnited KingdomAva Brown4128442682023NULL
50257Seattle Pike PlaceUnited StatesMia Jones5545582362020Apple Pay
502635Toronto Bay StCanadaNoah Tremblay4548638772022Google Pay
502712Birmingham New StUnited KingdomAmelia Evans45161658112021NULL
50281Paris OpéraFranceLouis Laurent49142517122020NULL
502933Oslo BjørvikaNorwayIngrid Andersen5561774832022NULL
50306Atlanta MidtownUnited StatesLiam Moore55780726112022Google Pay
503128Rotterdam CoolsingelNetherlandsSophie Jansen40122449102020NULL
503235Toronto Bay StCanadaNoah Wilson4228054012024NULL
50334Strasbourg KléberFranceManon Lefebvre4817212892021Google Pay
50342Marseille CanebièreFranceLucas Moreau4515099732020NULL
50355Austin DowntownUnited StatesLogan Brown55893678122023NULL
50366Atlanta MidtownUnited StatesLiam Taylor45495963122020Apple Pay
50384Strasbourg KléberFranceLéa Durand40456251112020NULL
50404Paris LouvreFranceChloé Bernard4926131742024NULL
504111London Canary WharfUnited KingdomHarry Jones5342837942024NULL
504230Saint Petersburg NevskyRussiaMikhail Morozov5215297092022NULL
50437Denver Union StationUnited StatesElla Johnson4652280772021Apple Pay
504412Birmingham New StUnited KingdomLily Wilson5446037092020NULL
504515Roma TerminiItalyGinevra Russo47450848102022NULL
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;