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,151–4,175 of 4,762

card_payment, page 167 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
47478Shanghai PudongChinaLin Chen6299970012023NULL
47486San Francisco Market StUnited StatesEthan Miller4460029832020Apple Pay
47492Lille Grand PlaceFranceLucas Durand4839415622024NULL
47504Paris LouvreFranceManon Thomas4736552362021Apple Pay
47512Marseille CanebièreFranceLéa Simon5417433632021NULL
47522Lille Grand PlaceFranceLéa Lefebvre5397087142023NULL
475412Leeds BriggateUnited KingdomJack Davies5327717782024NULL
475514Milano DuomoItalySofia Bianchi5460429052022NULL
475613Bristol Corn StUnited KingdomJack Davies37225579122022NULL
47575Austin DowntownUnited StatesMia Smith44214494112024NULL
475820Rio CentroBrazilValentina Santos49197144122023Google Pay
475920São Paulo PaulistaBrazilLaura Alves55358368102024NULL
476021Belo Horizonte SavassiBrazilValentina Santos5356348762021NULL
47611Lyon BellecourFranceInès Lefebvre4264133692024NULL
476233Oslo BjørvikaNorwayEmil Nilsen4085635122022NULL
47636Boston Back BayUnited StatesNoah Anderson45078967122021Apple Pay
47644Strasbourg KléberFranceLucas Dubois4575972922021NULL
476514Torino CentroItalyGinevra Esposito4217603182023NULL
476716Madrid Gran VíaSpainDaniel Sánchez4731766472020NULL
47682Marseille CanebièreFranceZoé Petit4839525422023NULL
476925Incheon SongdoSouth KoreaDo-yun Yoon4907969712022Apple Pay
477029Eindhoven StratumseindNetherlandsDaan Bakker4979939992021NULL
477112Leeds BriggateUnited KingdomOliver Taylor53878591102020NULL
47722Paris La DéfenseFranceHugo Bernard49287784112024NULL
477328Amsterdam ZuidasNetherlandsJulia Visser4710770652021Apple Pay
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;