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 176–200 of 4,762

card_payment, page 8 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
2043Toulouse CapitoleFranceLouis Simon4581357242018NULL
20531Kraków RynekPolandJakub Zieliński4724064752018NULL
2067Denver Union StationUnited StatesAva Moore37569313102019NULL
2072Paris La DéfenseFranceHugo Moreau5251763972019NULL
20831Kraków RynekPolandHanna Kowalski4601918562017NULL
20919Hamburg JungfernstiegGermanyElias Koch5466019942017NULL
2101Lyon BellecourFranceArthur Bernard5488985442018NULL
2112Paris La DéfenseFranceLucas Lefebvre54690340122016NULL
2123Bordeaux ChartronsFranceCamille Leroy54402017112020NULL
21326Melbourne Collins StAustraliaRuby Jones3717988892020NULL
21435Montréal Ville-MarieCanadaCharlotte Tremblay5206734912020NULL
21521Brasília Asa SulBrazilAlice Souza5211616272017NULL
21611London Canary WharfUnited KingdomOliver Patel3781755132020NULL
2198Shanghai PudongChinaXin Liu62678469102017Google Pay
22010Chengdu JinjiangChinaXin Liu54552672112020NULL
22117Bilbao AbandoSpainValeria Pérez4016433022020NULL
22211Manchester Market StUnited KingdomSophie Smith4705205262016NULL
22329Eindhoven StratumseindNetherlandsDaan Jansen4628399682020NULL
2245Austin DowntownUnited StatesHarper Moore4022324862016NULL
2252Paris La DéfenseFranceLéa Durand4751319682018NULL
22612Birmingham New StUnited KingdomAlfie Wright4742297462018NULL
22711London Canary WharfUnited KingdomFreddie Johnson41841581112020NULL
22811London Canary WharfUnited KingdomFreddie Johnson54607955102017NULL
22913Bristol Corn StUnited KingdomFreddie Johnson5215003852019NULL
2305Manhattan MidtownUnited StatesMason Wilson5155774642019NULL
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;