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,551–3,575 of 4,762

card_payment, page 143 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
410610Hangzhou XihuChinaLin Zhao4831783072020NULL
410716Sevilla TrianaSpainHugo Gómez51331214102021NULL
410811Manchester Market StUnited KingdomGrace Taylor4748761332023Google Pay
41097Seattle Pike PlaceUnited StatesMia Williams5404663212022NULL
411019Hamburg JungfernstiegGermanyEmma Müller4862334772020Google Pay
411135Toronto Bay StCanadaWilliam Wilson4196257412022NULL
411216Madrid Gran VíaSpainSofía Pérez41604994102024NULL
41132Marseille CanebièreFranceLouis Martin5276094422021NULL
41141Paris OpéraFranceInès Thomas48973602122020NULL
41154Strasbourg KléberFranceInès Thomas4656290812020Apple Pay
411617Bilbao AbandoSpainPaula Martínez4463763072021NULL
41174Paris LouvreFranceManon Thomas5271506342021NULL
411932Göteborg AvenynSwedenWilliam Larsson5131913132022NULL
41216San Francisco Market StUnited StatesLiam Smith5115351262021NULL
412223Yokohama MinatomiraiJapanYuto Ito4569935442023NULL
412414Torino CentroItalyLeonardo Colombo4423096442024NULL
41259Shenzhen FutianChinaHao Xu6253155062021NULL
412615Firenze Santa Maria NovellaItalyMatteo Esposito5513847632024NULL
412719München MarienplatzGermanyElias Schneider4551767862023NULL
41282Paris La DéfenseFranceInès Lefebvre4044479992021NULL
41291Lyon BellecourFranceHugo Moreau55306244122021NULL
41305Manhattan MidtownUnited StatesEmma Smith5477283592024NULL
413131Warszawa ŚródmieściePolandSzymon Kamiński5344771782020NULL
413215Firenze Santa Maria NovellaItalyBeatrice Colombo40171554122023NULL
41334Strasbourg KléberFranceChloé Robert4333113782021NULL
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;