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,451–4,475 of 4,762

card_payment, page 179 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
50743Bordeaux ChartronsFranceLucas Leroy5478541282020NULL
50756Atlanta MidtownUnited StatesAva Miller5299034492024NULL
507635Montréal Ville-MarieCanadaNoah Gagnon4212121222024NULL
507735Toronto Bay StCanadaBenjamin Lee46988545112022Google Pay
50787Denver Union StationUnited StatesEthan Johnson3713412312023NULL
50794Paris LouvreFranceInès Petit4819666562021NULL
50803Bordeaux ChartronsFranceManon Durand49275457102021NULL
508212Leeds BriggateUnited KingdomHarry Jones40002103112020Google Pay
508312Leeds BriggateUnited KingdomSophie Johnson5152815222022Google Pay
50846Boston Back BayUnited StatesEmma Moore4837430182024NULL
508521Brasília Asa SulBrazilDavi Santos5411241192020NULL
50863Bordeaux ChartronsFranceArthur Bernard4072489752024NULL
508730Saint Petersburg NevskyRussiaAlexander Vasiliev52648205112020NULL
508810Hangzhou XihuChinaYang Yang47765475102021NULL
50895Austin DowntownUnited StatesEmma Moore4386234472022Apple Pay
50909Shenzhen FutianChinaMin Wu44064818102022NULL
509122Tokyo MarunouchiJapanRen Sato3596199232022Apple Pay
509217Bilbao AbandoSpainDaniel González4820036942021NULL
509322Osaka UmedaJapanSakura Yamamoto3554290632023Google Pay
509424Busan SeomyeonSouth KoreaSu-ah Yoon4946697292023NULL
50955Chicago LoopUnited StatesAva Johnson4753498242021NULL
509628Rotterdam CoolsingelNetherlandsDaan Meijer5272984232020NULL
509724Busan SeomyeonSouth KoreaYe-jun Kang4569590892024NULL
509835Toronto Bay StCanadaOlivia Martin5142650072023NULL
509923Kyoto ShijoJapanHaruto Tanaka3564841122023NULL
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;