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,576–4,600 of 4,762

card_payment, page 184 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
52053Toulouse CapitoleFranceJules Simon42996013112024Apple Pay
52063Rennes RépubliqueFranceJules Simon4484205992020NULL
520713Edinburgh Princes StUnited KingdomAlfie Patel37076406122023NULL
52087Denver Union StationUnited StatesLogan Anderson5449306472021NULL
52095Chicago LoopUnited StatesMia Wilson5134814332022NULL
52103Rennes RépubliqueFranceLouis Martin47611319122023NULL
52116Boston Back BayUnited StatesJames Miller5468703922021NULL
52146Atlanta MidtownUnited StatesEmma Jones5160694032020Google Pay
52153Toulouse CapitoleFranceCamille Lefebvre4276048292022Apple Pay
521625Incheon SongdoSouth KoreaSeo-yeon Jung4600049972024NULL
52184Paris LouvreFranceLucas Simon4061612082022NULL
521928Amsterdam ZuidasNetherlandsSem Jansen4147752172024NULL
522015Firenze Santa Maria NovellaItalyBeatrice Bianchi5449417862024NULL
52233Rennes RépubliqueFranceManon Moreau5288924562023Apple Pay
52247Denver Union StationUnited StatesLogan Williams4262202432021NULL
52257Seattle Pike PlaceUnited StatesLogan Williams4836083892021NULL
52263Rennes RépubliqueFranceLucas Moreau4746813062020NULL
522711Manchester Market StUnited KingdomOliver Smith5261324942023NULL
52285Austin DowntownUnited StatesMason Brown4733903912020NULL
522923Kyoto ShijoJapanYuto Nakamura3580803472022NULL
52307Denver Union StationUnited StatesEmma Anderson5567907512021Apple Pay
523111Manchester Market StUnited KingdomHarry Jones3782868442024NULL
523228Rotterdam CoolsingelNetherlandsSophie de Vries52630721122024NULL
523335Toronto Bay StCanadaNoah Brown5316093242022NULL
52346San Francisco Market StUnited StatesLiam Williams46407848112021Apple 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;