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 3,601–3,625 of 4,762

card_payment, page 145 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
41595Chicago LoopUnited StatesEthan Wilson52042269112023NULL
41601Paris OpéraFranceJules Simon4640633092024NULL
41628Beijing XidanChinaJing Yang6210746152022Google Pay
41639Guangzhou TianheChinaHao Wang4601442272023NULL
41641Lyon BellecourFranceZoé Martin4256265392024NULL
416518Berlin Unter den LindenGermanyLea Schmidt5448810622020Apple Pay
416718Berlin Unter den LindenGermanyLeon Becker4354899412022NULL
41687Seattle Pike PlaceUnited StatesMason Garcia4368978662021NULL
41695Manhattan MidtownUnited StatesElla Miller4988255532022NULL
41701Lyon BellecourFranceZoé Dubois5544842892020Apple Pay
41719Guangzhou TianheChinaYang Zhang6230637512022Apple Pay
417318Berlin Unter den LindenGermanyPaul Weber5323217462021Google Pay
41743Bordeaux ChartronsFranceZoé Petit4168724392021NULL
41752Paris La DéfenseFranceInès Moreau4450056982020Apple Pay
41769Guangzhou TianheChinaWei Li4636439472021NULL
41771Paris OpéraFranceLouis Bernard4829510512020NULL
417835Toronto Bay StCanadaWilliam Gagnon44890328102022NULL
417912Birmingham New StUnited KingdomAlfie Brown3736965252022NULL
41803Rennes RépubliqueFranceHugo Bernard4349130372024Google Pay
418112Birmingham New StUnited KingdomAva Evans5352914652021NULL
418211London Canary WharfUnited KingdomAva Evans4607237032021Apple Pay
418322Osaka UmedaJapanSota Ito55318753102024NULL
41848Beijing XidanChinaLei Huang53426595102020Google Pay
418510Chengdu JinjiangChinaLin Zhao4950393532020NULL
41863Toulouse CapitoleFranceGabriel Laurent5421989132024Apple 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;