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,651–4,675 of 4,762

card_payment, page 187 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
52903Bordeaux ChartronsFranceHugo Moreau42606307122025NULL
529121Belo Horizonte SavassiBrazilArthur Rodrigues4892685912025Google Pay
529221Brasília Asa SulBrazilArthur Rodrigues4756398382023NULL
529327Brisbane Queen StAustraliaWilliam Brown4621789592024NULL
52944Strasbourg KléberFranceLéa Bernard5163292812024Google Pay
52954Paris LouvreFranceLéa Bernard5248779562025NULL
529611London Canary WharfUnited KingdomIsla Walker4116316912023NULL
52985Manhattan MidtownUnited StatesMia Jones4472746832021NULL
529920Rio CentroBrazilAlice Pereira5313355382025Google Pay
530135Toronto Bay StCanadaLiam Smith45321482102022NULL
53023Bordeaux ChartronsFranceZoé Robert4323146552021NULL
53035Manhattan MidtownUnited StatesElla Jones47092812112023Google Pay
53049Guangzhou TianheChinaTao Wang4634939632025NULL
53056San Francisco Market StUnited StatesElla Jones53225150102025NULL
530626Melbourne Collins StAustraliaWilliam Brown4620119212024NULL
53072Lille Grand PlaceFranceManon Durand5220240692022NULL
53089Shenzhen FutianChinaTao Wang6276312252023NULL
53091Nantes CommerceFranceCamille Moreau54687683102024NULL
531020Rio CentroBrazilValentina Souza41875202102024NULL
53111Paris OpéraFranceZoé Petit5112967622024NULL
53125Manhattan MidtownUnited StatesLogan Johnson44709196102022NULL
53136Boston Back BayUnited StatesEmma Smith53456389112023Google Pay
53147Denver Union StationUnited StatesEmma Smith5598937632021NULL
53158Beijing XidanChinaWei Yang6272594562025NULL
53167Denver Union StationUnited StatesHarper Garcia51008179112022Apple 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;