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

card_payment, page 136 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
39151Paris OpéraFranceGabriel Simon52930151102019NULL
39163Toulouse CapitoleFranceArthur Martin5107499342022NULL
39174Paris LouvreFranceGabriel Simon5205479522019NULL
39182Paris La DéfenseFranceLucas Bernard4597373692020NULL
391916Sevilla TrianaSpainMateo García4864913412019NULL
39204Strasbourg KléberFranceInès Lefebvre4418081072022NULL
392121Brasília Asa SulBrazilDavi Santos51951454102023NULL
392230Saint Petersburg NevskyRussiaMikhail Vasiliev54991996102022NULL
392332Stockholm Sergels TorgSwedenElsa Andersson5173648812021NULL
392528Rotterdam CoolsingelNetherlandsLucas Bakker5235509712020NULL
392619Hamburg JungfernstiegGermanyLea Koch4128880962021NULL
39279Shenzhen FutianChinaWei Zhang5191598272019Apple Pay
39284Strasbourg KléberFranceManon Bernard5324059962021NULL
39291Lyon BellecourFranceHugo Robert4198275672023NULL
393016Madrid Gran VíaSpainHugo Martín5500717772020NULL
39314Strasbourg KléberFranceArthur Durand5466798832021Apple Pay
393321Brasília Asa SulBrazilMiguel Souza5396115312019Apple Pay
393416Sevilla TrianaSpainÁlvaro Gómez4154047142023NULL
393511London Canary WharfUnited KingdomFreddie Taylor4241967352021NULL
393625Seoul GangnamSouth KoreaMin-jun Kang43110256112020NULL
393735Toronto Bay StCanadaWilliam Roy53027980102023NULL
393833Oslo BjørvikaNorwayEmil Larsen5132354962021NULL
393914Milano DuomoItalyLeonardo Romano5413536422023NULL
39405Chicago LoopUnited StatesLogan Johnson55914155112023NULL
394131Warszawa ŚródmieściePolandSzymon Kowalczyk52729323102021NULL
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;