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,801–1,825 of 4,762

card_payment, page 73 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
213413Bristol Corn StUnited KingdomAmelia Wright5580648812019NULL
213534Tampere HämeenkatuFinlandAino Mäkelä5424914832022NULL
21369Guangzhou TianheChinaYang Chen6222648262018NULL
213714Milano DuomoItalyFrancesco Colombo5516736342021NULL
21383Rennes RépubliqueFranceManon Lefebvre4215606832020NULL
21395Chicago LoopUnited StatesMia Johnson4615224712021Apple Pay
214013Bristol Corn StUnited KingdomSophie Jones53384321122021NULL
21411Paris OpéraFranceManon Moreau4460383442018NULL
21422Marseille CanebièreFranceHugo Martin55313966122021NULL
214316Sevilla TrianaSpainÁlvaro López5575118472020NULL
214417Barcelona EixampleSpainPablo Martín5268042112021NULL
21459Shenzhen FutianChinaYang Sun4899494612018NULL
214621Brasília Asa SulBrazilHelena Oliveira4543492272019NULL
21471Lyon BellecourFranceChloé Thomas4594774882018NULL
21484Paris LouvreFranceLucas Durand5307640882021NULL
21493Rennes RépubliqueFranceJules Durand51051672122019NULL
215020São Paulo PaulistaBrazilHelena Pereira4455034862018NULL
21521Paris OpéraFranceCamille Leroy4301507812020NULL
21532Marseille CanebièreFranceLéa Thomas4838168832018Apple Pay
21556San Francisco Market StUnited StatesLiam Smith5497709622022NULL
215613Edinburgh Princes StUnited KingdomOliver Johnson4958647672021NULL
215817Bilbao AbandoSpainDaniel López4459601182021Google Pay
21602Marseille CanebièreFranceArthur Robert4230580012018NULL
216116Sevilla TrianaSpainHugo Gómez5335062872018NULL
216217Bilbao AbandoSpainMateo Rodríguez4274491482021NULL
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;