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,376–2,400 of 4,762

card_payment, page 96 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
280623Kyoto ShijoJapanYuto Suzuki3516126522019Apple Pay
28072Lille Grand PlaceFranceLucas Moreau4996227172023Apple Pay
28084Paris LouvreFranceZoé Martin5152083462021NULL
280931Warszawa ŚródmieściePolandHanna Kowalczyk4719408022023NULL
281031Kraków RynekPolandHanna Kowalczyk4280381052020NULL
28117Denver Union StationUnited StatesAva Anderson4604557792020NULL
281220Rio CentroBrazilLaura Oliveira4102008632021NULL
281335Toronto Bay StCanadaBenjamin Martin5276100042021NULL
28142Marseille CanebièreFranceLéa Robert4827993682020NULL
281529Utrecht CentrumNetherlandsDaan van den Berg5595231122020NULL
28164Strasbourg KléberFranceArthur Simon5332273562019Google Pay
28176San Francisco Market StUnited StatesHarper Smith5359526132021NULL
281832Stockholm Sergels TorgSwedenLucas Karlsson54784974112023NULL
281913Bristol Corn StUnited KingdomAva Wright5332692612022NULL
282012Leeds BriggateUnited KingdomAva Wright49203976102022Apple Pay
28218Beijing XidanChinaXin Zhou4821776332019NULL
28228Shanghai PudongChinaXin Zhou4443631952020NULL
282320Rio CentroBrazilLaura Alves44752347102021NULL
28246Atlanta MidtownUnited StatesHarper Anderson4138583692019NULL
28254Strasbourg KléberFranceCamille Robert5132552162021NULL
28266Atlanta MidtownUnited StatesMason Anderson5439759572020NULL
28275Austin DowntownUnited StatesElla Wilson4109703942020NULL
282820São Paulo PaulistaBrazilHelena Alves5387738522021NULL
28296San Francisco Market StUnited StatesMason Anderson51843686112021NULL
28307Seattle Pike PlaceUnited StatesHarper Davis3756357972022NULL
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;