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,251–4,275 of 4,762

card_payment, page 171 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
485616Sevilla TrianaSpainValeria Martín5295680042020Apple Pay
48575Manhattan MidtownUnited StatesMia Garcia52594042122022NULL
485812Birmingham New StUnited KingdomHarry Johnson5444378772021NULL
485918Berlin Unter den LindenGermanyLina Schneider5112550522024NULL
48608Shanghai PudongChinaYang Zhao4950646872022NULL
48611Paris OpéraFranceLéa Robert4586964172020NULL
48623Bordeaux ChartronsFranceInès Thomas46002268112022Apple Pay
486314Milano DuomoItalyAurora Romano4467945422020Apple Pay
486411Manchester Market StUnited KingdomIsla Taylor4078677372020NULL
486530Moscow TverskayaRussiaDaria Vasiliev49383728112021NULL
486617Bilbao AbandoSpainMateo López5325135782021NULL
486719München MarienplatzGermanyLina Schneider42207965102021NULL
48687Denver Union StationUnited StatesMia Wilson4319278762020NULL
486927Sydney Martin PlaceAustraliaRuby Taylor5292408382021NULL
487022Tokyo MarunouchiJapanYuto Yamamoto4188305332022NULL
48718Shanghai PudongChinaXin Chen62641622122022NULL
487212Leeds BriggateUnited KingdomGrace Walker5405613622023Google Pay
48731Paris OpéraFranceChloé Dubois42123177112021Google Pay
487510Chengdu JinjiangChinaLin Zhao6239269512022NULL
487620Rio CentroBrazilHeitor Pereira5358747082021NULL
487818Berlin Unter den LindenGermanyBen Müller43962193122021Google Pay
48799Shenzhen FutianChinaXin Chen6255161382023Apple Pay
48808Beijing XidanChinaXin Chen4697420222021Apple Pay
488127Brisbane Queen StAustraliaWilliam Taylor4430535462022NULL
488230Saint Petersburg NevskyRussiaDaria Kuznetsov5129534692024NULL
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;