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

card_payment, page 95 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
277835Montréal Ville-MarieCanadaCharlotte Smith4054396842018NULL
27794Paris LouvreFranceGabriel Petit4260484832021NULL
27814Paris LouvreFranceLouis Simon48191433122021NULL
27828Shanghai PudongChinaWei Zhao6228737282019NULL
278335Toronto Bay StCanadaChloé Wilson5362328062020NULL
278425Incheon SongdoSouth KoreaSeo-yeon Kim54101625112022NULL
27851Paris OpéraFranceHugo Martin4190672672020NULL
27864Strasbourg KléberFranceLouis Thomas42333218122019NULL
27878Shanghai PudongChinaYang Xu4712898132022NULL
27883Toulouse CapitoleFranceLouis Robert6283958242019NULL
27892Marseille CanebièreFranceChloé Petit4214609742021NULL
27904Strasbourg KléberFranceCamille Lefebvre5339704442019NULL
27925Manhattan MidtownUnited StatesHarper Brown5237590972021Apple Pay
27939Shenzhen FutianChinaJing Li5332644892022NULL
27947Seattle Pike PlaceUnited StatesAva Anderson46264811112022NULL
279511London Canary WharfUnited KingdomFreddie Walker41481634122018NULL
27961Lyon BellecourFranceChloé Lefebvre5544429422022NULL
27976Atlanta MidtownUnited StatesElla Wilson4449421182023Google Pay
27984Strasbourg KléberFranceInès Robert54996126112019NULL
279920Rio CentroBrazilHelena Ferreira52203556122022NULL
280016Sevilla TrianaSpainSofía Martín4565190892020Apple Pay
280216Sevilla TrianaSpainDaniel López4028979582023NULL
28035Austin DowntownUnited StatesElla Johnson5281551532019Apple Pay
28042Marseille CanebièreFranceJules Durand4569578792019NULL
280520São Paulo PaulistaBrazilHelena Silva4157358352020NULL
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;