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,301–2,325 of 4,762

card_payment, page 93 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
27224Paris LouvreFranceArthur Leroy53001561122021NULL
272315Roma TerminiItalyBeatrice Bianchi4190351182018NULL
272418Frankfurt TaunusanlageGermanyLina Schmidt4288274222022NULL
272519München MarienplatzGermanyMia Meyer53136050112018NULL
27264Strasbourg KléberFranceManon Durand4866097652019NULL
272720São Paulo PaulistaBrazilAlice Ferreira4487415162020NULL
272835Montréal Ville-MarieCanadaNoah Wilson41641515122022NULL
27295Austin DowntownUnited StatesHarper Davis4925928522018NULL
27302Marseille CanebièreFranceManon Durand5527974162022NULL
27316San Francisco Market StUnited StatesHarper Davis5551653362021NULL
273214Milano DuomoItalySofia Esposito4233047272021NULL
273319Hamburg JungfernstiegGermanyElias Fischer40214537102022Google Pay
27348Shanghai PudongChinaLei Sun5277559812021Apple Pay
27353Toulouse CapitoleFranceChloé Simon45433289112019NULL
273619München MarienplatzGermanyPaul Müller51880352122020NULL
27377Denver Union StationUnited StatesNoah Williams42715773112020NULL
273830Moscow TverskayaRussiaMikhail Smirnov4633861192021NULL
27398Beijing XidanChinaLin Huang5388795392020NULL
27406San Francisco Market StUnited StatesMia Williams4820346942021NULL
27418Shanghai PudongChinaJing Zhang6292142042021Apple Pay
274232Stockholm Sergels TorgSwedenElsa Olsson54311314102019NULL
274325Incheon SongdoSouth KoreaJi-woo Kim4644955572018NULL
27457Denver Union StationUnited StatesElla Garcia5311224522020NULL
27464Strasbourg KléberFranceLouis Simon4953884452020NULL
27472Paris La DéfenseFranceChloé Bernard4028595322020NULL
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;