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

card_payment, page 71 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
207618Berlin Unter den LindenGermanyBen Fischer4165349222020Apple Pay
207712Leeds BriggateUnited KingdomAmelia Evans4818183382022NULL
207817Bilbao AbandoSpainDaniel Martínez4043958532020Google Pay
20796Atlanta MidtownUnited StatesEmma Johnson5358265172020NULL
20807Denver Union StationUnited StatesHarper Johnson47826643102022NULL
20813Toulouse CapitoleFranceInès Thomas4339110442020NULL
208215Roma TerminiItalyLeonardo Ricci4244120042019Apple Pay
208431Kraków RynekPolandJan Kowalczyk53708600122018NULL
208519München MarienplatzGermanyElias Meyer5427501432019Apple Pay
20866Atlanta MidtownUnited StatesNoah Brown4913022492021Apple Pay
20878Shanghai PudongChinaLin Li6228941172020NULL
208815Roma TerminiItalyAurora Rossi4654781672018NULL
209019München MarienplatzGermanyBen Koch5195105172020NULL
209134Tampere HämeenkatuFinlandVäinö Heikkinen5381919682021Google Pay
20922Paris La DéfenseFranceZoé Durand4891537862019NULL
20931Paris OpéraFranceCamille Simon53223885122019NULL
209527Sydney Martin PlaceAustraliaJack Kelly3707142672020NULL
209610Hangzhou XihuChinaYang Zhang4446185072018NULL
209726Melbourne Collins StAustraliaJack Kelly5167461312019NULL
209816Madrid Gran VíaSpainÁlvaro Pérez4387782012019NULL
209914Torino CentroItalySofia Colombo5189383472020NULL
210021Belo Horizonte SavassiBrazilDavi Oliveira4542997392018NULL
210111Manchester Market StUnited KingdomHarry Brown40896422102018NULL
210311Manchester Market StUnited KingdomHarry Brown5472088622020NULL
21059Shenzhen FutianChinaLin Huang5346062912018NULL
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;