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 3,501–3,525 of 4,762

card_payment, page 141 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
40557Denver Union StationUnited StatesMason Miller4955422452024NULL
40562Paris La DéfenseFranceLouis Robert5164054972022NULL
405716Madrid Gran VíaSpainHugo Fernández4240523422023NULL
40581Lyon BellecourFranceInès Lefebvre4959543932022NULL
40593Toulouse CapitoleFranceJules Lefebvre4882912482024NULL
40604Strasbourg KléberFranceChloé Robert5361631632020NULL
40616San Francisco Market StUnited StatesEmma Anderson51727759102021NULL
40624Strasbourg KléberFranceInès Thomas4657954582021NULL
40634Paris LouvreFranceZoé Lefebvre55514284102020NULL
406413Bristol Corn StUnited KingdomGrace Wright4928864082021NULL
406510Hangzhou XihuChinaYan Chen6208992962020NULL
406610Chengdu JinjiangChinaYan Chen6280712172021NULL
40672Marseille CanebièreFranceChloé Dubois46667374122020NULL
40687Denver Union StationUnited StatesMia Anderson4290197592022Google Pay
40696San Francisco Market StUnited StatesOlivia Moore43035884102023NULL
40702Paris La DéfenseFranceLouis Thomas4244702922023NULL
40714Paris LouvreFranceLéa Leroy5274063892024NULL
40722Lille Grand PlaceFranceLucas Moreau4517312692024NULL
40737Denver Union StationUnited StatesNoah Johnson4758482582023NULL
40744Strasbourg KléberFranceChloé Simon4481071952023NULL
40754Strasbourg KléberFranceLéa Robert4683835442022Apple Pay
40766Atlanta MidtownUnited StatesLiam Johnson55371680112021NULL
407730Moscow TverskayaRussiaDmitry Sokolov4046491392020NULL
407831Warszawa ŚródmieściePolandZuzanna Wiśniewski4063341592024NULL
407912Leeds BriggateUnited KingdomIsla Williams5581372792021Google Pay
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;