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,726–4,750 of 4,762

card_payment, page 190 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
537421Belo Horizonte SavassiBrazilValentina Souza4785320692021NULL
53751Paris OpéraFranceLouis Leroy55557612112025NULL
53762Marseille CanebièreFranceHugo Simon44970632122021NULL
53775Chicago LoopUnited StatesAva Moore4303382542022NULL
53786Boston Back BayUnited StatesEmma Johnson37408905112023NULL
53791Lyon BellecourFranceManon Martin4619606342025NULL
538020São Paulo PaulistaBrazilHeitor Oliveira4946068562024NULL
538130Moscow TverskayaRussiaDaria Smirnov41913514122025NULL
538227Sydney Martin PlaceAustraliaRuby Nguyen4071987192022Google Pay
53837Seattle Pike PlaceUnited StatesEmma Johnson5504387642024NULL
538430Saint Petersburg NevskyRussiaAlexander Popov44598106112023NULL
538524Seoul YeouidoSouth KoreaDo-yun Park53804071102023Apple Pay
538630Moscow TverskayaRussiaMikhail Smirnov5168754232021NULL
538725Seoul GangnamSouth KoreaSu-ah Kim5568592492025Apple Pay
53882Lille Grand PlaceFranceHugo Thomas40761245112025NULL
538911London Canary WharfUnited KingdomSophie Taylor5518870472024NULL
539017Barcelona EixampleSpainPablo Gómez5234109982022Apple Pay
53913Rennes RépubliqueFranceJules Leroy4823170142022NULL
539329Eindhoven StratumseindNetherlandsSophie van den Berg5104845862021NULL
53942Marseille CanebièreFranceLouis Leroy4913700442022Google Pay
539513Edinburgh Princes StUnited KingdomSophie Taylor5574281512023NULL
539614Torino CentroItalyGinevra Colombo5109146282025NULL
53978Beijing XidanChinaJun Huang6222341442024NULL
539831Warszawa ŚródmieściePolandMaja Nowak5518340782022NULL
539917Barcelona EixampleSpainLucía Martínez51006938102024NULL
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;