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 151–175 of 4,762

card_payment, page 7 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
1711Lyon BellecourFranceLucas Dubois5507466482017NULL
1733Toulouse CapitoleFranceLouis Simon5369216262018NULL
1745Manhattan MidtownUnited StatesHarper Wilson4406940862019NULL
1757Seattle Pike PlaceUnited StatesHarper Wilson5236188442018NULL
17612Birmingham New StUnited KingdomFreddie Patel51956021112019NULL
17712Birmingham New StUnited KingdomGrace Walker49843073102019NULL
17814Milano DuomoItalyLeonardo Rossi5574295222019NULL
1798Beijing XidanChinaMin Xu6245795822019NULL
1801Lyon BellecourFranceLéa Thomas4067487962018NULL
1819Guangzhou TianheChinaMin Xu45149576122016NULL
18316Madrid Gran VíaSpainValeria González4499384642017NULL
18414Milano DuomoItalyLeonardo Rossi5269006112016NULL
18513Edinburgh Princes StUnited KingdomFreddie Wright5247318282018NULL
1867Denver Union StationUnited StatesEmma Johnson5536240512016NULL
1893Bordeaux ChartronsFranceChloé Laurent4792943162018NULL
19113Bristol Corn StUnited KingdomHarry Evans5218634332020NULL
19330Saint Petersburg NevskyRussiaMikhail Popov4089034752020NULL
1941Paris OpéraFranceCamille Simon54811563102019NULL
1964Paris LouvreFranceGabriel Robert4223954432016NULL
19716Madrid Gran VíaSpainHugo Martínez4987353882016NULL
19816Sevilla TrianaSpainHugo Martínez5365014942018NULL
20012Birmingham New StUnited KingdomFreddie Walker51428794122019NULL
2013Toulouse CapitoleFranceCamille Lefebvre4564920922017NULL
20219München MarienplatzGermanyPaul Koch4960884252018Apple Pay
20328Rotterdam CoolsingelNetherlandsTess Visser5380325672018NULL
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;