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,851–2,875 of 4,762

card_payment, page 115 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
332319München MarienplatzGermanyLina Schmidt55838146112019NULL
33247Denver Union StationUnited StatesLogan Taylor45025913102020NULL
332511Manchester Market StUnited KingdomIsla Taylor54724250102022NULL
33263Toulouse CapitoleFranceChloé Lefebvre4675123772020NULL
33271Paris OpéraFranceLouis Martin4489779922020NULL
33286Boston Back BayUnited StatesEthan Williams4110035132022NULL
332919Hamburg JungfernstiegGermanyFinn Becker46946987122021NULL
33304Paris LouvreFranceManon Simon4144798282021NULL
33316San Francisco Market StUnited StatesLogan Johnson51717844102023NULL
33327Denver Union StationUnited StatesLogan Johnson4251753492023NULL
33334Strasbourg KléberFranceManon Simon4884974982023Apple Pay
33344Paris LouvreFranceInès Petit5398341932021NULL
333518Berlin Unter den LindenGermanyBen Meyer47755785112021Google Pay
33361Lyon BellecourFranceLucas Leroy51383111102020NULL
33374Strasbourg KléberFranceInès Robert4646911132020NULL
333818Frankfurt TaunusanlageGermanyMia Hoffmann4046780412022Apple Pay
33407Seattle Pike PlaceUnited StatesEthan Williams37828725122021NULL
334120Rio CentroBrazilDavi Souza5349272972022NULL
33424Strasbourg KléberFranceArthur Moreau5568036082020Apple Pay
334331Kraków RynekPolandJulia Kamiński4160757092023NULL
334414Milano DuomoItalyGinevra Greco54643673122020Apple Pay
334514Torino CentroItalyGinevra Greco5579731582019Google Pay
334635Montréal Ville-MarieCanadaOlivia Brown5317974212019Apple Pay
334731Kraków RynekPolandJakub Kowalczyk53519287112021NULL
334811London Canary WharfUnited KingdomFreddie Walker4707190292019NULL
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;