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,751–3,775 of 4,762

card_payment, page 151 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
43217Denver Union StationUnited StatesJames Brown4939461942024NULL
432234Helsinki AleksanterinkatuFinlandVäinö Nieminen42411357122020NULL
432310Chengdu JinjiangChinaFang Huang6270922992021NULL
43244Strasbourg KléberFranceInès Laurent55521268102023NULL
43253Rennes RépubliqueFranceInès Leroy49612245112023NULL
43264Paris LouvreFranceArthur Moreau40189668102021NULL
43274Strasbourg KléberFranceArthur Durand5143639382023NULL
432830Moscow TverskayaRussiaMaria Sokolov4200747762021Google Pay
432929Eindhoven StratumseindNetherlandsJulia Bakker4589279442021Apple Pay
433019Hamburg JungfernstiegGermanyElias Meyer4987808062020NULL
433122Osaka UmedaJapanYui Takahashi4775658772021NULL
43325Chicago LoopUnited StatesElla Johnson5534922622021NULL
433332Göteborg AvenynSwedenWilliam Nilsson4224415812023NULL
43343Toulouse CapitoleFranceInès Durand43425736102024NULL
433516Madrid Gran VíaSpainMartina Rodríguez4124056392024NULL
433610Chengdu JinjiangChinaFang Li4803845642023NULL
43371Lyon BellecourFranceLouis Bernard4919546182023Apple Pay
43383Bordeaux ChartronsFranceLucas Laurent5304413812021Google Pay
433935Montréal Ville-MarieCanadaBenjamin Wilson4371164572020NULL
434035Montréal Ville-MarieCanadaBenjamin Wilson4783774342024NULL
43418Shanghai PudongChinaWei Huang4286692242020NULL
43422Marseille CanebièreFranceLucas Robert54709106102021Apple Pay
434330Moscow TverskayaRussiaIvan Kuznetsov4830682812020NULL
43442Lille Grand PlaceFranceManon Lefebvre55217886112021NULL
43452Paris La DéfenseFranceZoé Thomas4602886782024Apple 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;