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 351–375 of 4,762

card_payment, page 15 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
42511Manchester Market StUnited KingdomSophie Wright46645580112017NULL
42617Barcelona EixampleSpainValeria Martín5442771752020NULL
4271Lyon BellecourFranceManon Dubois4353700622019NULL
4285Manhattan MidtownUnited StatesMason Taylor54434357102018NULL
4291Nantes CommerceFranceHugo Robert4896825972017NULL
4306Atlanta MidtownUnited StatesHarper Moore4945676452020NULL
4319Guangzhou TianheChinaLin Sun5393686022020NULL
43227Sydney Martin PlaceAustraliaIsla Brown37512980102018NULL
4352Paris La DéfenseFranceZoé Petit4728288422016NULL
43812Leeds BriggateUnited KingdomGrace Evans4620509652016NULL
4392Lille Grand PlaceFranceGabriel Robert5408173072016NULL
4402Lille Grand PlaceFranceLucas Simon5196434032019NULL
4423Toulouse CapitoleFranceChloé Moreau5558856082020NULL
4436Boston Back BayUnited StatesMia Davis4909360432016Apple Pay
4442Marseille CanebièreFranceLéa Leroy48858850122016NULL
4458Shanghai PudongChinaTao Xu4995357472019NULL
4464Strasbourg KléberFranceChloé Durand55176330102016NULL
4479Guangzhou TianheChinaXin Wu52193335122017NULL
4483Bordeaux ChartronsFranceInès Laurent4337209262016NULL
45022Osaka UmedaJapanHaruto Sato4922119772017NULL
45120São Paulo PaulistaBrazilAlice Ferreira5217945452020NULL
4524Strasbourg KléberFranceCamille Robert5111339142016NULL
45516Madrid Gran VíaSpainLucía Pérez4614620132020NULL
45626WoolloomoolooAustraliaJack Ryan43113543122019NULL
4585Austin DowntownUnited StatesLogan Johnson4245242692020NULL
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;