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,026–4,050 of 4,762

card_payment, page 162 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
46076Atlanta MidtownUnited StatesMia Anderson3727539062024NULL
46083Bordeaux ChartronsFranceArthur Durand5526293252024NULL
46093Rennes RépubliqueFranceArthur Durand46263392122023NULL
46115Manhattan MidtownUnited StatesJames Garcia54778502102024NULL
46121Nantes CommerceFranceArthur Dubois5187366752021NULL
461321Belo Horizonte SavassiBrazilAlice Souza4812359132022NULL
461416Madrid Gran VíaSpainMartina González4622901182024NULL
46152Lille Grand PlaceFranceArthur Lefebvre4716103372023Apple Pay
461630Saint Petersburg NevskyRussiaIvan Vasiliev4467239632024NULL
461735Toronto Bay StCanadaLiam Martin4369101142024NULL
461835Toronto Bay StCanadaLiam Martin52181196112021NULL
461915Firenze Santa Maria NovellaItalyLorenzo Marino5401815252022Apple Pay
46207Seattle Pike PlaceUnited StatesMason Jones4305135282022NULL
462118Frankfurt TaunusanlageGermanyPaul Schneider4601723662023NULL
462223Yokohama MinatomiraiJapanHaruto Nakamura3502274692021NULL
462314Milano DuomoItalyLorenzo Colombo4696544462023Apple Pay
462431Warszawa ŚródmieściePolandJulia Wiśniewski45676041122023Apple Pay
46257Denver Union StationUnited StatesElla Jones44590203112021NULL
46264Paris LouvreFranceManon Lefebvre5289992862021NULL
462710Chengdu JinjiangChinaJing Wang6258877092022Apple Pay
46293Bordeaux ChartronsFranceJules Lefebvre51985868112021NULL
463010Chengdu JinjiangChinaYan Yang49943670102020Apple Pay
463114Milano DuomoItalyGiulia Rossi51717807112023Google Pay
46323Bordeaux ChartronsFranceCamille Lefebvre4987185322020NULL
46337Denver Union StationUnited StatesLogan Moore45553078102024NULL
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;