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,526–2,550 of 4,762

card_payment, page 102 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
296712Birmingham New StUnited KingdomLily Wilson44098859122019NULL
296818Berlin Unter den LindenGermanyLina Weber53089791122021NULL
296920São Paulo PaulistaBrazilMiguel Souza47983147122022NULL
297020Rio CentroBrazilMiguel Oliveira5171812962023NULL
29712Marseille CanebièreFranceHugo Dubois41435530112020NULL
29729Guangzhou TianheChinaHao Sun4880295652019Apple Pay
29734Strasbourg KléberFranceLucas Simon5229623962019Apple Pay
29744Strasbourg KléberFranceZoé Laurent5145426772021NULL
29751Nantes CommerceFranceHugo Lefebvre4521316322020NULL
29767Denver Union StationUnited StatesHarper Smith37000153122023NULL
29776Boston Back BayUnited StatesEthan Jones4357767152023NULL
297835Toronto Bay StCanadaWilliam Tremblay5281049332023NULL
297911London Canary WharfUnited KingdomIsla Walker5423077762021NULL
298016Sevilla TrianaSpainMateo González5253511452021NULL
298127Brisbane Queen StAustraliaWilliam Ryan5320324092023Apple Pay
29835Chicago LoopUnited StatesMia Jones37944473102021NULL
29846Boston Back BayUnited StatesAva Smith4631656682019NULL
298519München MarienplatzGermanyLeon Weber47353847122022NULL
298615Firenze Santa Maria NovellaItalyGinevra Rossi53479255122019NULL
29872Marseille CanebièreFranceLouis Laurent4255321722020NULL
29882Lille Grand PlaceFranceCamille Martin4783637742020NULL
298928Rotterdam CoolsingelNetherlandsTess Jansen4874422172022NULL
29904Paris LouvreFranceLéa Laurent52121284122023Google Pay
299123Yokohama MinatomiraiJapanAoi Takahashi5136666592020NULL
299228Amsterdam ZuidasNetherlandsJulia Bakker5320977662022NULL
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;