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 2,051–2,075 of 4,762

card_payment, page 83 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
243035Toronto Bay StCanadaOlivia Lee55016968112022NULL
24317Seattle Pike PlaceUnited StatesOlivia Smith5464332662021NULL
24327Denver Union StationUnited StatesEthan Moore54917187122022Apple Pay
24333Toulouse CapitoleFranceCamille Lefebvre5200056592022NULL
24343Toulouse CapitoleFranceLouis Leroy54787630112018NULL
243531Warszawa ŚródmieściePolandMaja Nowak5147437192021NULL
243620São Paulo PaulistaBrazilAlice Souza4304462482019NULL
243831Kraków RynekPolandMaja Nowak5237727552021NULL
24397Seattle Pike PlaceUnited StatesLiam Brown5449700692020NULL
244022Osaka UmedaJapanYui Ito3540735652019NULL
24416Boston Back BayUnited StatesHarper Wilson52361132102019Apple Pay
244214Torino CentroItalyLorenzo Rossi5249067392021NULL
24433Bordeaux ChartronsFranceArthur Simon5372053222022Apple Pay
24448Beijing XidanChinaXin Chen6214273432018NULL
244627Sydney Martin PlaceAustraliaCharlotte Ryan4433466212019NULL
244712Birmingham New StUnited KingdomIsla Patel37196128102019NULL
244924Busan SeomyeonSouth KoreaDo-yun Kang4073746062021NULL
24506San Francisco Market StUnited StatesNoah Davis4847168612021NULL
245127Brisbane Queen StAustraliaNoah Jones5147866772018NULL
24537Seattle Pike PlaceUnited StatesOlivia Miller5481535772021NULL
24546Atlanta MidtownUnited StatesEthan Moore55177335122019NULL
245528Amsterdam ZuidasNetherlandsDaan Bakker5570594682018NULL
245624Busan SeomyeonSouth KoreaSeo-yeon Cho5145634932018NULL
24579Guangzhou TianheChinaJun Sun5163542842019NULL
24584Paris LouvreFranceLucas Simon6298581612021NULL
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;